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