Returned check table and upgarde to 5.6

[ramam1]

Hey folks,
We've hit another snag in our dry run upgrading to 5.6.

It seems that for whatever reason two tables (BKNSF and BKNSFD) are not being properly prepared for the upgrade (it errors out). We've reconciled banks, posted all open batches in all modules, and purged the reconciliation posting journal but no luck.

I tried searching Sage's customer support site for hotfixes but they appear to be experiencing a partial outage... any hotfixes I might want to try here?

Any other suggestions or thoughts?
thanks

 

[Jay Converse]

What's the error?

 

[ramam1]

Description: Bank 120011, 120056, 120078, 120106, 120136 has outstanding returns. You must clear the returns and post the bank reconciliation before you can upgrade Bank Services.
Source: 12:13:24 - Bank Services 5.6A
Description: You must create G/L batches, then print and purge the reconciliation posting journals, in order to proceed with upgrading.
Source: 12:13:26 - Bank Services 5.6A

 

[Jay Converse]

Just empty them manually.

 

[ettienne]

As the error says, you have returns that need to be cleared.

 

[ramam1]

For the next person to come across this...
We spoke to folks at Sage and after walking through the procedures we had already done here is what we got from them:
1) search Accpac KB for 26734 "Cleared Deposits with zero amount are not removed after posting Bank Reconciliation". This includes a clean up macro and two update DLLs to fix the problem (it's a HotFix KB article). The Clean up macro did not do the trick.
2) search Accpac KB for 26222 ""Requested receipt was returned previously" Error Occurs When Posting Bank Reconciliation". This is another Hot Fix KB. With a clean up macro and DLLs to fix the problem. This macro did not do the trick either.
3) When the macros failed to work he said we should empty those two tables manually. Clearing those tables manually fixed things for us.

thanks folks