Troubleshooting Billing Manager and QBO Integration
1.0 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:21 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 21 |
| 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. |