Transactions with inventory (QOH) products cant be dated earlier than the Inventory Start Date for the product

Owned by Evgeniy Ermolaev
Last updated: Jul 02, 2018
1 min read

Problem

The error message appears through the sync process: 

Transactions with inventory (QOH) products cant be dated earlier than the Inventory Start Date for the product

Use Case #1

The product you are trying to synchronize has the inventory start date is after your Invoice creation date. (i.e. The invoice was created before QiuckBooks initial inventory for the product was created.)

Use Case #2

The product in QuickBooks was sold as a service "Service" or "Non-inventory" and then, it was converted to the "Inventory" product type AND you are trying to synchronize the invoice which was dated prior to the conversion.

Solution

  1. You should open invoiced products in Quickbook and correct the "Inventory Start Date" property, it should be early when your Invoice date 
  2. If your Quickbooks does not allow you change described date, this problem could be resolved only if you manually delete your QuickBooks product and create it through the Magento sync process again (or create it manually with the "Inventory" product type setting).

You may need to also remove some of the old transactions in QBO that are linked to the product. The product can ONLY be deleted in QuickBooks if it is NOT linked to any invoices, orders, etc.