Sage 200 UKI Ideas Portal

Expose Invoice lines in API

Currently it is possible to get summary and statistical details of an invoice through the API endpoint sales_posted_transactions. However, I have a need to get the individual line items on the invoice as well. It appears that there is currently no means of getting these line items from the API. I propose the creation of a new endpoint /sales_posted_transaction_line_items which provides access to these line items. This endpoint should expose the description, product ID, tax code, nominal account and other details of the line item whilst also including a transaction_id/transaction_urn field which allows linking these line items to a sales_posted_transaction. This would provide the same functionality as the Audit_Split table in Sage 50. I assume this data would be from the SOPInvoiceCreditLine table. The eventual goal is to be able to reproduce the invoice PDF using only data from the API

  • Guest
  • Jul 16 2020
  • Idea Accepted - Gauging Support