Troubleshooting Billing Manager and QBO Integration
1.6 min read
|This article guides you through troubleshooting issues with Billing Manager and QuickBooks Online integration.
Sync Invoice is the only data flow available for this connection.
Refer to the table below for common errors in the Sync Invoices data flow. After completing the steps to resolve an error, the record can be manually re-synced from the Logs page.
| Product Sync Errors | Cause | Steps to Resolve |
| String length specified does not match the supported length. Min:0 Max:XX supported. Supplied length:XX | This error message appears when the string length in the Invoice ID field exceeds the maximum number of characters allowed by QuickBooks Online (QBO). | Check if the total characters in the sales order number in OM is between 0 to XX |
| Some of the line items not found | Mapped items deleted/inactive in QBO | Create and/or activate associated Services in QBO |
| This number has already been used | The invoice number has already been used in QuickBooks Online, or the invoice was republished before the unpublish/delete process completed. | Confirm the invoice number is not already in use in QuickBooks Online. If the invoice was recently unpublished, wait at least 15 minutes before editing and republishing. After the wait period, manually re-sync the invoice from the Logs page if needed. |
| TxnID Cannot Be Linked | The customer record associated with the invoice may have been deleted, changed, or otherwise no longer linked correctly in QuickBooks Online. This can prevent invoice status updates, such as paid status, from syncing even if the invoice itself still appears synced. | Confirm the customer exists in QuickBooks Online and that the customer name matches the customer record used by Billing Manager. If the customer was deleted in QuickBooks Online, recreate the customer in QuickBooks Online, then manually re-sync the invoice from the Logs page. |
| Object Not Found: Something you are trying to use has been made inactive. Check the fields with accounts, customers, items, vendors or employees. | This error indicates that one of the records referenced in the transaction has been marked as inactive in QuickBooks. This could be an account, customer, item, vendor, employee, or another related record referenced by the transaction. | Review the entities referenced by the transaction and ensure they exist and are active in QuickBooks. |
FAQs
-
How long does it take an invoice to sync from Extensiv to Quickbooks?
- The invoice sync runs every 15 minutes.
-
Can I change the name of a customer in Quickbooks/Extensiv?
- Yes, customer names can be edited. To change a customer name, make sure the name in QuickBooks matches the updated name in Extensiv exactly. It's recommended to update the customer name in QuickBooks first, then update it in Extensiv 3PL Warehouse Manager. The update in Extensiv 3PL Warehouse Manager will automatically sync to Billing Manager.