Dx5+QBO: Error Message Troubleshooting

When data migration issues occur, errors can be viewed in the API log found in the Accounting > Overview tab. This log provides helpful insight when errors occur, which are most often minor issues stemming from the integration either not being done completely, or correctly, or a simple issue of switching beginning dates in QBO. The error messages are explained below, and include the resolution.

• Issues with How Data is Linked
  • When there are duplicate accounts that are named the same, or almost exactly the same, the following QBO response error will pop up:
    • <Message>Duplicate Name Exists Error</Message><Detail>The name supplied already exists. : Another customer, vendor or employee is already using this name. Please use a different name.>
    • Resolution: rename the account/s that were created before the integration, leaving the Dx5 required accounts named exactly as required.
  •  The integration requires the exact account and sub account setup outlined in this article. If the accounts are not setup as required, the flow of data from Dx5 to QBO will be disrupted. When this occurs, you will see the words "accountsubtype" and "subaccount" within the QBO response error:
    
    • To check if this is the issue, select Edit on the accounts that are intended to be listed as sub-accounts from the Chart of Accounts overview. When viewing the edit page, the checkbox "Is sub-account" should be checked and the required account should be listed in the dropdown. 
    • Resolution: check the box "Is sub-account", then select the required account from the dropdown, then save the adjustment. 
• Issues When Bottling, or When Marking an Order as Shipped
  • Users are allowed to backdate when entering in bottling runs into Dx5. If the bottling is entered with an action date before the product was linked, then the following QBO response error message will populate in the API log:
    • <A business validation error has occurred while processing your request</Message><Detail>Business Validation Error: You can’t create or modify a transaction with a date that comes before you started tracking quantity on hand for the following: Houdini Bourbon (750.00 mL).>
    • Resolution: adjust the initial starting date in QBO for the product to a time prior to the order being shipped. To adjust this date, login to QBO, then navigate to the Sales > Products and Services tab, select the black arrow to the left of the Edit option, then select Adjust Starting Value > Got It, then adjust the "As of Date" as needed. 
  • Similar to bottling, users can mark an order as shipped prior to when the finished products were linked, or created in QBO. Doing so will throw the following QBO response error error:
    • <A business validation error has occurred while processing your request</Message><Detail>Business Validation Error: You are not allowed to modify the quantity of an inactive inventory item.>
    • Resolution: adjust the initial starting date in QBO for the product to a time prior to the order being shipped. To adjust this date, login to QBO, then navigate to the Sales > Products and Services tab, select the black arrow to the left of the Edit option, then select Adjust Starting Value > Got It, then adjust the "As of Date" as needed.