Skip to main content

I Need a Quick Report for Paid Supplier Invoices that shows Paid status and the date it was paid? I’m using INVOICE_LEDGER_ITEM_SU_QRY as my base view but it does not show “Date Paid”. Is the an API method to Get the paid date or is there another view I should be using?

 

Thank you,

You could try looking at the LEDGER_TRANSACTION_SU_QRY view - I think that gives you what you need.

@Hypervox I am using LEDGER_TRANSACTION_SU_QRY view but the date the invoice was paid is not one of the available fields.

Thank you,

@Hypervox , Maybe my join between view is wrong. What fields should I join between LEDGER_TRANSACTION_SU_QRY and INVOICE_LEDGER_ITEM_SU_QRY views?

 

Thank you

Looks like COMPANY, PARTY_TYPE, INVOICE_ID, IDENTITY at a minumum?

Reply


Terms & ConditionsCookie settings