Sales report showing Invoice due date
Is there any sales report can show the invoice due date?
AR aging only show the due date for overdue invoices, how about for the paid invoices?
Showing invoice with its due date and payment date together can help us to review the credit terms for the customers.
We have included DueDate as a Column in the Invoice Detail dimension.
Exporting this to a spreadsheet may not import the DueDate as a Date format.
To assist with analysis of PaidDays we have created two new metrics
- Days to Pay , the number of days from Invoice to Payment for Paid Invoices Only
- Days Paid PastDue, the number of days from Due Date to Payment for Paid Invoices Only
These are hidden by default so use +/- Cols
Please sign in to leave a comment.