Where in D365 can I find the date an invoice was payed? I want to calculate the average payment period (both to syppliers and from customers).
Jenny
Hi Jenny,
The details about which invoice and payment belongs together and the details about the date or the settled amount is stored in the tables CustSettlement and VendSettlement.
You can find payment date from Customer transactions and Vendor transaction on their settlement table (e.g. CustSettlement).
PS. Settlement table can be found for full and partial payment.
PS. You can create a filter for payment voucher number.
Can you please provide more details on the ask .
Normally the vendor payment date will be considered as the date on which invoice was paid . Another date which you may want to check is the system date on which the vendor payment was posted ( example : Vendor invoice due date 1-May , Vendor payment posting was done on system date 10-May with transaction date as 5-May )
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 Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,352
André Arnaud de Cal... 830 Super User 2025 Season 2
Sohaib Cheema 634 User Group Leader
