AP Year End Processing - Post Bank Reconciliation Error

[chinsf]

Hi all,

I'm using ACCPAC Advantage Series 5.1A. I'm doing Financial Year End Processing for AP.

I encountered an error message on Post Reconciliation for one of the Banks :

Incorrect procedure. Check 338305 was not reversed or cleared.

I've checked through the Reconcile Statements, the Check 338305 was actually cleared but the system just can't pass this check number.

Anyone has any ideas for what's going wrong with this?

Regards,

Benny

 

[zemp]

I tried to look up your error and I found this response/solution. I have not done it but you can give it a try. Credit for the solution goes to S T of New York.

"Go to APPYM table and see if this check is there. You can also see this from Vendor activities, payment screen for that check. If not, you will need to fix your APPYM table by manually adding the record. You can try to use dbdump and dbload to do it. Try it from your test company and see if that works or make a back up before you do it."


Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."

 

[chinsf]

I don't know how to open up the APPYM.DAT file but I checked the Vendor Activities - Payments screen, the Check 000000338305 is there.

I've done the dbdump and dbload to the database and then try it again, it still stuck at the check number 338305...

Regards,

Benny

 

[zemp]

You can open the table via the Pervasive control center, or the SQL Server Enterprise Manager. Depending on which engine you are using.

Take Care,

zemp

"Show me someone with both feet on the ground and I will show you someone who can't put their pants on."

 

[chinsf]

I've checked through the table APPYM.DAT with Pervasive Control Center, the record is there, so what should I do next?

Regards,

Benny