[ad_1]
If you are eCommerce developer, you probably sent Great Plains eConnect to integrate established ecommerce web site with GP ERP back office. eConnect is great tool, it allows you to create or update customer records, including addresses, create sales order or invoice in Sales Order Processing (SOP) module. eConnect business logic is realized as a set of stored procedures behind the scenes, these methods are encrypted, so you can not directly change them. You may soon realize that eConnect allows you to create so-called work transactions, but it does not have posting capabilities. Position after the GP operators, who have to verify sales invoice first and then post it in the session. It is often the case in eCommerce, that you want to send to do automatically in GP, initiated by the e-commerce application logic. In order to extend eConnect with auto posting, you need Alba Spectrum Posting Server
o Native Microsoft Dexterity posting engine. If you are or were the good old-days Microsoft Dexterity developer, you know that you can call Dexterity procedures and functions, especially if you review Great Plains Dexterity SDK and analyze DYNAMIC.DIC with source code (not available to the general development pool ). Posting Server calls this Dex logic and have Dexterity post “approved” of status Server cycles
o Approved batches table. Yes, you need to set up for “adoption” session in this custom table and Posting Server will start posting there. Depending table status every few seconds, so posting is happening in real time
o Types cycles. When we are talking about ecommerce programming, then it is more likely SOP module: SOP10100 and SOP10200 tables, where SOP invoice header and lines are stored and where eConnect places the work records. However posting server is not limited to SOP only. It works with all known GP modules (you can expect problems with the so-called satellites or third party modules, such as Mekorma, Wenn Soft etc.).
o SQL Server Store Procs choice. This alternative approach may look straight ahead, however GP posting cash flow complex and it includes multiple scenarios: different types of items is different price levels, lot or serial number tracking, sophisticated file allocation process to name a few complications and trying to discourage you dive into stored procedures coding
[ad_2]