Solved

Need a Quick Report for Paid Supplier Invoices

  • 3 October 2022
  • 4 replies
  • 34 views

Userlevel 5
Badge +10

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,

icon

Best answer by Hypervox 4 October 2022, 17:28

View original

4 replies

Userlevel 2
Badge +5

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

Userlevel 5
Badge +10

@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,

Userlevel 5
Badge +10

@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

Userlevel 2
Badge +5

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

Reply