Suppliers: Wrong/incorrect aging/ageing and total Suppliers balances on Suppliers Age Analysis report

Learn how to fix wrong/incorrect aging/ageing and total Supplier balances on the Suppliers Age Analysis report, in Sage 200 Evolution.

This article discusses how to fix the following issue:

The wrong/incorrect aging/ageing and total Suppliers balances on the Suppliers Age Analysis report.

Consider the following advice to resolve the above issue:

 

A. Suppliers Balance Relink

Open this link for a detailed article that discusses how to run the Suppliers Balance Relink routine.

If the same issue is observed afterwards, continue with the rest of the article below.

 

B. Delete Agent Registry Editor Key

Open this link for a detailed article that discusses how to delete an Agent Registry Editor Key.

If the same issue is still observed afterwards, continue with the rest of the article below.

 

C. Refresh Company Database Views

Open this link for a detailed article that discusses how to refresh the Evolution company’s database views.

If the same issue is still observed afterwards, continue with the rest of the article below.

 

D. Working with Foreign Currency Suppliers

1. Go to Suppliers | Enquiries | Transaction Enquiries.

2. Find and select the relevant Foreign Currency Supplier.

3. Click the View button on the top left of the screen.

4. Right-click anywhere on the grid and select Customise Grid Columns.

5. On the opened Customization box, find the Foreign Credit and Foreign Debit fields.

6. One by one, drag and drop both fields to the top of the header row on the grid.

7. Close the Customisation box.

8. On the top of the grid, click the Save Grid button.

9. Browse to the required location on your PC, give the newly created export file an appropriate name, and save the export file as a MS Excel File option as indicated below.

10. Open and inspect the newly created Excel file.

11. Check especially if there are any missing Credit, Foreign Credit, Debit and/or Foreign Debit values.

For example, in this case, notice that Credit values exist in column F below.

However, there are no corresponding Foreign Credit equivalent values for those transactions in column I below.

12. If this is the case, arrange for a company data fix to be performed.

13. When fixed, the above issue may be resolved.