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:

Wall Street Journal

Facebook Says Planned Software Changes Caused Outages
Wall Street Journal
Facebook has been investing in data-center technologies that rely on software that can be updated quickly to respond to a spike in users. This includes networking equipment powered by Facebook-written software that funnels data among its computers and ...
Facebook Outages Caused by Planned Software ChangesNewsweek
​Facebook outages caused by failed software updatesZDNet
Here's why Facebook's been going down latelyFortune

all 4 news articles »

Software Guard Extensions on Specific Skylake CPUs Only
Through the staggered release of Intel's 6th Generation Core processors, known as Skylake, we reported in our architecture deep dive that Intel would be introducing a raft of known features, including Software Guard Extensions (SGX) among others.

and more »

Slack is going to eat your old office software alive
The Next Web
For most medium to large businesses, productivity software has been something of a spaghetti bowl. You might have a tool like Yammer for internal social networking, Google Apps for email, Microsoft Office for document editing and GoToMeeting for video ...


Software company CEO boosts bee population on company grounds
(WXYZ) - A software company in metro Detroit creates a lot of buzz around this time each year. Stardock --a software and gaming company based in Plymouth—was started by Brad Wardell more than 20 years ago. And about 10 years ago, Wardell decided he ...

and more »

Life's too short to rush into software updates
Whether it's Apple iOS 9 or Android 6.0, Windows or Mac, there's no reason to rush into major software updates. There's an old saying in the PC world; wait for Service Pack 1 before you upgrade your old computer to a new version of Windows. These words ...

and more »


Goldman Sachs CIO on How Software Is Eating Finance (Full Video)
He also talked about Goldman's strategy for obtaining software, favoring open source options whenever possible, and putting the firm's army of 11,000 engineers to work building it when it's not. He also chatted about Goldman's involvement with Symphony ...

Times of India

Maharashtra seeks to be India's top software exporter
Times of India
MUMBAI: The state government wants to ramp up IT exports to bridge the gap with the country's leading software exporter, Karnataka. It has prepared a policy that promises several sops for IT and IT-enabled services (ITES) companies to set up shop in ...

People and software putting global nuclear facilities 'at risk' of cyber attack
UK THINK-TANK Chatham House has warned that the local nuclear industry is at increased risk of cyber attack, presumably just because it exists and apparently because it is crap. Everything is at risk. Everything from websites aimed at mums, to websites ...

and more »


T-Mobile's Software Updates page now tracking Android 6.0 Marshmallow updates ...
Because nobody likes scratching their head and wondering when their device will get updated to Google's latest, T-Mobile's Software Updates page lets regular 'ol users like you and I follow along as our beloved devices go about the usual carrier ...
Android Marshmallow begins rolling out to Nexus devices todayEngadget

all 642 news articles »

Financial Post

Microsoft Office 2016 review: Collaboration is king in new software suite ...
Financial Post
With the company's emphasis on “as-a-service,” chances are that all we'll get from now on is continually updated software, available by subscription and quietly changing behind the scenes without new version numbers attached. For now, however, we have ...

and more »
Google News

Microsoft Great Plains: If You are Orphan Client ? What to Do and FAQ

Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise,... Read More

Do You Want Your Own Fully Programmable ERP? - Part 1

We are in a transition phase in the Managerial Administration... Read More

Unwanted Files

A LOT OF UNWANTED FILES.When you uninstall an item of... Read More

Microsoft Great Plains - Microsoft RMS Integration ? overview

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

Lotus Domino Implementation and Development: Infrastructure ? Present and Future

Domino server is a buffer between the operation system and... Read More

How to Tell You Have Spyware, Ad-ware or Viruses

Usually, the easiest way to tell you have spyware is... Read More

Microsoft Great Plains in Construction & Building ? Implementation & Customization Highlights

Microsoft Great Plains could be tuned and setup to fit... Read More

Builders Beware

Which Type of Shop Can Rely On A Home Built... Read More

Protect Your Computer...and Your Business!

We all take the computer for granted. I mean, all... Read More


Before September 1995, Microsoft Windows was an MS-DOS program. DOS... Read More

Bridging the Gap between Paper and Data

The cornerstone of successful automated office systems is the ability... Read More

Microsoft and Webmasters

Does Microsoft care for WebmastersIt's always been a problem with... Read More

How to Build a Basic CSS Layout

Designing without tables by using CSS layouts is fast becoming... Read More

Navision Sales Module & Reporting: Jet Reports, C/ODBC, XBRL, Business Analytics ? highlights

Microsoft bought Navision, Denmark based software development company, along with... Read More

Internet Relay Chat - A Basic Introduction

What is IRC?IRC is Internet Relay Chat. It is a... Read More

Microsoft Great Plains customization ? Freight Forwarding/Transportation industry example

Microsoft Business Solutions Great Plains version 8.5, 8.0, 7.5, Great... Read More

Enterprise Resource Planning Overview

ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief... Read More

Great Plains Dynamics/eEnterprise Upgrade ? Things to Consider and FAQ

If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More

Spyware, What is it?

Spyware, what it is and what it does. Basically, spyware... Read More

What is Groupware?

Vince Lombardi once said that, "The achievements of an organization... Read More

How To Identify, Cure and Prevent Spyware/Adware Infections

Just when you thought you were Web savvy, one more... Read More

Dont Choose Adobe When Working With PDF

While Adobe is the most known maker of PDF tools,... Read More

Microsoft Business Solutions - Navision Customization: C/SIDE, C/ODBC, C/FRONT, XBRL

Microsoft bought Navision, Denmark based software development company, along with... Read More

Corporate Accounting System: Microsoft Great Plains ? Overview

Corporate ERP/MRP selection might be tough one, especially considering very... Read More

Microsoft CRM: Data Conversion ? Import from Act!

Best Software Act! is very popular CRM for small and... Read More