Error codes (-1,0) when attempting to upgrade my data file to QuickBooks QBi 2008/09

Legacy KB ID: 226

Question

Why do I receive the following error message “An error has occurred when QuickBooks tried to access the company file. Please try again. If the problem persists, contact Quicken Technical Support and provide them with the following error codes (-1, 0)” when attempting to upgrade to QuickBooks QBi 2008/09?

Answer

This is due to the following reasons:

Below relates to the QuickBooks 2008/09 (Market Release):

To ascertain that you are on QuickBooks Market Release, press CTRL + 1 on the keyboard together and the Product Information will appear. View the Product line and the Release number at the end will be R2P (R2).

1. Custom Tax Codes – If you have created your own tax codes in previous versions and they have only been used on one side of QuickBooks, i.e. Used on an Inputs (Purchases) transaction (a Bill; Purchase Order; etc.) and not Outputs (Sales) transaction (Invoice; Sales Receipt; Adjustment Note; etc.) or vice versa, then the upgrade produces the error.

Only those custom tax codes that have been used on one side need to follow the information below:

To resolve this we need to create a new item. Note: The item can be deleted once the file has upgraded to QuickBooks QBi 2008/09.

  • From the List menu, select Tax Code List
  • Highlight the custom tax code, right click and select Quick report
  • Set the date range to All
  • Confirm whether the tax code has transactions on both sides. If there are transactions under both the Outputs (Sales) and Inputs (Purchases) headings the tax code is on both sides
  • Search and take note for each custom tax code that have been applied to only one side
  • From the List menu, select Item List
  • Click on Item and select New
  • From the Type drop down list, select Inventory Part

If the custom tax code was used only on Purchases (a Bill; Purchase Order; etc.), then create the new item with a purchase tax code of NCG and the sales tax code with your custom tax code, therefore adding the code to the Outputs (Sales).

If the custom tax code was used on Sales (Invoice; Sales Receipt; Adjustment Note; etc.), then create the item with a sales tax code of GST and a purchase tax code with the custom tax code you have used, therefore adding the code to the Inputs (Purchases).

Note: Remember to create a new item for each custom tax code that has been used on one side only.


2. Duplicate default accounts in the Chart of Accounts - The following examples of duplicate accounts can cause this issue:

  • Tax Payable
  • Bank (Online)
  • Cost of Goods Sold
  • Purchase Order
  • Retained Earnings

If a duplicate account exists, your data may be damaged. You will need to perform a Verify and Rebuild. If this is unsuccessful your file will need to be repaired by our Data Recovery Department.

Please go to our website using the https://www.quicken.com.au/Support/dataServices/dataRecovery.aspx link and Request A Service using the available option.


3. Invalid characters in cheque numbers and reference numbers etc

To resolve invalid characters you will need to generate a report;

  • From the Reports menu, select Custom Transaction Detail Report
  • Click on Modify Report... if the window does not automatically appear
  • From the Display tab, set the range to All and click OK
  • Locate the Number (Num) column and confirm that it contains no single quotation marks ('). If necessary, remove any single quotation marks (') from the Number column by double-clicking into each transaction, remove and re save the transaction(s)               

When these steps have been completed, open and upgrade your QuickBooks Data file again.


Below relates to the QuickBooks 2008/09 (SP1):

To ascertain that you are on QuickBooks SP1, press CTRL + 1 on the keyboard together and the Product Information will appear. View the Product line and the Release number at the end will be R3P (R3) or R6P (R6).

1. Duplicate default accounts in the Chart of Accounts - The following examples of duplicate accounts can cause this issue:

  • Tax Payable
  • Bank (Online)
  • Cost of Goods Sold
  • Purchase Order
  • Retained Earnings

If a duplicate account exists, your data may be damaged. You will need to perform a Verify and Rebuild. If this is unsuccessful your file will need to be repaired by our Data Recovery Department.
 
Please go to our website using the https://www.quicken.com.au/Support/dataServices/dataRecovery.aspx link and Request A Service using the available option.


How did we do?


Powered by HelpDocs