k0ight78的部落格

If your association deploys Microsoft Dynamics GP Great Plains ERP and you are rational on involving it to your eCommerce site, we would like-minded to pass you pilot initiation - wherever to set in train digging GP, tools, integration options, limitations, pluses and minuses and others common FAQ. Current version of Great Plains is 10.0, we imagine that it is valid to be at roll on edition 9.0, anterior to originate ecommerce connectedness project - other you will be reprogramming your integrating beside edition incline. If you are on senior versions, peculiarly on Pervasive SQL 2000/Btrieve or Ctree/Faircom (this may perhaps be the armour if you are on GP 7.5, 7.0, 6.0 or closer), we recommend you front raise to MS SQL Server based copy (you should communication you MBS VAR and they will deal in you beside the migration utensil and it is advisable that administrative Great Plains practitioner does the change)

1. Sales Order Processing mental faculty or SOP. This power is as usual integrated near your e-commerce application. In eCommerce you concoct either SOP Order or SOP Invoice. The easiest playscript is to create command or schedule without list items allocation, this is especially recommended if you are difficult to program merging in SQL hold on procedures

2. Great Plains tables support. This is one of the early questions, which we perceive from developers. You should login GP, depending on version, we will snap you the way for version 10.0: Microsoft Dynamics GP->Tools->Resource Description->Tables. Tables are sorted by GP series: Financial, Sales, Purchasing, Inventory, etc.

3. Microsoft Dexterity profession. You should be cognisant that if you live GP array records, you should pleasure GP concern logic suitably. The furthermost substantial is treating GP Dexterity business organization logic, which is validated when Great Plains case entry tries to publication records, populated by you - if company logic is profaned and could not be validated, Dexterity surface will nonaccomplishment out and you will clear GP ERP inoperable

4. eConnect. Yes, this is what you should think to use whenever realistic in e-commerce. eConnect soul is set of SQL keep procedures, which let you to create, modify, take away GP creative person accounts (customer, vendor, inventory component part) and toil transactions (such as SOP invoice, or SOP command), positive eConnect allocates invoice or dictation lines, so the cutting of subject matter one is not a challenge here. What eConnect can not do is mail personal vending or SOP shipment - this regular is larboard to GP operator by GP architecture

5. Posting Server. Alba Spectrum Posting Server allows you reaper eConnect with autoposting direct from eCommerce petition. Posting waiter is GP Dexterity submission and should be installed on discrete GP workstation (or your GP server, where you keep GP digital computer near Posting restaurant attendant running). When deploying placard waiter - you will involve to set accepted batches to bespoke tables and bill waiter will lift contemplation of poster process