Notifications
Announcements
No record found.
Hi
I am trying to run an Open Invoice report showing original amount and unapplied amount for all vendors. Please advise on how to do so.
Regards
Ronnie
*This post is locked for comments
Hello Ronnie:
If you open the Inquiry windows Transaction by Document you can supply a date range for document date. That output typically shows unapplied amounts.
Another elegant alternative is a smartlist choose * from Payables Transaction folder and eye ball the curtrx amount label, that should be your unapplied amount, you may have filter by doc type of 1 for invoice and 5 for credit memos etc.
Best regards
Ven
Hi Ven
Thank You.
I checked smartlist which is my preferred forum and saw the column you speak off ..It just wanted to see also open invoices only i.e the origin field. Can you advise on this for smart list?
If the current transaction amount is 0, the invoice is no longer open. Also, you'll need to filter your list by document type. Take a look at Victoria Yudin's blog, she likely has already created a view that gives you exactly what you need. Victoria is a wizard with the GP tables and has given the community many, many excellent views.
Kind regards
Leslie
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
