Skip to main content
Solved

Need a Quick Report for Paid Supplier Invoices

  • October 3, 2022
  • 4 replies
  • 173 views

arebbeadle
Hero (Customer)
Forum|alt.badge.img+14

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,

Best answer by Hypervox

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

4 replies

Forum|alt.badge.img+9
  • Hero (Customer)
  • October 4, 2022

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


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14
  • Author
  • Hero (Customer)
  • October 4, 2022

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


arebbeadle
Hero (Customer)
Forum|alt.badge.img+14
  • Author
  • Hero (Customer)
  • October 4, 2022

@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


Forum|alt.badge.img+9
  • Hero (Customer)
  • Answer
  • October 4, 2022

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