Pastel Partner Statement is Wrong

[kapfumo]

I am using Pastel Partner V14 recently I was allocating open items.The problem is when I finished allocating I discovered they on a fully matched invoice they now appear another amount big than the invoice value.I have unallocated all the invoice and I am still left with a debit amount which I don't know where it come from.I have checked the customer ledger and this amount does not appear anywhere it only appear in my statement.

Please help me how do I solve this problem

[Neville Bailey]

It sounds as though you might have some corruption in the Open Item table.

If you run the customer age analysis, only for this customer account, and tick the box "Print Transactions", and then look at the last row of the report, do you see a line item with the description "I/O Difference"?

If you do, then you have Open Item corruption.

Normally, when you process a transaction to an account that is set up for Open Item processing, the transaction updates the Ledger Transactions data table, as well as the Open Item data table. The two data tables are supposed to be in sync. However, sometimes you get corruption due to power fluctuations or an unstable computer/network, and some of the entries in the Open Item data table get deleted, duplicated or changed in odd ways.

I can fix the corruption with my database editor if you have TeamViewer.

[kapfumo]

Yes this customer do have an I/O difference.I do have Team Viewer.

[CinsJ]

Hi, Sorry to add to this thread after so many years. I have been searching if there is perhaps an answer to my problem.
I have client's statements who are incorrect. Fortunately I remembered for a fact that a certain client paid their previous month's invoice, and could immediately pick it up.
It reflects the client's payment on the debit side of the statement instead of the credit side, and thus doesn't deduct it. But if I look on the customer detailed ledger, the correct outstanding balance reflects.
Please see pics...

[Neville Bailey]

That is an indication of Open Item data corruption.

I can fix that for you via TeamViewer, using my datafix software.

Please send me an email or PM if you would like to arrange a remote consultation.