Ecommerce Programming for Good Plains Dynamics Gp – Introduction

If your corporation deploys Microsoft Dynamics GP Good Plains ERP and you are pondering on connecting it to your eCommerce site, we would like to give you initial introduction – the place to get started digging GP, resources, integration solutions, restrictions, pluses and minuses and other individuals typical FAQ. Present-day version of Good Plains is ten., we assume that it is acceptable to be at record on version nine., prior to get started ecommerce relationship venture – if not you will be reprogramming your integration with version up grade. If you are on older variations, especially on Pervasive SQL 2000/Btrieve or Ctree/Faircom (this could possibly be the scenario if you are on GP seven.five, seven., 6. or before), we endorse you initially up grade to MS SQL Server based mostly version (you should really contact you MBS VAR and they will deliver you with the migration instrument and it is suggested that experienced Good Plains expert does the conversion)
one. Sales Purchase Processing module or SOP. This module is generally integrated with your e-commerce software. In eCommerce you create possibly SOP Purchase or SOP Invoice. The best scenario is to create get or bill without having stock merchandise allocation, this is especially suggested if you are hoping to application integration in SQL stored strategies
two. Good Plains tables construction. This is one particular of the initially concerns, which we hear from builders. You should really login GP, dependent on version, we will give you the route for version ten.: Microsoft Dynamics GP->Tools->Resource Description->Tables. Tables are grouped by GP collection: Financial, Sales, Getting, Stock, and so on.
three. Microsoft Dexterity technology. You should really be aware that if you populate GP desk information, you should really treat GP organization logic appropriately. The most important is managing GP Dexterity organization logic, which is validated when Good Plains shopper software attempts to go through information, populated by you – if organization logic is violated and could not be validated, Dexterity interface will mistake out and you will make GP ERP inoperable
4. eConnect. Sure, this is what you should really take into consideration to use when possible in e-commerce. eConnect main is set of SQL stored strategies, which enable you to create, modify, delete GP master information (shopper, seller, stock item) and work transactions (these kinds of as SOP bill, or SOP get), in addition eConnect allocates bill or get lines, so the limitation of subject one particular is not a problem right here. What eConnect can not do is publish unique transaction or SOP batch – this program is left to GP operator by GP architecture
five. Posting Server. Alba Spectrum Posting Server allows you incorporate eConnect with autoposting specifically from eCommerce software. Posting server is GP Dexterity software and should really be set up on independent GP workstation (or your GP server, the place you preserve GP workstation with Posting server running). When deploying putting up server – you will need to area approved batches to custom tables and putting up server will take care of putting up method