error exporting QuickBooks 2013 data using Rapid Mig Tool for GP 2010

(0) Share

Report

Posted on by ewills

5,990

Unable to export Quickbook 2013 premier data using Rapid migration tool for GP 2010. Error below. Appreciate if anyone could share. note - I didn't open the Quickbooks company. perhaps that could be the reason, but just want to doublecheck -

**************** error from the Log as below ************************

Connected to CoreObjX tool successfully.

Database TWO_QBData is created.

QuickBooks tables are added into database.

Table Account is not exported. For table Account error message is: Could not start QuickBooks.. Source is: CoreObjXDB.

Table SalesTaxCode is not exported. For table SalesTaxCode error message is: Child tables cannot be selected.. Source is: coreObjXDB.

Table ItemSubtotal is not exported. Table is not in the defined migration scope.

Table ItemPayment is not exported. For table ItemPayment error message is: Child tables cannot be selected.. Source is: coreObjXDB.

Table ItemSalesTax is not exported. For table ItemSalesTax error message is: Child tables cannot be selected.. Source is: coreObjXDB.

.........

0 account(s) in QuickBooks match the criteria for Sales Tax Payable account. Exactly one should match. Refer to the Migration Troubleshooting topic in the Rapid Migration Tool help.

0 account(s) in QuickBooks match the criteria for Inventory Asset account. Exactly one should match. Refer to the Migration Troubleshooting topic in the Rapid Migration Tool help.

The export of QuickBooks data has finished unsuccessfully.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

L Vail 65,271 on at

Like (0)

Report

You must have a Sales Tax Payable account in your chart of accounts if the QuickBooks company is setup to use Sales Tax. You also must have an Inventory asset account in your chart of accounts if you are tracking the current value of inventory.

Check your company preferences. Here's sales tax:

Here's Inventory:

Was this reply helpful? Yes No
ewills 5,990 on at

Like (0)

Report

Thank you leslie, Appreciate your feedback. I will verify this.

Was this reply helpful? Yes No
ewills 5,990 on at

Like (0)

Report

Hi, looks like I am not able to complete the steps for 'Grant Access' -- When I click on this buton, there is no pop-up form! Could this be the reason why no data is exported? Is there any settings that I need to check such as UAC? Appreciate your help.

Grant access to your QuickBooks data

1.Click the Grant Access button to open the QuickBooks – Application Certificate window.

2. Mark to always allow access to the Rapid Migration Tool even when QuickBooks isn’t running.

3. Mark to allow access to personal data, such as credit card information and Social Security numbers.

4. Click the Continue button in the QuickBooks – Application Certificate window.

5. Click Done in the Access Confirmation window.

6. Return to the Data Access window.

Was this reply helpful? Yes No
ewills 5,990 on at

Like (0)

Report

"This application has not accessed this QuickBooks company data file before.

The QuickBooks administrator must grant an application permission to access a QuickBooks company data file for the first time.. Source is: CoreObjXDB"

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi again,

Yep, you do need access. Today, my team did a Rapid Migration from QB Premier 2013 to GP, I'll check with them tomorrow to see if I can give you a better answer. I think we must have jumped over every log in the forest trying to get that thing to run.

Leslie

Was this reply helpful? Yes No
ewills 5,990 on at

Like (0)

Report

Thanks. After I changed to QB admin user, RMT started creating (filling) table. However, it seems to be stuck on filling estimate table! (just a correction on the version of QB - its 2010 Premier).

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Congrats!

You have definitely earned it!

It'll be easy next time :)

Kind regards,

Leslie

Was this reply helpful? Yes No
ewills 5,990 on at

Like (0)

Report

Morning Leslie, regarding "Inventory asset account", my question is that do we need to create one (with exact same name") with taxline as "unassigned" or how is this account mapped with existing inventory accounts?

Was this reply helpful? Yes No
ewills 5,990 on at

Like (0)

Report

With inventory asset, RMT is good to go for me. thanks.

Was this reply helpful? Yes No
ewills 5,990 on at

Like (0)

Report

Hi Leslie, I happen to come across the same issue again for another instance of GP 2010- RMT stuck on this account "Filling table Estimates" - which is defined in QB as non-posting account. What would be cause of this? Is there anyway to get around this? Any help would be appreciated.

Was this reply helpful? Yes No