Differences between the Aged report and control account(s) can be caused by a number of things please check the following:
Identify in which period the difference first occurred by comparing the reports historically. Note down differences as variations in these may provide pointers.
Nominal journals posted to a control account. Since these do not update the Customer record this leads to a difference. These may need to be reversed, but there also may be a valid accounting reason for them.
Posted transactions using an analysis code that is set up incorrectly. Eg. The control account is not updated or is updated on the wrong side of the double entry. The analysis code record may need to be amended and steps to deal with the erroneous transactions should be taken before doing that.
Use the transaction enquiry screens for sales transactions and control accounts to compare totals - export them to excel for further analysis.
If you are using a version of Access Supply Chain prior to 7.3.5 and are running as at Last year with transactions from other year outstanding then there is a known issue, please speak with your Account manager with regards to upgrading.
If you need further help with this please ask for it to be passed to the ASC support team and reference the title of this article and please include details of the period the difference first occurred and the difference observed.