Below is a list of errors you may receive on the QuickBooks Online sync status view in Finale Inventory with explanations and resolution tips.
Select the error below to see the details:
Error |
Explanation / Resolution |
|---|---|
Inactive
|
An Item is marked as inactive in QuickBooks Online. To resolve this, you must go to https://app.qbo.intuit.com/app/items and change the filter from active to inactive (or all), find the item, and click make active. |
Error |
Explanation / Resolution |
Inactive customer |
The customer associated with this transaction is marked as inactive in QuickBooks Online. To resolve this, follow the link to the customer/vendor in QuickBooks Online and click the “make active” button. If searching for the customer in QuickBooks Online, including inactive under the setting icon. |
Error |
Explanation / Resolution |
Inactive [type]: [name] |
QuickBooks Online is reporting a related entity as deleted/inactive. For example, a bill payment that uses a deleted bill as a reference will fail. To resolve, the entity must be recreated in QuickBooks Online by ensuring that the deleted entity is posted in Finale; then reprocess. |
Error |
Explanation / Resolution |
Account period closed |
The transaction record date occurred prior to the closed date set in QuickBooks Online. To resolve this, the user can change the record date of the transaction in Finale or change/remove the closed date in QuickBooks Online. |
Error |
Explanation / Resolution |
Account type incorrect |
For bill payments, not crediting a 'Checking' account. To resolve this, ensure the account being used for bill payments is a checking account. This can be updated in QuickBooks Online by changing the account type or updating the mapping in the Finale chart of accounts. The default account for bill payment credits in Finale is Cash on hand. |
Error |
Explanation / Resolution |
Unmapped sales clearing account for item [item] |
The QuickBooks Online item has no income account set. To resolve this, the user can ensure that the sales clearing account is mapped or by editing the item in QuickBooks Online and setting the Income account. |
Error |
Explanation / Resolution |
Amount outside the supported range |
A numeric value in the entity is outside the supported range for QuickBooks Online (-99,999,999,999 to 99,999,999,999). To resolve this, the entity must be updated to ensure that the numeric value is within that range. If necessary, the entity may need to be split into multiple separate entities. |
Error |
Explanation / Resolution |
Document number in use |
We failed to find a unique document number for this entity. If this persists after multiple syncs, one way to resolve this is by renaming the conflicting transaction in QuickBooks Online. For invoices/bills, this entity could be renamed in Finale by opening the detail view of the invoice/bill and using the action menu to select Edit invoice/bill ID |
Error |
Explanation / Resolution |
Name in useReleated to a Product |
The entity we are trying to sync to QuickBooks Online is conflicting with an existing entity that uses the same name. If there is an item of type inventory, deactivate it in QuickBooks Online and we will replace it with a non-inventory item. |
Name in useRelated to a Customer or Supplier |
The entity we are trying to sync to QuickBooks Online is conflicting with an existing Customer or Vendor that uses the same name. Check for a Duplicate name in Finale Inventory's Customer or Supplier list that you may have made inactive or that we have previously synced to your QuickBooks Online. The transaction that is receiving this warning is using the wrong entity in Finale. You should change the transaction to use the other correctly synced entity. This will require you to revert the Purchase order or Sales order to draft so you can choose the correct Supplier or Customer for the order that the Bill or Invoice is based on. |
Error |
Explanation / Resolution |
Invalid character in name |
QuickBooks Online restricts certain characters in names. To resolve this, the entity must be renamed to remove the invalid character. |
Error |
Explanation / Resolution |
Other validation fault |
This occurs for any other unhandled validation error from Intuit. To resolve this, the user must refer to the “Sync status details” which contains the error returned by QuickBooks Online. |
Error |
Explanation / Resolution |
Item not found |
A product on the transaction was not found in QuickBooks Online when trying to generate the body. Ensure nothing is preventing the item from syncing by checking the specific item sync for errors. |
Error |
Explanation / Resolution |
Service item not found |
An adjustment on the transaction was not found in QuickBooks Online when trying to generate the body. This will probably require contacting us to resolve. |
Error |
Explanation / Resolution |
No lines with a non-zero amount |
The transaction either has no lines, or all lines have 0 amount. Check the transaction and ensure it contains line items with a non-zero value for the transaction. To resolve this, the lines should be updated, and the transaction is posted again. |
Error |
Explanation / Resolution |
Customer / vendor not foundMissing customer/vendor |
The transaction is missing a required customer or vendor. To resolve this, either edit the order to set a customer/vendor or set up a default customer in integration settings. |
Error |
Explanation / Resolution |
Missing name |
The product or adjustment name is missing and needs to be added. |
Error |
Explanation / Resolution |
Unmapped account [accountName] |
Update the chart of accounts to map a required account for the entity type. |
Error |
Explanation / Resolution |
Negative total |
The amount for the entity cannot be negative. |
Error |
Explanation / Resolution |
Missing invoice |
The payment must have an associated invoice synced. Ensure that the invoice has no errors blocking it from syncing. |
Error |
Explanation / Resolution |
Customerref is missing in the request |
This may be seen with a problem syncing an invoice to your QuickBooks Online. Look to the Customer error columns for more details on why the Invoice could not be synced due to problems with the Customer of that invoice. |
Error |
Explanation / Resolution |
Required parameter VendorRef is missing in the request |
This may be seen with a problem syncing a bill to your QuickBooks Online. Look to the Supplier error columns for more details on why the bill could not be synced due to problems with the Supplier of that Bill. |
Error |
Explanation / Resolution |
cannot update/delete bill, order is complete/cancelled |
This applies to Importing Bills from QuickBooks Online: This will happen if you have synced a PO created in Finale Inventory to your QuickBooks and you created/attached a Bill to it in your QuickBooks that did not exist in Finale, and that Bill is trying to import into Finale Inventory to be created or updated against the original PO in Finale, and the status of that PO in Finale is Completed or Canceled. Change the status of the PO in Finale Inventory to Draft or Committed if you wish for the update to apply. |
Error |
Explanation / Resolution |
'entity' posted and cannot be updated |
This applies to Importing Bills or Bill Payments from QuickBooks Online: This will happen if you have imported a bill/bill payment before and now in a new sync it can't be updated because it is now in a posted status. Change the status of the entity to Draft if you wish for the update to apply. |
Error |
Explanation / Resolution |
has more than one associated 'entity' |
This applies to Importing Bills or Bill Payments from QuickBooks Online: You will get this error when you are importing a bill (or bill payment) that is associated with more than one purchase order (or bill). Finale does not currently support one payment made in QuickBooks for many bills. Either ignore this message, and thus the bills will not have payments attached to them in Finale or go back to QuickBooks Online and make separate payments for each bill. |
Error |
Explanation / Resolution |
linked entity/transaction |
This applies to exporting PO, invoices, and bills to QuickBooks Online: This will happen if you have exported a PO, invoice, or bill before and you are trying to push a change to QuickBooks Online and since then the QuickBooks entity has been linked to any other entity (in example a bill with a payment or a purchase order with a bill). If you need the update to go through, you will need to unlink the entity in QuickBooks Online to ensure it will be pushed in following sync). |