How does Debtors Inquiry Calculate Months?


As standard the system calculates aging of debt based on calendar months.

For example, an invoice dated 31st March 2014 will appear in Current Month Debt if the Debtors Report is run with a To Date of 31st March 2014, but will appear in Month 1 Debt if you run the report with a To Date of 1st April 2014.

It is possible to change this to work on a numerical basis for either 30 or 15 days from date of invoice. So if you selected the 30 Day setting, the above invoice dated 31st March 2014 would appear as Current Month Debt if the To Date is set 30th April 2014 or earlier.

To make this change in settings, go to System Function, then System Controls. Scroll down the List until you reach a System of LEDGERS and a Control of PERIODTYPE. The numeric digit in the Value Box changes the settings as follows

0 = Monthly Basis (first example above)
1 = 30 day basis (second example above)
2 = 15 day basis