aiiio3f的部落格

If your group deploys Microsoft Dynamics GP Great Plains ERP and you are reasoning on involving it to your eCommerce site, we would resembling to grant you opening prelude - wherever to start in on digging GP, tools, reconciliation options, limitations, pluses and minuses and others characteristic FAQ. Current interpretation of Great Plains is 10.0, we claim that it is commonsensical to be at enumerate on journal 9.0, preceding to set off ecommerce joint overhang - otherwise you will be reprogramming your unification next to journal acclivity. If you are on old versions, even more 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 before), we propose you prime climb to MS SQL Server based altered copy (you should interaction you MBS VAR and they will distribute you beside the migration device and it is advisable that white-collar Great Plains expert does the changeover)

1. Sales Order Processing faculty or SOP. This ability is naturally incorporated next to your e-commerce application. In eCommerce you compile either SOP Order or SOP Invoice. The easiest script is to make up command or demand for payment in need stock list items allocation, this is mega recommended if you are testing to program integration in SQL keep procedures

2. Great Plains tables composition. This is one of the premier questions, which we hear from developers. You should login GP, depending on version, we will offer you the trail for reworked copy 10.0: Microsoft Dynamics GP->Tools->Resource Description->Tables. Tables are classified by GP series: Financial, Sales, Purchasing, Inventory, etc.

3. Microsoft Dexterity practical application. You should be alert that if you inhabit GP table records, you should dainty GP company logic as expected. The most principal is treating GP Dexterity business organisation logic, which is valid when Great Plains buyer request tries to publication records, populated by you - if conglomerate philosophy is desecrated and could not be validated, Dexterity surface will impropriety out and you will cause GP ERP inoperable

4. eConnect. Yes, this is what you should balance to use whenever achievable in e-commerce. eConnect heart is set of SQL hold on procedures, which allow you to create, modify, take GP maestro annals (customer, vendor, stock list component part) and drudgery written record (such as SOP invoice, or SOP order), positive eConnect allocates tab or directive lines, so the shortening of substance one is not a hurdle here. What eConnect can not do is situation own dealing or SOP shipment - this treatment is vanished to GP hand by GP architecture

5. Posting Server. Alba Spectrum Posting Server allows you combine eConnect near autoposting straight from eCommerce standing. Posting restaurant attendant is GP Dexterity submission and should be installed on disjunct GP workstation (or your GP server, where you hold on to GP workstation with Posting dining-room attendant running). When deploying bill dining-room attendant - you will entail to lodge authorized batches to belief tables and notice restaurant attendant will pilfer exactness of bill process