Upgrade to ACCPAC 5.4

[dbant101]

We are currently upgrading our ACCPAC Advantage Seris 5.2A to 5.4A. We have not been able to complete all companies as we have ran into many issues. Some of the issues we have are:

1. Cannot upgrade until Bank Reconciliation is posted. There is a reconcliaition started but was never completed since 2005 fiscal year. It will not post as it isn't in balance. Is there a way we can remove or change the reconciliation so that we can upgrade. Bank Service 5.2A is being used.

2. We have also had a data problem where the data in the gl post tables were deleted. Had to send out our data to a repair company but could not repair entirely so there was a reconciling entry entry made to balance the accounts. This entry was for a large amount in some accounts so we went back to an earlier back up and exported the missing batches. I have not recieved the data back yet to verify that the data is now correct. We think that maybe the conversion caused this to happen but we can't really figure it out. Has anyone else out there had data disapper in certain tables during an upgrade.

We are also experiencing a severe data integrity problem in one comany where a day end did not process completely. No user told me about a problem or error message. We now have OE transactions and PO Transactions that have not transfered to IC, AR, and AP. Trying now to figure out how to get the missing information into the proper places with out creating more data integity problems. Any advice on a correct method to do this.

 

[AntonioPerera]

Given the complexities of the issues you have faced in the past, I would recommend a fresh database creation where you can create a new database for each company, import across the master files, enter the opening balances and then proceed with normal transactions.

This would help you iron out the 3 issues you have mentioned.

Also, please note the following :
1.I have not had data disappear during an upgrade before.

2.For the OE and PO transactions that have not transferred during the day end processing you can try to resolve this by performing a dbdump of the data and dbload of it to a separate location to see whether the day end processing works after this.If this does not work the next step is to identify at which point exactly the day end processing stops.

 

[ettienne]

1. Mark all the cleared items as uncleared in the bank reconciliation, then you should be able to post the bank reconciliation.

2. Never lost data in an upgrade or at any other time.

3. Send your data out for repair to recover the missing OE & PO transactions.