Hello there, @chris75. Thank you for the quick response. Allow me to help share some insight to create a transaction using an inventory item. The steps provided by my colleague allows you to edit the start date or As of date in that item. This way, QuickBooks allows you to move the date back when creating the transaction. However, if you get a warning that you can't adjust the item's starting date because it doesn't have a starting value transaction associated with it, I suggest creating a new inventory item instead. Here's how:Select the Gear icon on the Toolbar.Under Lists, select Products and Services.Select New.Choose Inventory as the type.Enter the information required. Please make sure to enter the date you start to track the inventory item’s quantity on hand in the As of date field.You may want to use this article for additional reference: How to set up Inventory tracking (Create inventory items). Let me know how this turns out or if you have any other questions with QuickBooks Online. I'll be glad to help you further. Have a great rest of the week.

Hello there, @chris75. I can furnish you with some details so you'll be able to record and save your transactions in QuickBooks successfully. You received the prompt because the date of the transaction you're trying to record is after the start date of the inventory item. To remove the prompt, here's how:Click the Gear icon (⚙).Choose Products and Services.Look for the inventory item.Click the Edit button.On the Quantity on hand, select Starting value.Click the Got it button.Change the date under As of date.Hit Save and close. That should do it! Let me know how it works on your end. I'm always here to help you in tracking your inventory in QuickBooks Online.

Solved

I cannot save transactions because the transaction date is BEFORE the opening balance date of an inventory account. How to change the date on the inventory account

Forum|Forum|7 years ago
April 26, 2019
1 reply
12 views

No text available

QuickBooks Online

Best answer by MaryGraceS

Hello there, @chris75.

Thank you for the quick response. Allow me to help share some insight to create a transaction using an inventory item.

The steps provided by my colleague allows you to edit the start date or As of date in that item. This way, QuickBooks allows you to move the date back when creating the transaction.

However, if you get a warning that you can't adjust the item's starting date because it doesn't have a starting value transaction associated with it, I suggest creating a new inventory item instead.

Here's how:

Select the Gear icon on the Toolbar.
Under Lists, select Products and Services.
Select New.
Choose Inventory as the type.
Enter the information required.
Please make sure to enter the date you start to track the inventory item’s quantity on hand in the As of date field.

You may want to use this article for additional reference: How to set up Inventory tracking (Create inventory items).

Let me know how this turns out or if you have any other questions with QuickBooks Online. I'll be glad to help you further. Have a great rest of the week.

IamjuViel

Level 8

Hello there, @chris75.

I can furnish you with some details so you'll be able to record and save your transactions in QuickBooks successfully.

You received the prompt because the date of the transaction you're trying to record is after the start date of the inventory item.

To remove the prompt, here's how:

Click the Gear icon (⚙).
Choose Products and Services.
Look for the inventory item.
Click the Edit button.
On the Quantity on hand, select Starting value.
Click the Got it button.
Change the date under As of date.
Hit Save and close.

That should do it! Let me know how it works on your end. I'm always here to help you in tracking your inventory in QuickBooks Online.

C

chris75Author

QB Online will not allow me to set the date for BEFORE the transaction occurred (e.g. we received inventory in September and sold it in October but the start date of October 1 is throwing the error. I cannot move the date back). QB is forcing me to se an inventory level effective AFTER the first sale for the item.

M

MaryGraceS

Answer

Moderator

Hello there, @chris75.

Thank you for the quick response. Allow me to help share some insight to create a transaction using an inventory item.

The steps provided by my colleague allows you to edit the start date or As of date in that item. This way, QuickBooks allows you to move the date back when creating the transaction.

However, if you get a warning that you can't adjust the item's starting date because it doesn't have a starting value transaction associated with it, I suggest creating a new inventory item instead.

Here's how:

Select the Gear icon on the Toolbar.
Under Lists, select Products and Services.
Select New.
Choose Inventory as the type.
Enter the information required.
Please make sure to enter the date you start to track the inventory item’s quantity on hand in the As of date field.

You may want to use this article for additional reference: How to set up Inventory tracking (Create inventory items).

Let me know how this turns out or if you have any other questions with QuickBooks Online. I'll be glad to help you further. Have a great rest of the week.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded