Supplier Control Account balancing issues

[Allbalance]

The Supplier Control account total and the Supplier Age analysis total is not in balance in Pastel.
How do I correct the Supplier Control account total to correspond to the Supplier Age Analysis total?

[Mike C]

Hi Allbalance. What accounting package are you using?

[Allbalance]

Hi There, Pastel Partner

[Neville Bailey]

Have you run the Data Integrity report, under File...Data Integrity?

Let me know what it indicates and I can then advise the way forward.

[Allbalance]

Hi Neville, it indicates one Supplier Open Item out of balance, this particular supplier is insignificant in the equation though.

[Neville Bailey]

Have you double checked your filter settings when running the age analysis report? Make sure that you include the full range of categories, including "None", and that you include both debit and credit balances. Also, in the range of codes, select a blank in the Start code and a whole series of Z's in the End code.