20
Hi All,
I need to be able to run a 'suggested vendor payments' report that only shows invoices with a posting date before a paticular date. Is this possible, if so how!?
Any help is much appreciated.
Regards
Stuart
*This post is locked for comments
Hello Stuart,
Thank you posting on the Microsoft Forum.
From my review of the Suggest Vendor Payments, the Options Tab > Last Payment Date will filter to any Invoices with a Due Date on or before the specified date. However, the Due Date of the Invoice is used and not the Invoice Posting Date. If you have a common Payment Term, such as 30D, you could use the Last Payment Date of 30D out from the date you want see all open outstanding invoices. Otherwise, a modification to the system would be required. There is not a capability in out-of-the-box functionality to filter to the Invoice date because the standard date fields are based on the Due Date and not the Invoice Date.
I hope the guidance helps you move forward.
Best Regards
Tom
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (