Wednesday, 15 February 2012

Overview of e-commerce development from Microsoft Great Plains Dynamics GP 10.0

10.0 SQL Server 2005 is the application of the Microsoft Dynamics GP, however, SQL scripts, in order to integrate the feed or purchase orders and invoices and payment of e-commerce, integration of GP business logic and data rich, directly required for may become complex for verification. e-commerce is usually to send sales data to the module order processing of the Great Plains has been e-connect the area covered actually, we are following, but check the e-connect easily with this article , the first study, we recommend e-connect technology of Microsoft Dynamics GP. You are when you try to limit the integration, is also OK data directly feeding through a SQL stored procedure: do not assign an item of inventory on the line SOP, rather than orders, in the SQL script of your (the invoice Create a) to avoid build up the distribution of the GL. Let's get started:iPhone Developer

A. e-connect. Been developed for the programmer of e-commerce special SDK tools and, in the e-connect advanced Microsoft Business Solutions later, and now has modules cover other: If you dig deeper, POP, payroll You are a set of SQL stored procedure that has been encrypted is the heart of e-connect grasp, calculations, and general ledger. These steps, you can not change the transaction of a master and a work record, delete, or create, to mimic the agility of the business logic of GP. Connect it via e-verify the business logic of the index, MBS for developers of e-commerce has been recommended, you must be a tool that is recommended. If you believe that that is not related tools for you that your e-connect, and go ahead, you can take the root of the SQL query

Two. SQL. In this case, you must be familiar with your familiarity of GP SQL table. [Description of the resource] -> [Tools] -> [table: see table optimum can be found in GP workstation. The table is sorted in the series, the physical name of the table, we jump to SOP10100 sort of sales - this is to keep the header sales order, invoice, return, of the referenced document, the sales table is a header. Inventory items or non-inventory items: sales document items of this shop - the second table, you will SOP10200 Android App Development

Three. e Connect and batch posting. GP architecture, there are several phases of the life of the transaction. Only work, work, history and open, the transactions between these phases, may be created in the e-connect, you can submit for the approval of GP operators. e-commerce applications to post a payment to your invoice plus often would like the invoice to be posted and scheduled for delivery. In such a case, the technology must study is an extension of the order to e-connect, the Server Posted Alba Spectrum, it is to appeal to the source code of the index, is an application agility of the Great Plains - The location of the developer approved the batch of GP to a custom table, call the native GP Dexterity post the server. Logic used to post the batch iPhone app development

Four. Integration Manager of GP. The relatively low amount of e-commerce transactions, if a small organization, you may want to consider e-commerce transactions via the IM integration overnight. IM, so to expand the GP as an OLE server, GP workstation, you will need to run behind the scenes. Some customers report a problem with the performance of IM is the scenario OLE server that supplies the data to screen GP When you open a form or hidden, as usual.

No comments:

Post a Comment