Hi all,
Hoping to find a solution, to something. Maybe it has already been solved but searching i couldnt find something relative to my problem.
There are data in four columns, seperated by invoice date, invoice amount, payment date and payment amount.
I want to calculate how many days payment have been delayed considering that payments amount is not the excact amount of the invoice. It can be less or more than the invoice amount.
For example :
Consider the following parameters :
regards
Ioannis
Hoping to find a solution, to something. Maybe it has already been solved but searching i couldnt find something relative to my problem.
There are data in four columns, seperated by invoice date, invoice amount, payment date and payment amount.
I want to calculate how many days payment have been delayed considering that payments amount is not the excact amount of the invoice. It can be less or more than the invoice amount.
For example :
Invoice Date | Amount | Payment Date | Amount | Days |
01/3/2022 | 5000 | |||
03/03/2022 | 10000 | |||
15/04/2022 | 13000 | |||
10/05/2022 | 8000 |
Consider the following parameters :
- Customer have open payment terms for example 100 days from invoice date and then he has to pay cash.
- I want to be able to predict in quick time what money he has to deposit in order to pass the open terms days that we have agreed.
- Amount of payments doesnt relate to the amount of the invoice, could be less or more.
- So, what i need it to be able to calculate haw many days is the delay for each invoice.
regards
Ioannis