There are in Customers list -> Statements were applied following changes:
In Summary: formulas calculation. Currently, values in Summary are calculated in this way:
- Balance forward = sum of Open Balance before the Statement from Date
- Open Invoices = sum of Open Balance of Invoices + sum of Open Balance Of Refunds + sum of open balance of Change Given
- Payments not Applied = sum of Open Balance of Payment + sum of Open Balance Of Credits + sum of Open Balance of write off
- Amount Due = Forward Balance + Open Invoices – Amount Paid
In Amount Due block: formulas calculation. Currently, values in Amount Due block are calculated in this way:
- Current = Payemnts which were created today + Invoices which were not past due + Todays Checks/NSF/Write OFF/Credits
- 1-30 Days past Due = sum of Open Balance where age 1-30 days for current period + Payments/Checks/NSF/Credits for which Age = (Today date – Transaction date) less than 30
- 31-60 Days past Due = sum of Open Balance where age 31-60 days for current period + Payments/Checks/NSF/Credits for which Age = (Today date – Transaction date) equal 31-60
- 61-90 Days past Due= sum of Open Balance where age 61-90 days for current period + Payments/Checks/NSF//Credits for which Age = (Today date – Transaction date) equal 61-90
- Over 90 Days past Due = sum of Open Balance where age over 90 days for current period + Payments/Checks/NSF/Credits for which Age = (Today date – Transaction date) over 90