Microsoft Great Plains has a good e-commerce web development tool: eConnect. This module allows you to schedule sales order processing orders, invoices, select inventory items and even add customers (here we are not considering the other eConnect features: POP, payroll, GL, etc.). There is some dismay with the development team when they finally realize that eConnect allows them to create work invoices and place them in the batch, but automatic batch publishing from the e-commerce application is really beyond eConnect's reach. This is actually an architectural constraint of Microsoft Dynamics GP, a former Great Plains Dynamics skill: working documents must be reviewed by the GP operator and published manually through the GP interface. These facts caused Alba Spectrum developers to build an automatic positioning server, which uses a GP workstation with modified logic to publish batches, marked for publication by e-commerce application. E-commerce developers generally work with Microsoft Visual Studio C # or VB.Net and do not need to know or program dex scripts. How does it work:
o Process of batch publication in GP. The automatic positioning server verifies the batch status table every 5 seconds. If you find an approved batch for publication, start an internal Dexterity process to publish the batch. The publishing server uses dex logic and, therefore, is very reliable for publishing business logic validation. The batch status table is part of the custom logic and you, as an e-commerce developer, must include the batch record in this table to allow it to be published
o Additional GP licenses. The publishing server must be installed on a separate GP workstation, which must always be on, and must process e-commerce orders as they come in 24×7 / 365.
o Assignment of sales documents. If you are working with eConnect, you probably do not think about this inventory item assignment question, however, your accounting counterpart may ask you this question. Don't worry, eConnect validates the GP logic and, as written in the SQL stored procedures, replicates the GP skill logic, including line item assignment
o Skill excursion. This is the core of GP, if you think of DYNAMICS.DIC – this is the business logic dictionary and table structure, which is being used by dex.exe – this is the Dexterity application file. To deepen your understanding of dex, review the Dynamics.set file to analyze what products you use for your company and your dex.ini file to understand your skill settings. One of the additional tips: if you need to resync your GP workstation with a new or modified GP account segmentation, you must modify the dex.ini line: change Synchronize = FALSE to Synchronize = TRUE