Check your data for errors or warnings - Check your check to see if there are any issues relating to the sales aged balance.
- Go to File then select Maintenance.
- Press Check Data.
- Errors - These cause issues in your data and you need to correct them before continuing. Use our A to Z of Check Data errors article for more information
- Warnings: The following warning indicates problems with the aged creditors: 'Sales Aged Balance disagrees with Debtors Control by (amount)'
This appears because: - The currency information in your data files can be corrupt. For help with this, refer to the Check for currency corruption section
- Link removed transactions. For help with this, continue to the Check for bucket corruption section
Check for bucket corruption Bucket corruption occurs when the nominal code bucket values disagree with the total activity for the same period. To check this: - Go to Nominal codes, select Reports, then select Nominal activity.
- Run the report for the full date range, 01/01/1980 to 31/12/2099.
- Compare the History Balance amount to the Total in the Actuals column in the nominal record. For more information on bucket corruption, follow our article.
Check for currency corruption If the currency information in your data is corrupt, this may cause the aged debtors reports to show an incorrect balance. To check for currency corruption, run check data: - In Sage 50 Accounts, go to File, select Maintenance, then select Check data.
The following message appears if you have currency corruption: 'Account (customer, supplier or bank account) has invalid currency'. To resolve this issue: - If the account has no transactions associated with it, you can delete the account to resolve the issue
- If the account has activity, you can't fix this error using the maintenance tools in your software. We recommend you restore an error free backup and re-process
If the issue persists You'll need to check if any journals have been posted to the Debtors Control Account.
[BCB:19:UK - Sales message :ECB]
|