Thank you for adding this item to Sage City Ideas Hub.  Open for voting.

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