API that imports Accounts Payable invoices into Sage 500

Question

Hi everyone, Our development team is evaluating the best way to build an API that imports Accounts Payable invoices into Sage 500. We plan to leverage the following stored procedures: &bull; spAPapiAPInvoiceIns &bull; spAPapiAPInvoiceInsSet &bull; spAPapiAPPendInvoiceIns Does Sage provide any official documentation that details the required parameters, expected data formats, and typical call sequence for these procedures? Alternatively, if anyone here has implemented an AP-invoice import workflow with these SPs, I would be grateful for guidance or sample code snippets illustrating best practices (e.g., transaction handling, error trapping, performance tips). Thank you in advance for any direction you can share! 
 Maru 
 Enterprise Application Manager

Contefication · Accepted Answer

Sage would recommend you purchase Data Import and utilize their packaged interfaces, and there are a number of reasons to implement that type of solution because the detailed documentation is primarily contained in the SDK if you perform your own development. There is some very basic documentation in Assisted Company Setup, but there are also the flat file import utilities for AP. 
 I've done a number of these direct imports using the APIs, including writing my own to support a pending PO voucher import, so unless you have some unusual requirements for your AP documents, I would recommend you look into tools that have already been written to do the job.

Sage 500

API that imports Accounts Payable invoices into Sage 500

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING