eCommerce Programming for Great Plains Dynamics GP – Introduction

If your business deploys Microsoft Dynamics GP Great Plains ERP and you are pondering on connecting it to your eCommerce web page, we would like to give you original introduction – wherever to get started digging GP, equipment, integration solutions, restrictions, pluses and minuses and other individuals usual FAQ. Recent variation of Excellent Plains is 10., we suppose that it is reasonable to be at listing on edition 9., prior to begin ecommerce relationship venture – normally you will be reprogramming your integration with edition enhance. If you are on more mature versions, specially on Pervasive SQL 2000/Btrieve or Ctree/Faircom (this may possibly be the case if you are on GP 7.5, 7., 6. or before), we advise you 1st upgrade to MS SQL Server dependent variation (you need to contact you MBS VAR and they will deliver you with the migration software and it is proposed that skilled Wonderful Plains expert does the conversion)

1.Income Purchase Processing module or SOP. This module is generally integrated with your e-commerce application. In eCommerce you make possibly SOP Buy or SOP Invoice. The least difficult circumstance is to produce buy or invoice without the need of stock items allocation, this is specially advisable if you are making an attempt to software integration in SQL stored techniques

2.Terrific Plains tables structure. This is 1 of the first thoughts, which we listen to from developers. You need to login GP, relying on version, we will give you the path for model 10.: Microsoft Dynamics GP->Tools->Resource Description->Tables. Tables are grouped by GP sequence: Financial, Sales, Acquiring, Inventory, etcetera.

3.Microsoft Dexterity technology. You really should be knowledgeable that if you populate GP desk data, you ought to treat GP business enterprise logic accordingly. The most vital is managing GP Dexterity small business logic, which is validated when Excellent Plains consumer software tries to read records, populated by you – if enterprise 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 must look at to use when achievable in e-commerce. eConnect main is established of SQL stored strategies, which permit you to produce, modify, delete GP learn data (client, seller, stock product) and do the job transactions (these as SOP bill, or SOP order), as well as eConnect allocates bill or get traces, so the limitation of topic 1 is not a difficulty below. What eConnect can not do is post personal transaction or SOP batch – this plan is remaining to GP operator by GP architecture

5.Submitting Server. Alba Spectrum Submitting Server enables you incorporate eConnect with autoposting immediately from eCommerce software. Submitting server is GP Dexterity application and should really be installed on individual GP workstation (or your GP server, the place you continue to keep GP workstation with Submitting server managing). When deploying posting server – you will will need to spot accepted batches to tailor made tables and submitting server will choose treatment of putting up system