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:


Inside The Software That Shapes Your Music: Announcing A New Series
Earlier this summer, friend and colleague Zack O'Malley Greenburg published a fascinating book entitled Michael Jackson Inc. Its titular subject covered not only the music of the Gloved One, but took a concentrated look at the fiscal acumen of a titan ...

Wall Street Journal (blog)

AppDynamics Raises $120M, Valued at $1 Billion for Corporate Software
Wall Street Journal (blog)
For instance, AppDynamics' software now can help businesses figure out whether their applications are affecting the experience of users on their website, and if so whether the problems are costing that business revenue and how they can be fixed. A ...
AppDynamics Closes $120 Million in Growth Financing to Accelerate Platform ...Marketwired (press release)

all 33 news articles »

The National Law Journal (registration)

Feds Join Lawsuit Alleging Symantec Overcharged Agencies for Software
The suit alleges Symantec failed to disclose to government customers deep discounts it offered its favored commercial clients during the negotiation and performance of a 2007 multiple-award schedule software contract. That in turn caused agencies to ...
Software Maker Symantec Faces False Claims SuitThe National Law Journal (registration)
Feds hit software firm for false claimsThe Hill

all 12 news articles »

How to Govern Cheese: Or, Controlling Your Software Assets Through a ...
In many cases, these are a diverse set of endpoints including mobile devices used by individuals who hardly think twice at installing some new piece of software. In those instances, how is a manager even supposed to know where the devices are? Even ...

Senior-living software companies merge
The combined companies will result in one of the largest software companies in South Florida and one of the largest health care IT companies focused on seniors. Together, the companies employ more than 200 professionals and provide software solutions ...

iTunes Software and Services fastest growing Apple business segment this year
Apple Insider
iTunes Software and Services fastest growing Apple business segment this year. By AppleInsider Staff. During Apple's quarterly conference call for the third fiscal quarter of 2014, CEO Tim Cook said iTunes software and services was the fastest growing ...

and more »

International Business Times

Samsung Galaxy Note 4 Leaked Software Features Suggest Major Upgrades
International Business Times
The Samsung Galaxy Note 4 is expected to feature a QHD (1440 x 2560) resolution display and this “S-Studio” app could work in conjunction with a high-resolution screen. Files like “VRSVC” APK could offer software support for Samsung's rumored virtual ...

and more »

Healthdirect Australia looks through the 'software lens'
Haefele said the approach the organisation took from the get-go on making decisions was to look at everything through a "software lens" based on the knowledge that software applications was going to play a crucial role for the business going forward.

Hospitals upgrade software to improve ambulance service
Springfield News-Leader
Michelle Leroux, a spokeswoman for CoxHealth, said the health system is updating its software to let dispatchers visually compare what ambulances are available. "We have had software that allows the dispatchers to see available ambulances for a number ...

and more »


Nuance's speech-recognition software gets smarter & more hardware-friendly
Today, Nuance announced the latest incarnation of its popular software, Dragon NaturallySpeaking 13, which promises to be faster and more accurate than previous versions. Dragon's accuracy largely comes from its ability to learn your writing style and ...
Nuance Unleashes Its Latest 'Dragon' Speech SoftwareBusinessinsider India

all 12 news articles »
Google News

eStore Advantage ? Extending Microsoft eConnect for MBS Great Plains

eStore Advantage allows front-office applications to communicate with back-office business... Read More

Microsoft CRM for Large Corporation ? Security

Microsoft Business Solutions CRM proved to be reliable solution in... Read More

.Net Charts and Graphs Interact with Businesses and Customers

Bar charts, bar graphs, and any other chart or graph... Read More

Adware and Spyware Blockers

The most important things you can do for your computer... Read More

Free PDF Publishing Software

In a previous article, I wrote about OpenOffice... Read More

Reduce Pop-ups and Annoying Ads

There is many things more frustrating than surfing a website... Read More

25 Things Mapping Software Can Do For You

1. With mapping software you can create a report that... Read More

HelpDesk & Asset Management Software - Choosing The Right One

If you are to buy a HelpDesk & Asset Management... Read More

Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

Heard about the Quark "killer"?Adobe InDesign CS2. Will it really... Read More

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

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

Microsoft CRM Messaging through Lotus Domino eMail Server - Balanced Solution

Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More

.NET :Solving the Multiple Inheritance Issue Under .NET Platform

.NET platform does not support multiple inheritance. Do not confuse... Read More

Linux ? Keyboard Or Mouse

Just stress testing one of the latest Linux distributions. Been... Read More

Explore the Internet in a Whole New Way

For a long time now Microsoft's Internet Explorer has ruled... Read More

The Truth: Netzero 3G

We've all seen the ads on TV for Netzero 3G.... Read More

Great Plains Dexterity: Customizations & Source Code Programming

Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on... Read More

Microsoft Great Plains Installation ? Overview for IT Director/Controller

Microsoft Great Plains is main mid-market application from Microsoft Business... Read More


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

C++ Tutorial 1, Introduction to C++

Introduction to C++Why Learn C++?C++ may at first seem like... Read More

Microsoft Great Plains Subcontracting ? Overview for Microsoft Business Solutions Partner

Microsoft Business Solutions Great Plains is very popular ERP/MRP applications... Read More

Microsoft RMS Customization ? PO Items Receiving in Great Plains

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

Microsoft Great Plains Oil & Gas ? Implementation & Customization Highlights

Microsoft Great Plains serves the wide spectrum of horizontal markets.... Read More

Crystal Reports For Microsoft RMS ? Overview For Developer/Report Designer

If you are software developer or database administrator - we... Read More

Four Desktop Tools To Drastically Increase Your Productivity

Sticky Notes StickyNote 9.0, you can create beautiful 3D notes... Read More

Benefits of Shareware

Shareware has been fighting the stigma of being misunderstood for... Read More