Great Plains Automatic Batch Posting overview

If you know Microsoft Dynamics GP architecture, Dexterity business logic, you probably realized that standard Great Plains Integration tools, such as Integration Manager, eConnect, which are typically deployed in eCommerce integration scenarios, allow you create only so-called work transactions: SOP Invoice is the most popular transaction type

Work transaction is placed to the batch to be saved for future review and posting by GP user.  It is probably impractical to try posting batches through Dexterity from scratch programming, as you will spend a lot of hours just to getting through Dex programming learning curve, plus you will need Dexterity so-called source code to dive deep enough for finding the way to trigger batch posting programmatically.  In this article we are describing Posting Server product:

1.       Triggering batch for posting.  As being eConnect C# or VB.Net developer you have an instrument to create transaction, place it into the batch (and save by doing that).  Next, you should just place this batch record into posting queue table – this is custom table, where posting server monitors new records

2.       Dexterity engine.  The flexibility of this approach relates to the fact that posting server calls Dexterity posting procedure and so, it is pretty reliable in version upgrade, as posting procedures are one of the core functionalities of GP

3.       Posting batches in almost all modules.  As posting is done by Dexterity engine, it is typically unified for all the GP modules and so, posting server doesn’t have modules limitation.  Some restrictions apply, usually for third party add-ons to standard GP

4.       Integration Manager.  If you plan to deploy IM, then you should plan to populate queuing table with additional programming – simple SQL stored procedure will do the job

5.       Sales Order fulfillment.  If you are intermediate party or reseller, you can post batches in both Sales Order Processing module as well as in Purchase Order Processing, where you order from your vendors.  In this case posted Sales batch will trigger posted Purchasing batch

ABOUT THE AUTHOR