Order Management System. What's new
← Version 1.30.50.0

Statement phase 3

There are in Customers list -> Statements were applied following changes:

In Summary: formulas calculation. Currently, values in Summary are calculated in this way:

  1. Balance forward =  sum of Open Balance before the Statement from Date
  2. Open Invoices = sum of Open Balance of Invoices +  sum of Open Balance Of Refunds + sum of open balance of Change Given
  3. Payments not Applied = sum of Open Balance of Payment + sum of Open Balance Of Credits + sum of Open Balance of write off
  4. 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:

  1. Current =  Payemnts which were created today + Invoices which were not past due + Todays Checks/NSF/Write OFF/Credits
  2. 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
  3. 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
  4. 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
  5. 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