AP error

[Kivairu]

I have Accpac 5.4 with all sps.However during the past couple of weeks Iam getting strange errors where a document is not available for payment.

When I run the Integrity test I get the following Errors.
And even after this the docs are still not available for payments.

Vendor Number: C1303, Document Number: 10117135
E: Document C1303, 10117135 should have at least one payment schedule.
E: Document amount 2500.000 is not equal to sum of scheduled payments for document C1303, 10117135.
E: Amount due 2500.000 is not equal to sum of scheduled payments for document C1303, 10117135.
E: The number of scheduled payments of C1303, 10117135 does not comform with those maintained in scheduled payments. Fixed.
E: The CNTOBLJ field value [1] does not match the actual number of open document details [0]. Fixed. E: Balance due 332310.000 is not equal to sum of open documents for vendor C1303.

How can I fix this?

 

[Jay Converse]

There must have been server or database crashes someone isn't reporting.

1. Delete those records from APO*.*
2. Run DIC to fix the vendor balance
3. If this invoice wasn't paid, re-enter it with a different number.
4. Check your server for error logs, and possible Dbdump/Dbload your database to clean up the bad indexes