cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
raineywars
Level 1

Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items.

None of these responses actually fix the problem. This has been going on for years. Does anyone know how to fix the actual issue at hand?

We created an item on 4/9/24 to begin tracking on 01/01/21 with 0 quantity. First purchase was made 11/01/23, first sale was made 11/02/23. Invoice says please select a transaction date that comes after the date you started tracking the quantity. Does anyone know how to actually fix this?

raineywars
Level 1

Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items.

Item was set up 04/09/24 to start tracking as of 01/01/21 with a starting quantity of 0. First purchase was made on 11/01/23 and first sale was on 11/02/23. Invoice says please select a transaction date that comes after the date you started tracking the quantity.

How do we fix this? None of the above responses actually fix the issue, so please don't repeat the nonsense that was already posted. We need an actual fix for this issue.

MichaelaS
QuickBooks Team

Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items.

I recognize the importance of accurately tracking your invoice dates based on when they got paid, Rainey. Allow me to share steps to help fix the problem.

 

This warning appears if the invoice date is the date before you start tracking the quantity on hand for the item. See the example screenshot below.

 

 

To fix this, we need to check the quantity date set on the item. Ensure that the dates selected is correct.

 

Here's how:

 

  1. Go to the Left panel and select Sales.
  2. Choose Products and Services.
  3. In the Action column, click Edit on the item you use on the invoice.
  4. Click the Staring value hyperlink, then select Got it!.
  5. Ensure to set the date correctly.

 

If you notice that you have entered the date as 01/01/21, but you still see the warning message on the invoice, I recommend taking some basic troubleshooting steps to check if it is a browser issue. Your browser's cache and cookies may have become corrupted, which can cause problems when accessing websites or opening files. 

 

You may also try using a private window to prevent your browser history from being saved. Please refer to the following keyboard shortcuts based on your browser type.

 

  • Google Chrome: Ctrl + Shift + N
  • Mozilla Firefox: Ctrl + Shift + P
  • Microsoft Edge: Ctrl + Shift + P
  • Safari: Command + Shift + N

 

If the private browsing session works, clear the browser's cache so the system can restart. This task is also possible in other supported, up-to-date browsers. Clearing the cache will reboot the system, allowing you to work with clearing the stocked cache and cookies causing the issues.

 

In addition, you may check this article as your guidance in manually tracking the value of inventory assets: Track inventory manually in QuickBooks Online.

 

Please let us know if you have other queries about item setups. I'm always here for you. Stay safe.

 

 

Handprintinc
Level 1

Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items.

Your quickbooks advisors told me to choose the inventory tracking start date at the end of the previous month without explaining the implications of that start date. Now, I have invoices that still have to be created for items sold before that month but QB does not allow me to track it. Ridiculous to have people working for an accounting/software company that are advising small businesses when they do not know what they're talking about. 

 

Then to say you don't have a solution to fix it. Quickbooks has turned into a joke.

RogelioL
QuickBooks Team

Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items.

We don't want you to have this kind of experience, @Handprintinc. Let me help you fix your inventory tracking start date.

 

Firstly, let's edit your start date so QuickBooks will allow you to track your invoices:

  1. Click the Gear icon, then choose Products and Services.
  2. Look for the inventory item and click the Edit button.
  3. On the Quantity on hand, select the Starting value.
  4. Click the Got it button, then change the date under As of date.
  5. Hit Save and close.


When editing, I recommend selecting a date before the invoice creation date. This way, the QuickBooks will allow you to track it.

 

For further details about managing your inventory, please refer to these articles:

 

Additionally, you can check out this article to see your best sellers, what's on hand, and the cost of goods: Use reports to see your sales and inventory status in QuickBooks Online.

 

Let me know if you have further concerns about editing your inventory start date or need assistance with QuickBooks. Keep safe.

Handprintinc
Level 1

Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items.

This does not work. I receive the error message "

You can’t create or modify a transaction with a date that comes before you started tracking quantity on hand for the following: MC9590-KC0DAB00100."
 
Intuit quickbooks online put me in this position when they advised me to start inventory tracking in June 2024 without explaining the implications of that start date. Now I can't write checks for purchase orders written before that date. On top of that, the solution quickbooks online has provided doesn't work.
JamaicaA
QuickBooks Team

Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items.

The "as of" of an inventory item is the date we record its quantity and cost in the accounting system that's why you're unable to create a backdated check, Handprint. Processing purchase orders from earlier dates is vital, so let's work together to modify the date and continue tracking the quantity accurately.

 

We can change the As Of Date to make backdated Check entries in the program. To do that, follow the steps below:

 

  1. On the left panel, go to Sales and hover your mouse over Products & services.
  2. Locate the item and select Edit.
  3. Under the Inventory info section, click Starting value.
  4. Adjust the AS OF DATE to the desired period to enter backdated transactions, then Save.
  5. Click Save again.
  6. Go to the +New button and select Check under the Vendors column.
  7. Fill out the necessary information, then Save and close.

 

 

Moreover, adjusting the date will change the timing of when the inventory is recognized, which can impact financial reports and inventory valuation or cogs calculations. Thus, I highly recommend consulting an accountant to consider the implications and ensure these records are valid and consistent. If you don't have one, seek assistance from QuickBooks Live Expert Assisted to receive appropriate guidance on monitoring your supplies.

 

Here's an article explaining how items impacts your business reports: Impacts of inventory tracking on the Balance Sheet and Profit & Loss reports in QuickBooks Online.

 

Furthermore, use reports to see your sales and inventory status in QuickBooks Online to know your best sellers, on-hand items, and more.

 

For additional questions about tracing items and check arrangement, kindly add them below. We're here to support you in ensuring smooth financial and inventory management. Stay safe.

Log in today
Get expert help and peer support to tackle all your QuickBooks questions effortlessly.

Need to get in touch?

Contact us