Creditor - open item out of balance

[Heidivf]

Hi

At one of my clients, a payment was posted for one of their creditors and it shows in the creditors ledger but does not show in match open item for the invoices to be tick off. I ran a data integrity check and 6 creditors have the following message - open item out of balance.

How do fix this?

TIA

[Heidivf]

Sorry, I should mention this is Pastel Partner

[Neville Bailey]

There appears to be some data corruption in the Open Item transactions.

I have the necessary database editing software to fix the corruption, which I can do via TeamViewer or on my system if I can get a backup of your client's company database. Let me know if you would like me to assist and we can make a plan.

[Heidivf]

Hi Neville

That would be great. I am only going there Tuesday next week, then I can get a backup.

Is there anything that one can do to prevent such data corruption in the future?