Question

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

Forum|Forum|7 years ago
December 9, 2018
31 replies
0 views

Original commenter did not share additional details

QuickBooks Online

I know why you're getting this message, camasc26.

This warning appears if the date on the transaction you're trying to create comes before the As of date of the inventory item. Please ensure that the date of the transaction is the same date when you started tracking the quantity on hand of this item.

To verify the date, you can refer to these steps:

Click the Gear icon.
Under Lists, select Products and Services.
Find the item that you're trying to use on the transaction.
Click Edit in the far right.
In the Product/Service information page, go to the Quantity on hand section.
Click the Starting value link and click Got it! when prompted.
In the new window, verify the As of date.
If it's wrong, you can change it. If it's correct, then leave it as it is and click Save and close.

Here's an article that talks more about the inventory overview and its setup.

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

S

Sen139

what if you have to change tracking date for hundreds of SKU? Is there a way to do it fast?

A

AileneA

Hi there, @Sen139.

Thank you for reaching out to the Community. As of this moment, we can only change the date by manually modifying each tracking date of your SKU.

I understand how beneficial it is to your business. Rest assured, our developer's team is working hard to develop the best features to fit the needs of our customers.

I suggest visiting our Blog site. This is where we share recent happenings and future developments, such as updates to newly added features. Here's the link: The QuickBooks Blog.

Please know that the Community is always here to help you out to make you and your business easy and functional. Take care.

P

Polly202109

We've got a problem as follows:

(1) We set the initial cost of a particular item as say $500 per each, but then one day we input an entry by "inventory quantity adjustment"(IQA) with "-1" quantity. But then don't know why the unit value of this item suddenly changed as $1000. So the IQA entry became as -1 pc with -$1000 in asset value. Subsequently all the unit cost whatever in or out was changed to $1000.

(2) Before these changes we have 6 pcs @ $500 each ==> $3000 total asset value

(3) Afterwards, 6 pcs was recorded out @ $1000 each ==> total -$6000 asset value

(4) Finally we have "Zero" quantity on hand but with -$3000 asset value stated in ledger

How can we fix it? Please help to solve it! Thanks!!

How can I fix it

RenjolynC

Thanks for chiming in on this thread, Polly202109.

Let me add some information about your concern.

When you notice a change on the cost or sales price/rate, it's possible that someone updated it. You can run the Audit log report to view who made some changes on the products by following these steps:

Go to the Gear icon located in the upper right-hand corner.
Under Tools, click Audit log.
Choose the User and set the Date.
From the Event drop-down, select List.
Look for the Edited Product or Service in the Event column.

To modify the item's cost, you can follow these steps:

On the left panel, click Sales > Products and services.
Find the item and click on the Edit link to see and edit the cost.

To learn more about the inventory feature in QuickBooks Online, please check out these articles:

Please feel free to reply on this thread again if there's anything else you need. We're always available to help you out. Take care!

M

MattKYC

Is there a way to view the start tracking date is for inventory items using a report? Let's say you have 150 items you are adjusting the inventory on, but one had the starting inventory date entered incorrectly, instead of having to search through every single item, to see which one has the date that needs to be adjusted, printing out a report that lists the inventory start date would be very helpful in narrowing your search down. Anytime there is something in QBO that keeps you from performing a function, having the information available that needs to be corrected would be very beneficial. And if I get a response saying "rest assured our development team is working on this" I would respond that there are several known QBO issues that the development team has been working on for the better part of a decade.