ErrorCode : 6270 - Transactions with Inventory (QOH) products can't be dated earlier than the Inventory Start Date for the products.
This article guides Webgility Online users in resolving "ErrorCode : 6270 - Transactions with Inventory (QOH) products can't be dated earlier than the Inventory Start Date for the products.", which occurs when posting orders to QuickBooks Online for inventory products dated earlier than their inventory start date. The error happens because QuickBooks Online does not allow transactions for items before their inventory start date. To fix this, users must update the inventory start date for the affected product in QuickBooks under Products and Services, adjust the “As of” date to precede the transaction date, save the changes, and then download the latest accounting data in Webgility Online. Once updated, the order can be posted successfully.
Overview:
This error typically occurs when posting orders to QuickBooks Online. It arises when the inventory start date of an item (came in the order) is later than the transaction date being created. QuickBooks Online restricts the sale of items to orders placed on or after the product's inventory start date. Attempting to sell an item before this date prevents QuickBooks from generating the corresponding transaction.
Causes of Issues:
Inventory start date on the item (came in the order) is later than the sale date/transaction date.
Steps to resolve:
A) Change Inventory start date:
1). Navigate to Settings (gear icon) > Products and Services, then use the search bar to find the required inventory item.
3). When the Inventory Starting Value popup page loads, adjust the As of date field to a date that is earlier than the date you wish to record the inventory transaction.
5). Once done then download the latest accounting data in Webgility Online from QuickBooks. Kindly refer the article: Download the Latest Data from QuickBooks in Webgility Online
B) Alternate method - Adjust the Transaction posting date setting
1) In Webgility Online nagivate to Sync Settings > Orders > Set the Invoice/Sales ReceiptDate as > select "Date of Posting" > Save.
Once done then try to post the order again via Webgility Online.
Note: Revert the settings once you are posting orders by the help of alternate method