cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Hi, I received this message while trying to invoice a inventoried product.. "Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items" ?

Solved
Best answer October 19, 2018

Best Answers
Highlighted
Level 15

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

open the chart of accounts, find inventory asset and open the register

scan the register for that item with the notation START in the entry, that is the date QBO thinks you created the item

is that date before or after the date of the sale?

View solution in original post

28 Comments 28
Highlighted
Level 15

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

open the chart of accounts, find inventory asset and open the register

scan the register for that item with the notation START in the entry, that is the date QBO thinks you created the item

is that date before or after the date of the sale?

View solution in original post

Highlighted
Level 2

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

I'm having the same problem. It doesn't work. The message keeps coming up.

 

 

 

Highlighted
Content Leader

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Happy Friday, @JillP34.

 

Rest assured, I'll help you get to the bottom of this inventory tracking date issue. To clarify, are you saying that the date on which the inventory was added falls before the date you're trying to create an invoice for? If you haven't already, verify this with the steps below:

 

Verifying quantity tracking start date

  1. From QuickBooks Online, click the Gear icon (⚙) and select Products and Services.
  2. Scroll to the product you're trying to include on the Invoice, and click Edit.
  3. Under Quantity on Hand, click Starting Value. A message will appear warning not to change this value, select Got it!
  4. Verify the date in the Adjustment date box. This item can only be included on invoices that are dated on or after this date.

I'm attaching a brief video demonstration for your convenience:

 

 

Check out our detailed guide on tracking inventory in QuickBooks Online for more information. Please be sure to let me know what you learn about the inventory starting date, I want to get this issue resolved. Thanks for coming to the Community, I'll be standing by for your response.

Highlighted
Level 1

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Hi,

I've tried using this method however, I'm still getting the error message when trying to input an invoice!

Thanks,

Adam

Highlighted
Moderator

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Thanks for following up on this thread, AdamDeco.

Let me take over and get this resolved quickly.

 

Since QuickBooks Online is date specific, you can only post transactions after the start date of the inventory item. The date in the inventory item is to when you will start tracking quantity, which is why you can't create transaction before the date entered.

 

You have two options to get rid of this error message. First, you'll need to make sure that the invoice date you're trying to modify isn't before the starting date. Second, you can open the Products and Services and find the inventory item so you can change the date.

 

Here's how:

  1. Click the Gear icon at the top.
  2. Under Lists, select Products and Services.
  3. Look for the inventory item.
  4. Click the Edit button.
  5. On the Quantity on hand, select Starting value.
  6. Click the Got it button.
  7. Change the date under As of date.
  8. Hit Save and close.

I hope this response finds you with a smile. Let me know if I can be of additional assistance. Have a great rest of your day!

Highlighted
Level 1

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

after the sales.
getting an error: Something's not quite right
Please select a date that comes after the last transaction that used this item when you weren’t tracking it as inventory.
the start says 2019
but my transactions are 2018

Highlighted
QuickBooks Team

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Good day, @KatieJay.


Thanks for joining the thread. I'm here to help you get to the bottom of this.


As what my colleague @RoseMarjorieA mentioned, you can only post transactions after the start date indicated on the inventory item. You need to change it to get past the error message when creating an invoice.


Here's how:
1.    Go to the Gear icon and select Products and Services.
2.    Look for the inventory item.
3.    Click the Edit button.
4.    On the Quantity on hand, select Starting value.
5.    Once prompted, click the Got it button.
6.    Change the date on the As of date box from 2019 to 2018.
7.    Hit Save and close.


I’ve attached screenshots below for your reference.

 

 

After performing the steps above, you’re now ready to create an invoice with this inventory item. You may refer to this article for the instruction: How to create an invoice.

 

That’s it. Don’t hesitate to keep in touch with me here should you have additional questions or concerns. I’ll be here to help. Wishing you a wonderful rest for your day!

Highlighted
Level 1

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Ok so I figured out why some people have had an issue still. Just follow the steps everyone above is telling you to do but just change the start date to significantly further back. I had this issue as well and it was because I drew up the invoice before I ever entered the product onto my quickbooks account. Therefore when I tried to save the invoice it wasn't updating the transaction date to the current date so it was giving me that error message. So make sure the start date is pushed back before the date that you initially drafted the invoice and you should be good to go!

Highlighted
Moderator

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Welcome to the Community, @JaredR.

 

I'm glad to know that you already figured this out, and I appreciate you for sharing the steps you done to get this working. This will help other users who will encounter this issue in the future.

 

Also, thanks for being a part of our QuickBooks family. Feel free to swing by the Community should you have any concerns. Take care and enjoy your weekend!

Highlighted
Level 1

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

I have the same problem and I don't see how this solution will work.
I issued an invoice BEFORE I started tracking the inventory for the item because it was automatically imported from our online store. Therefore when I got to change the START date, it won't allow me to set any q'ty to any date BEFORE that invoice was issued so the problem remains.

 

I need a solution soon, since we issued many invoices BEFORE we started tracking the inventory.

 

PLEASE HELP

Highlighted
Level 1

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

I don't see how this solution will work.

We issued the invoice BEFORE we started tracking the inventory for the item. When I try to change the START value, it won't allow me to set any q'ty or any date BEFORE that invoice was issued. The error is quite clear:
"Please select a date that comes AFTER the last transaction that used this item when you weren’t tracking it as inventory."
HOW CAN I SET A STARTING VALUE BEFORE THAT INVOICE?

Highlighted
QuickBooks Team

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Hello there, @IgnacioB.

 

Thanks for joining us here in the Community. I'm here to provide additional insights into the message that you received when tracking inventory in QuickBooks Online.

 

Are you trying to make an inventory adjustment? If so, QuickBooks Online doesn't allow you to update the start date of an old inventory item, instead, you have to create a new item and go in and change all of the transactions to the new item, then delete the old one.

 

You can check out this article about creating an inventory item for your future reference: How to set up Inventory tracking. 

 

However, I encourage you sharing this idea to our Product Developers. Doing this helps them understand where we can improve and what features should be added so we can better serve you. Just click on the Gear icon and select on Send Feedback Online to submit your suggestion. 

 

Your willingness to help us improve our products is highly appreciated. 

 

Please know that the Community has your back should you need anything else. We're always here to help. Have a good one!

Highlighted
Level 1

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Thanks.  This worked for me.  Appreciate it.

Highlighted
Level 1

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Thank you so much for sticking with this. Yes, this was the problem. It doesn't matter what you change the date to on the estimate/invoice, the start date for the inventory item needs to be dated before the INITIAL date of the estimate. I think we are going to start dating new inventory items one year earlier just to be on the safe side.
Highlighted
Level 1

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Does that mean I have to manually adjust the starting value date on every single line of my inventory? Repeat the process over 1000 times on everything inventory items I have? 

Serious?

Highlighted
Moderator

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Hello jayfu,

 

Yes, you'll have to manually adjust the Inventory Starting Value to create transactions that dated earlier than the item.

 

I'll show you how:

 

  1. Go to the Gear icon and select Products and Services.
  2. Locate the inventory and select Run report from the Action column.
  3. Under the Transaction Type column, click the Inventory Starting Value.
  4. Update the As of date box.
  5. Hit Save and close.
  6. Repeat as needed.

Please reach out to me if there is anything else I can help you with. I'll always be here to assist you. Have a good day.​

Highlighted
Level 1

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Hello, I have run the report on the inventory but there is no option to click Inventory Starting Value under Transaction Type?

Highlighted
Moderator

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Hello, MotoGirl.

 

Let's run the report again and change the Report Period to All Dates, so you'll be able to see the Inventory Starting Value option. Here's how to do it:

  1. Go to Sales tab, then Product and Services.
  2. Locate the Inventory item.
  3. Click the drop-down arrow in the Report period.
  4. Choose All Dates.
  5. Then, click Run Report button.

Also, you can pull up the Purchases by Product/Service Detail report to see all lists of your inventory items.

 

Please let me know if you need more help.

Highlighted
Level 1

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Hi,

 

I have the same issue.

 

After following all the steps mentioned, I am not able to change the as-of-date. It throws the following error.

 

"Please select a date that comes after the last transaction that used this item when you weren’t tracking it as inventory"

 

Please help!

Highlighted
QuickBooks Team

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Welcome and thanks for joining in this conversation, @ebullientautomation. The error message you received appears if the date of the transaction you're trying to create comes prior to the As of date of the inventory item.

 

To resolve this issue, ensure that the date of the transaction matches the date when you started tracking the quantity on hand of this item. Let's verify the date by following these steps below:

 

  1. Click the Gear icon, then select Products and Services under the Lists column. 
  2. Locate the item that you're trying to use on the transaction.
  3. Click Edit in the far right.
  4. In the Product/Service information page, go to the Quantity on hand section.
  5. Click the Starting value link and click Got it! on the prompt message.
  6. Once you're on Inventory Starting Value screen, change the As of Date to match with your invoice. 
  7. Click Save and close.

 

For more information, here's an article that talks more about the inventory overview and its setup

 

Additionally, read through this article to learn more about creating items: Add inventory products in QuickBooks Online

 

I'll be here if you have additional questions. Thanks for dropping by.

Highlighted
Level 2

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Hi 

if you find the solution please share it with us

QuickBooks Team

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Hey, @Ghadeer947

 

Thanks for reaching back out to the Community. If you're still having issues after trying the troubleshooting steps listed above, then I recommend contacting our Customer Support Team. They have the tools to look further into your account to see what's causing this to occur. 

 

  1. Go to the Help icon in the top right-hand corner. 
  2. Click Contact Us
  3. Type in your question and press Let's Talk
  4. Scroll down and choose to Get a Callback

 

Let me know how it goes. I want to make sure that you're able to get back to running your business. Have a splendid day!

Highlighted
Level 2

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

Is there a way to make this behavior stop?  I don't want to constantly be harassed about dates.  The software needs to just do want I tell it to.  I'm the boss in this situation, not the software.  If this was an employee, I would fire him/her.  I spend more time trying to please the software than I do getting work done.  QBO is not ready for prime time I guess.

Highlighted
Moderator

"Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items". My dates look good so I'm confused?

I appreciate your feedback, WR_ELY.

 

In QuickBooks, we're unable to turn off the Please select a transaction date that comes after the date you started tracking the quantity on hand of these inventory items error message.

 

This is to track the inventory correctly. We can get rid of this error by making sure that the invoice date is after the start date of the item or we can directly modify the Start date of the item. I'll show you how:

 

  1. Click the Gear.
  2. Under Lists, select Products and Services.
  3. Look for the inventory item.
  4. Click the Edit button.
  5. On the Quantity on hand, select Starting value.
  6. Click the Got it button.
  7. Change the date under As of date.
  8. Hit Save and close.

 

I've also added this article for more information when tracking inventory in QuickBooks: Set up and track your inventory.

 

Feel free to reach out to me in case you need help. Keep safe!

Need to get in touch?

Contact us