Microsoft Great Plains: exchange & brokerage ? implementation notes

If you company is small or mid-size special products or materials exchange broker, you probably have custom in-house made exchange application. Nowadays exchange is done over the internet, so you might have advanced web-based exchange application. Microsoft Business Solutions Great Plains could play the role of the backend: accounting, sales and purchasing ordering, backordering, allocation, collection. In this case we expect tight integration between your exchange application and Great Plains. In this small article we consider industry / market niche specifics and the ways to realize these requirements:

? Exchange Transaction. Exchange transaction usually has two parts: Sales and Purchasing. This transaction should be translated into Great Plains as Sales Order in Sales Order Processing (SOP) and Purchase Order in Purchase Order Processing (POP). Assuming that you have web developers and C#, VB.Net programmers, you can deploy eConnect Distribution ? this is Software Development Kit with sample codes, you can create or modify Great Plains objects, such as Sales Order, Customer record, Purchase Order, Vendor record. One warning about eConnect ? it is designed based on general ERP application principles: you can create work transaction only ? you can not post transaction, this is left for the Great Plains user

? Bill of Lading. In materials selling, when you order something you probably know number of packs or bundles, but you do not know exact weight or length. You get this information when you receive Bill of Lading. You need Bill of Lading automatic integration and qty update in Sales Order or Purchase Order. At this moment you do Sales Order allocation. eConnect, mentioned above should do the job

? Agent Commission. You could use Salesperson, associate him/her with items sold in Sales Order and then calculate and pay commission, using your own formulas.

? Reporting. In the case of integrated web application with Great Plains, we would expect heterogeneous sql queries and reporting, based on these queries and stored procedures. To produce nice and flexible reports ? you usually deploy Crystal Reports and publish them in your web application.

? Transaction Posting. As mentioned above ? this should be preferably done by Great Plains user with approval logic. However if you have thousands transactions per day or hour and it is physically not possible, you should go beyond eConnect functionality and post transactions automatically. You need custom stored procedures, posting and transferring Sales Orders. You can create these procedures yourself or purchase the ones, available on the market.

? Customization Tools: Great Plains Dexterity, Modifier with VBA, Transact SQL scripting to name the most popular.

