I need to create a automated sheet in which the following can be done...
Example:
Invoices are raised to a customer on different days in 3 months.
The Customer has a standard credit period of 30 days.
However, the customer pays on different days (within & above the due date) and the amounts are not according to invoices.
There maybe a case where the in certain payment, the effect would be realized on 2 or more invoices... means if the payment for invoice 1 is completed, then the remaining amount from that payment will be adjusted against the following invoice. So we need to calculate in how many days is the payment actually completed.
Please let me know if any other information is required.
Example:
Invoices are raised to a customer on different days in 3 months.
The Customer has a standard credit period of 30 days.
However, the customer pays on different days (within & above the due date) and the amounts are not according to invoices.
There maybe a case where the in certain payment, the effect would be realized on 2 or more invoices... means if the payment for invoice 1 is completed, then the remaining amount from that payment will be adjusted against the following invoice. So we need to calculate in how many days is the payment actually completed.
Please let me know if any other information is required.