eCommerce Programming for Excellent Plains Dynamics GP – Introduction

If your organization deploys Microsoft Dynamics GP Excellent Plains ERP and you are imagining on connecting it to your eCommerce web page, we would like to give you first introduction – wherever to get started digging GP, tools, integration options, limits, pluses and minuses and some others typical FAQ. Present-day version of Excellent Plains is 10., we think that it is reasonable to be at list on model 9., prior to start off ecommerce connection undertaking – in any other case you will be reprogramming your integration with version update. If you are on more mature versions, specifically on Pervasive SQL 2000/Btrieve or Ctree/Faircom (this could be the scenario if you are on GP 7.5, 7., 6. or before), we propose you to start with up grade to MS SQL Server centered variation (you really should get hold of you MBS VAR and they will provide you with the migration resource and it is advised that professional Good Plains expert does the conversion)

1. Product sales Purchase Processing module or SOP. This module is ordinarily built-in with your e-commerce application. In eCommerce you build either SOP Purchase or SOP Invoice. The least complicated circumstance is to build purchase or bill with no stock products allocation, this is specially advisable if you are attempting to plan integration in SQL saved strategies

2. Great Plains tables structure. This is just one of the very first queries, which we listen to from builders. You really should login GP, dependent on version, we will give you the path for edition 10.: Microsoft Dynamics GP->Tools->Resource Description->Tables. Tables are grouped by GP sequence: Economical, Product sales, Paying for, Inventory, etcetera.

3. Microsoft Dexterity technology. You ought to be mindful that if you populate GP desk documents, you really should address GP company logic accordingly. The most important is treating GP Dexterity small business logic, which is validated when Terrific Plains client software tries to go through information, populated by you – if enterprise logic is violated and could not be validated, Dexterity interface will error out and you will make GP ERP inoperable

4. eConnect. Yes, this is what you need to consider to use when possible in e-commerce. eConnect main is established of SQL saved treatments, which allow you to make, modify, delete GP learn information (client, seller, stock merchandise) and perform transactions (this kind of as SOP bill, or SOP get), moreover eConnect allocates invoice or buy lines, so the limitation of subject just one is not a problem right here. What eConnect can not do is put up individual transaction or SOP batch – this routine is remaining to GP operator by GP architecture

5. Submitting Server. Alba Spectrum Putting up Server will allow you blend eConnect with autoposting right from eCommerce application. Posting server is GP Dexterity application and must be set up on different GP workstation (or your GP server, where by you hold GP workstation with Posting server functioning). When deploying putting up server – you will need to position permitted batches to custom made tables and putting up server will consider care of publishing course of action