I have tried connector versions 3.10, 3.11, 3.12, and 3.13. They all seem to product the same error.
I am also using Quickbooks Pro 2007 and a BVC5-SP2 store. I can't tell if my problem is in the connector, QB, or the way I set up tax in the store.
I have set up a tax rule in BVC5 that applies 5% tax to orders shipped to Virginia, where I am. It works beautifully. When I export these orders, I would like for the tax to be included as a line item, but Quickbooks kicks the order back to the connector with an error of
Code:
ERROR: There is an invalid reference to QuickBooks Item "8000001A-1194219139" in the SalesReceipt line. QuickBooks error message: You cannot use the same tax item in both the line items and the txn tax.
"BVC Tax" is set up as a tax code in QB. I don't see any way to NOT have it set it up. At this point, I have the tax code set to 0% and will manually add line item tax to the Viriginia orders. Has anyone else gotten this to work? If I set up BVC Tax as a 5% tax, and let QB calculate it, then it does so FOR ALL ORDERS, regardless of state.
Here is the whole log entry for the export of a single order after telling the connector to add the tax as a line item.
Code:
Exporting BVC5 Order: 1010
Checking for Duplicates
Checking for existing order at: 11/5/2007 9:46:25 AM
Finished Checking for existing order at: 11/5/2007 9:46:25 AM
Importing PAID Order
Starting Save to QuickBooks at: 11/5/2007 9:46:25 AM
Starting to Get Customer Info at: 11/5/2007 9:46:25 AM
Creating Unique Customer by Name
CustomerInfo after Exists Check = 80000014-1194273932
Checking For Match
Match Found!
Customer Result = 80000014-1194273932
Finished getting Customer Info at: 11/5/2007 9:46:25 AM
Starting To Update Customer at: 11/5/2007 9:46:25 AM
Finished Updating Customer at: 11/5/2007 9:46:26 AM
Creating Sales Receipt at: 11/5/2007 9:46:26 AM
ERROR: There is an invalid reference to QuickBooks Item "8000001A-1194219139" in the SalesReceipt line. QuickBooks error message: You cannot use the same tax item in both the line items and the txn tax.
Finished Creating Sales Receipt at: 11/5/2007 9:46:27 AM
Finished Save to QuickBooks at: 11/5/2007 9:46:27 AM
Result: False
SaveLastOrder: False
Not Setting Last Order Number
Finished Export of BVC5 Order 1010
Order Export Time: 00:00:03.2500000
Total Export Time: 00:00:03.3437500
Anyone else using this connector with BVC5 yet?