SAP Business One Integration

• Staging Table.  You need to move your eCommerce transactions to staging table, preferably in MS SQL Server, where SAP BO is hosted.  Use stored procedure, if required you can do heterogeneous queries to pull transactions from Oracle, IBM Lotus Notes Domino or another db platform
• SAP BO SDK Loop.  You should open connection to SAP BO company via SDK.  We will not give you code sample here, we expect intermediate SDK coding experience.  When connection is established – you read your staging table and create Sales Orders one by one – or alternatively you create one Sales Order and add items one-by-one
• Flagging Imported Transactions.  In staging table you should either delete imported transaction or flag them as being imported,  your choice
• AR Invoice.  We do not recommend you to add invoice in integration.  The reason is simple – invoice is not stored in the batch – it should be posted – and we do not recommend you to review posted invoices – in order to reverse them you will need to enter credit memos, which will create a mess in your data entry
• Other Integrations.  SAP Business One SDK allows you to create, modify and manipulate virtually all SAP B1 objects, in this article we showed you Sales Orders, you can also update or add customers, vendors, etc.

Please feel free to call us on SAP Business One integration scenarios: 1-866-528-0577, 1-630-961-5918, help@albaspectrum.com or skype: albaspectrum