Good luck and you can always seek our help in customization, implementation, integration and support. Call us: 1-866-528-0577 or 1-630-961-5918,

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies ? USA nationwide Great Plains, Microsoft CRM customization company, serving Chicago, California, Arizona, Texas, Florida, Georgia, New York, Australia, UK, Canada, Continental Europe, Russia and having locations in multiple states and internationally ( ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer

In The News:


Despite Big Cash Hoard, Tableau Software Is Patient In Acquisition Hunt, CFO ...
Something that adds to the company's offerings in terms of products or enhancements to Seattle-based Tableau's existing lineup of data visualization software, he said. Tableau isn't interested in a deal that might be outside its expertise and comfort zone.
Company Price Target Watch: Tableau Software, Inc. (NYSE:DATA)Markets Daily

all 3 news articles »


New York firm to acquire Boulder's Rally Software for $480 million
The Denver Post
Creating software to help companies zip through product development made Rally Software Development Corp. an acquisition target. The winner? It's New York software giant CA Technologies, which Wednesday said it would acquire the Boulder firm for ...
Colorado Trendsetter Rally Software Takes CA's $480M Takeover OfferXconomy
CA Technologies (CA) to Acquire Rally Software (RALY) in ~$480M
Rally Software Development (RALY) Stock Surging on CA Technologies
ZDNet -Motley Fool -Wall Street Journal
all 76 news articles »


Software-defined data center market to hit $77.18 billion in 2020
A new report issued this week by Research and Markets explains that the software-defined data center market will hit $77.18 billion by the year 2020, which is up from the $21.78 billion it's expected to rake in for 2015. The term software-defined data ...

and more »

IBM pitches analysis software for select industry verticals
Extending the reach of its analysis software and services, IBM plans to release 20 analytics packages customized to the needs of specific industries. Available by the end of June, the packages will target businesses in retail, banking ...

and more »

The Guardian

Google unveils Android 'M' software with focus on security and battery life
The Guardian
Google's next version of Android software for smartphones, tablets, watches and TVs is called “M” and will aim to beef up security while conserving battery life, the tech company announced on Thursday at I/O, its annual developer conference in San ...
Hyundai Adds Android Auto To 2015 Sonata Through Software UpdateForbes
Google claims new version of Android could DOUBLE your battery lifeDaily Mail
Google's Software for Cars Finally Hits the Road, in the 2015 Hyundai SonataYahoo Tech
Times of India -9 to 5 Google
all 2,006 news articles »

Forecasting felonies: How Oxford is using 'predictive policing software'
Oxford police for the last month has been testing a software program that helps patrols predict where crimes might happen. Hold the "Minority Report" jokes - this isn't the stuff of psychics and teams of police swooping in just prior to a violent crime ...

and more »

Wall Street Journal

GameStop Results Boosted by New Software Sales
Wall Street Journal
Downloads for new videogames and digital games boosted GameStop Corp. GME 3.67 % 's first-quarter profit as the retailer captured a 45% new-software market share, the company said Thursday. Sales at established stores—a key performance metric that ...
GameStop earnings rise as new software sales jump 9.6 percentDallas Business Journal

all 64 news articles »

LightSail Solar Sail Test Flight Stalled by Software Glitch
A tiny solar-sailing spacecraft has gone silent in Earth orbit, apparently victimized by a software glitch. LightSail, a CubeSat designed and built by the nonprofit Planetary Society, stopped beaming data home on Friday (May 22), just two days after it ...
Not quite smooth sailing! Revolutionary LightSail spacecraft knocked out by ...Daily Mail
Software Glitch Pauses LightSail Test MissionThe Planetary Society (blog)
Planetary Society's LightSail has gone

all 17 news articles »


Google Jump eases virtual reality creation with camera hardware, assembler ...
The second component is the assembler, the software for converting that raw video into VR. Much of the difficulty of shooting VR video is getting the camera geometry just right, and syncing the frames and the exposure, said Bavor. With Assembler ...
Google, GoPro bring virtual reality to the masses with JumpUSA TODAY

all 215 news articles »


Everything We Know About Apple's New iPhone Software
The company is expected to unveil iOS 9 at its annual Worldwide Developers Conference in June. A new iOS update isn't quite a big deal as a new iPhone, but the announcements can often be substantial–iOS 7 brought us a completely revamped mobile ...

and more »
Google News

Microsoft C# vs. VB.Net

Hi, Guys,I believe a lot of programmers are trying to... Read More

Microsoft Great Plains Beverage Production & Distribution ? Implementation & Customization Highlight

Microsoft Business Solutions Great Plains has many years of successful... Read More

Microsoft Great Plains SOP: Sales Order Processing

Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

Microsoft Business Solutions VAR/Partner Selection ? Overview for IT Director/Manager/Controller

Microsoft Great Plains and Microsoft CRM become more and more... Read More

Why Java RDBMS?

It is a well known fact that Java as a... Read More

Lotus Domino: Reports and Connectors ? Crystal Reports, XML, ODBC/JDBC, OLE

Lotus Notes Domino is very efficient in electronic document workflow... Read More

6 Easy Steps for a Smoother CD/DVD Order

It's all about turn times in the eMedia industry! The... Read More

Microsoft Great Plains as ERP and Microsoft CRM as CRM

If you have Microsoft Great Plains and support it for... Read More

Lowering The Risks In Developing Do-It-Yourself Software Projects

Mike Dunville* had a decision to make. As the new... Read More

Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair ? Overview For DBAs

Some introduction into Great Plains Software products, now Microsoft Business... Read More

Device Driver Basics

Most people understand that the "hardware" part of their computer... Read More

Online PowerPoint Presentation ? Convert PowerPoint to Flash

Although we don't know whether Microsoft ever envisioned such a... Read More

Two Reasons to Use Timesheet Software

This short paper will expand on two key reasons to... Read More

The Bluebird Project

The objective for Zandi Digital is to make available clever... Read More

Microsoft CRM Customization: Integration with Third Party SQL Application/Database

Microsoft CRM ? Client Relationship Management package from Microsoft Business... Read More

Microsoft Great Plains - Microsoft RMS Integration ? overview

Microsoft Great Plains and Microsoft Retail Management System (Microsoft RMS)... Read More

How To Develop Software For Your Business

Software development is a risky business.Many software developers are barely... Read More

Instant Messenger Clients

If you have been using the Internet for any amount... Read More

How to Backup Windows XP Home Edition

Your computer cost you from hundreds to thousands of dollars,... Read More

Three Steps To Windows Safety Heaven

Now there are Three Steps To Heaven Just listen and... Read More

What is Preventive Maintenance Software?

Preventive Maintenance (PM) is defined as scheduled work done on... Read More


In order to implement VLANs in a network environment, you'll... Read More

Microsoft Great Plains: Offshore Customization & Development ? Overview for Consultant

When you visit department stores and see that majority of... Read More

Microsoft eCommerce Web-development: Great Plains eConnect .Net ? Highlights for Programmer

In our small article we'll consider Microsoft Business Solutions Great... Read More

Create A Flash Presentation For Free With Open Office

The intentions of this short tutorial are not to teach... Read More