| |
Microsoft Dynamics GP Advanced Customization – Autoposting
By Andrew Karasev
If you are developer or application consultant, who customizes and integrates Microsoft Great Plains with eCommerce applications, you probably already come across the problem of autoposting when you already fed in and created working batch in SOP, POP, Payroll, etc. Typical eCommerce example – you can create SOP Order or Invoice and even apply deposit or payment against this document, however it is not clear how to post the batch automatically – eConnect leaves it to the operator for verification and approval. You can have many different customization approaches to do the job – in this small article we would like to share with you very elegant method, using GP Dexterity process server to do the job:
• Dexterity Engine. Microsoft Dexterity or former Great Plains Dexterity is currently the engine for so-called fat client, it processes according to the dictionary (DYNAMICS.DIC) and this dictionary (plus few so-called third party dictionaries) plays all the business logic of Microsoft Dynamics GP.
• Dexterity Posting Logic. Instead of trying to replicate pretty complex posting logic of Dynamics GP in SQL Stored Procedures, it is better idea to deploy Dexterity Posting logic directly. You simply "provoke" Microsoft Dynamics GP workstation to post at the certain event firing, provoking in the sense that Dexterity thinks that operator pushes Post button on the batch or master posting forms
• Scenario. You use eConnect to create work documents and place them into the batch, you do not do any posting, you just "signal" in one custom table that this specific batch in AP is ready to be posted. Customized Great Plains workstation, running permanently, say on the processing server, checks every few seconds this signaling table and finds that batch is ready to be posted. It calls Dexterity Posting chain of procedures in AP module to do the job.
• Upgrade Safe Customization. If you try to implement posting logic in SQL Stored Procedure, every new version will require fundamental revision for your SQL scripts. If you call Dexterity procedures, you just verify that the interface is still the same and upgrade is pretty simple
• Smart Integration. The described logic allows you to deploy auto posting in any GP module, where posting is applicable. We know examples when customer deploys this smart logic for the integration. Imagine, you can advance GP Integration Manager data import with auto posting to provide automatic on-going data conversion and feeding from your legacy or third party accounting or MRP system
• For Web Developer. All you need to do is deploy eConnect or relatively simple SQL Stored Procedure to feed order data into work tables: SOP10100, SOP10200, etc. You do your job in Visual Studio.Net C# or VB and then Dexterity posting engine does the rest of the job
Give us a call 1-866-528-0577 or help@albaspectrum.com if you need additional information or directions.
About the Author
Andrew Karasev is technical consultant at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.ronix-systems.de http://www.enterlogix.com.br ), serving clients in Illinois, California, Texas, New York, Florida, Louisiana, Georgia, New Jersey, Washington, Pennsylvania, Ohio, Michigan, Wisconsin, Arizona, Nevada, and having locations in Brazil, Colombia, Chile, Argentina, Germany, Mexico. We have industry experience in Aerospace and Defense, Conglomerates, Pharmaceutical, Beverages, Manufacturing, Logistics, Consignment, Transportation, Oil & Gas, Healthcare, Advertising & Publishing, non-for-profit, Finance, Construction & Building, Wholesale & Retail, Distributions, Barcoding & Warehouse Management.
Article Source: http://www.simplysearch4it.com/article/27737.html
| If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/27737.html" as shown above and make it hyperlinked. |
| Some other articles by Andrew Karasev | SAP Business One Implementation for Multinational Companies with subsidiaries in Brazil
SAP B1 has over 200 installations in Brazil at this time and the number of new customers is growing. In this article we would like to recommend SAP BO as ...
SAP Business One in Illinois: implementation, upgrade, customization, integration
Chicago metropolitan area and downstate Illinois might be characterized as mid-west distribution place. This means that we see large number of diversified mid-size ...
SAP Business One Chicago Market Review, plus customization, integration & data conversion
SAP B1 is becoming more popular in the USA, increases number of implementation each year substantially. Originally designed by one of the Israel software development companies, now it is part of SAP ...
Microsoft Dynamics GP Office Stack Integration advances –
Microsoft Great Plains Dynamics GP is on the way of Microsoft Dynamics or former Microsoft Project Green advances. Great Plains Dexterity is still a core of fat client workstation plus it defines ODBC Dex ...
eConnect and Microsoft Dexterity: Dynamics GP development tools comparison notes
This article is dedicated to Microsoft Great Plains eCommerce and web software development primarily, plus Microsoft Dynamics GP customization, integration, data conversion and reporting. As software ...
Microsoft Dynamics GP Dexterity Customization
Microsoft Great Plains software development, customizations, reporting. Microsoft Dexterity programming as reliable alternative to newer technologies and platforms, such as .Net, C# and VB MS Visual ...
|
|
| |
|
