We issue our customers with a invoice based statement. Many of our invoices are subjet to retention so I have found the easiest way to track the anticipated payment date of the short payment is to alter the due date on the invoice. The statement then nicely shows the original amount and the payment(s) to date for each invoice, but it would be really tidy if I could add a column for Due date to show when each invoice is due. The ageing at the bottom is correct.
Can anyone tell me if this can be done and if so how?