Accpac 5.6 AP Error

[adamspeak]

We have an error when we run DIC for AP in Accpac 5.6

E: Balance due 262292.430 is not equal to sum of open documents for vendor F0003-M.

The actual balance of the aged documents are also the same amount as listed in above error. 7 documents accumulate that total perfectly.

Still this error displays but dont have any idea why this happens. Do anyone have an idea of how to overcome this error?

Would this be a problem for the year end or an upgrade of versions?

Note - We had checked fix minor errors when running DIC

 

[Jay Converse]

No, it's not urgent. This is an error you can ignore.

 

[adamspeak]

hi tuba2007

i got a relief by your word and i hope you really mean it.

What my worry is whether this will affect to an upgrade or anything in the future.
Can you please update me why this error occurs if its not a bother to you so that i am confident of this scenario and let it be as it is.

thanking you in advance

 

[Jay Converse]

It occurs when people Ctrl-alt-del during posting, or other system crashes. It probably won't affect an upgrade, but you won't know until you try.

 

[ettienne]

Compare the balance in APVEN to the total of the documents in APOBL.

 

[adamspeak]

Dear Etienne

Thank you for the prompt feedback.

nevertheless, i dont think that will work out. error says APVEN total does not match with the OPEN DOCUMENT TOTAL which means have to compare with APOBLJ. but that is not tallying anyway. Because the open documents(invoices) i see in APOBLJ accumulates the total to 1015748.

but actual APVEN total is 262292.430

There is a huge gap in between but the same APVEN total tallies to the aged invoices(APAGED) total when you run the aged payable report. There you have only 7 invoices in APAGED table.

I dont understand why APAGED and APOBLJ does have a huge difference in total?
currently in this database APOBLJ includes already settled invoices too.
Are not both tables supposed to have only the same invoices?

Do you think i should be deleting all the unrelated records in APOBLJ except the ones which are already there in APAGED?

Thanks & regards

 

[ettienne]

Compare APVEN and APOBL .