Connection between invoice and payments

Hi, I am new to dynamics 365 and my boss have asked me create a report showing avg days it takes for customer to pay invoices but I am not able to find the connection between invoices and payments. I looked in GL Entries, cust Ledger table. Can someone help??


You need to use the customer ledger entries, there is field Closed at date and closed by entry no. Those fields are not visible. How you will create this report in Jet or data extract?


Thank you for your reply, I use power Bi to create reports

So it should be the same way.

I have created reports like that in Jet, by using the closed at date and then formula Closed at date - Due date or posting date.