I would like to get an understanding of how sage AR ages balances..I can't for the life of me figure out where its getting the balances on the ages. What method is it using and can I modify it...were are using v.7.00.207
Hi Chisanga
The Evolution Age Analysis report makes use of the Ageing Period record that is linked to the specific customer you are viewing on the report. The Ageing period determines how the balances are distributed over the various ageing brackets on the report e.g. Current, 30 Days, 60 Days etc.
To setup Ageing periods, go to Customers (Accounts Receivable) | Maintenance | Aging Periods.
Kind Regards
Bennie
Thankyou this exactly how we have set it up...however I get challenges especuallybof the amount has prepayments...what does a negative balance on a an aged balance mean ...we have set aged interval to be date on invoice intervals at 30days 60 days etc
Example ablove .
I cannot make sense of the negative balances on the totals . My understanding is if at any point the account has an age balance that is negative eg at 120 and current we have negative it means there is no debt therefore and age before it should be 0
Hi Chisanga
I'm not sure how to respond here with an easy, obvious answer. But at least I can advise a negative balance on an aged balance could mean something like a total credit note amount bigger than the total invoice amount for that same period.
However, going forward, please rather log this query with Sage Evolution Support directly so that your query can be further investigated in a more formal setting.
Kind Regards
Bennie
Thankyou how do i log the query is there an email adress
Sure!
Simply open the following link:
https://app.smartsheet.com/b/form/4c5023eeaff24b05839f55753b05c465
Kind Regards
Bennie
*Community Hub is the new name for Sage City