Product: QuickBooks Online
Error: Overship Error: Item XXX, Id X exist on Warehouse Shipping Advice not present on the QBO Estimate. Please review and adjust Overship setting, if necessary.
Issue: When attempting to export out an inbound Warehouse Shipping Advice (945) from the Inbox you receive the following error: 'Overship Error: Item XXX, Id X exist on Warehouse Shipping Advice not present on the QBO Estimate. Please review and adjust Overship setting, if necessary.'
Reason: Transaction Manager could not find an open item on the Estimate within QuickBooks Online with the provided Item Code and line number.
Solution - Correct the Item Code
You'll want to make sure that the Item Code listed within the error is a valid Item on the Estimate within QuickBooks Online. If it does not match you'll want to be sure to set your Primary Item Field to the correct setting so that Transaction Manager knows which field to pass on your Warehouse Shipping Advice (945) to QuickBooks Online
Setting the Primary Item Field
Navigate: Trading Partners → (Warehouse) → Preferences → Transactions
Select: Transactions tab
Locate: Warehouse Shipping Advice
Set: Primary Item Field
For More Information on Configuring your Primary Item see the below link
Solution - Translate the Item Code
If your Warehouse/Third-Party Logistics company is not sending your QuickBooks Online item code - you can translate any of the codes they have provided using Transaction Manager's built in Item Catalog
Navigate: Trading Partners → (Warehouse) → Translations → Item Catalog
Fill: Item Translation with QuckBooks Item Code
Fill: Primary Item Field (2nd Column) with Warehouse Item Code
Note: The Item Catalog only translates your Primary Item Code which will always be the 2nd Column of the Item Catalog.
If the code you wish to translate is not the 2nd column - please set your Primary Item Field
Solution - Correct the Line #
If your Item Code is correct within the error message you will want to confirm that the Line # being passed matches the Estimate within QuickBooks Online. Your error message also includes the Line ID (Line #) listed in it indicating if it's looking at the wrong line.
Transaction Manager supports same-items over multiple lines - as such if a Line # is being passed it will attempt to match the Line # within QuickBooks Online to the line # provided by your Warehouse/Third-Party Logistics (3PL) company.
Additional Resources
rev 6/5/2024