Microsoft Dynamics GP Advanced Customization - Autoposting
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
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, Germany, Continental Europe, Russia and having locations in multiple states and internationally ( http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer
Your Article Search Directory : Find in Articles
Recent articles in this category:
- Web Development Projects - Developers Tools Tips
Open source usually refers to software that is released with source code under a license that ensur - A Guide to Cnc Kits
Building a CNC machine means that you would require a lot of tools, parts or different components. - Xlphoto Printing, the Best Choice for Banner Printing and Poster Printing
Suppose, you have visited a tourist spot or a hill station; over there, you have witnessed some of - Reliable Software Programming
Software reliability is an important facet of software quality. It is defined as "the probability - Designing an Ecommerce Site
In a recent article I talked about Google AdSense placement based on eye-tracking research. Howeve - Asp.net Development Benefits
Rightway solution has been keenly looking out for. Microsoft ASP.NET is a free technology that allo - Choosing Offshore Software Development Company
To turn into successful and gain the full benefits of software outsourcing, you require preferring - E-commerce and Web Portal Development in Vietnam
VIETNAM, owing to its superior intellectual capital has emerged as the ultimate destination for - Types of Softwares
Computer software is a general term used to describe a collection of computer programs, procedur - Offshore it Out Sourcing Consultancy in Vietnam
Vendors who provide Off shore IT Outsourcing Consultancy services are referred to as outsourcing
Most viewed articles in this category:
- Oracle Applications (Oracle E-Business Suite) Customizations: What is it?
Oracle recommends every company that installs Oracle Applications to avoid any customization, but I - Offshore Outsourcing: An All Win Premise
The awareness that outsourcing can boost productivity sans forfeit of class has impelled MNC’s - Oracle E-Business Suite vs. Microsoft Dynamics AX - Axapta: LATAM and Brazil
In this small article we will only concentrate on Microsoft Dynamics Axapta (and will not consider M - SAP Business One vs. Microsoft Dynamics GP - highlights for consultant
In this small article we will not make side-by-side technical specs comparison. We would rathe - Microsoft Great Plains - licensing and product versions
Current Microsoft Business Solutions Great Plains has more that 10 years of history. Former Gr - OCR Software - Optical Character Recognition or Optical Crud Recognition?
Optical Character Recognition (OCR) refers to a software technology and processes that involve the t - Microsoft Dynamics AX - Axapta - technical notes plus customization
Axapta or current name Microsoft Dynamics AX has one of the newest ERP design and architecture among - Microsoft Dynamics AX-GP-NAV-CRM: trends and international recommendations
Microsoft Great Plains/Microsoft Dynamics GP, Microsoft Navision (former Attain) Microsoft Dynamics - Microsoft Moves to Small Business Accounting/Retail Market - stakes and thoughts
In this small article we will be looking at the new opportunities for Microsoft Small Business Serve - Microsoft Axapta - Dynamics AX: Brazilian Portuguese version - consultant highlights
Axapta/Microsoft Dynamics AX short overview. Navision Axapta was designed by Navision Software