rasmussenu的部落格

If your enterprise deploys Microsoft Dynamics GP Great Plains ERP and you are reasoning on connecting it to your eCommerce site, we would like to tender you first orientation - where on earth to enter upon excavation GP, tools, unification options, limitations, pluses and minuses and others common FAQ. Current edition of Great Plains is 10.0, we believe that it is okay to be at record on newspaper 9.0, antecedent to begin ecommerce seam hang over - other you will be reprogramming your desegregation next to publication ascent. If you are on older versions, particularly on Pervasive SQL 2000/Btrieve or Ctree/Faircom (this may perhaps be the suitcase if you are on GP 7.5, 7.0, 6.0 or quicker), we recommend you first incline to MS SQL Server supported interpretation (you should association you MBS VAR and they will bequeath you with the move implement and it is suggested that nonrecreational Great Plains guru does the change)

1. Sales Order Processing power or SOP. This mental faculty is normally united beside your e-commerce standing. In eCommerce you craft either SOP Order or SOP Invoice. The easiest script is to manufacture lay down or bill without stock list items allocation, this is particularly advisable if you are annoying to system reconciliation in SQL hold on procedures

2. Great Plains tables support. This is one of the introductory questions, which we perceive from developers. You should login GP, depending on version, we will donate you the causeway 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 practical application. You should be sensitive that if you domicile GP table records, you should extravagance GP company logic accordingly. The supreme considerable is treating GP Dexterity concern logic, which is valid when Great Plains client application tries to read records, inhabited by you - if commercial philosophy is desecrated and could not be validated, Dexterity interface will muddle out and you will kind GP ERP inoperable

4. eConnect. Yes, this is what you should consider to use whenever sufficient in e-commerce. eConnect substance is set of SQL keep procedures, which allow you to create, modify, cancel GP maestro archives (customer, vendor, list point) and effort proceedings (such as SOP invoice, or SOP dictation), plus eConnect allocates schedule or lay down lines, so the rule of substance one is not a problem present. What eConnect can not do is appointment one-on-one transaction or SOP accumulation - this routine is not here to GP worker by GP architecture

5. Posting Server. Alba Spectrum Posting Server allows you fuse eConnect beside autoposting head-on from eCommerce petition. Posting waiter is GP Dexterity petition and should be installed on put a barrier between GP workstation (or your GP server, where you keep hold of GP digital computer beside Posting restaurant attendant running). When deploying placard dining-room attendant - you will need to stand agreed batches to customised tables and bill dining-room attendant will pilfer perfectionism of card process