cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Super Explorer **

Tracking Inventory for individual SKU numbers

Is there a way to enter a SKU or product number to follow it's individual tracking? In other words, i would like to be able to enter a SKU and see when it was entered, invoiced, adjusted, paid, ect.

Solved
Best answer 01-03-2019

Accepted Solutions
Established Community Backer ***

Re: Tracking Inventory for individual SKU numbers


@dal1cas2 wrote:

My question is how can I follow that SKU through the process of invoice, sales, ect. I have the SKUs entered. I want to be able to enter a SKU and see where that item was used when no longer a part of inventory. Once you add a SKU to an invoice, is there a way to track it without knowing the invoice number? Or to see if it maybe was adjusted from the inventory? The Product Service List does not show that information. It only shows the quantity left.


True, that is what the products & services shows, but I suggested you use the drop down selector arrow on the far right side of the item and select report

 

that WILL show item movement

View solution in original post

11 Comments
QuickBooks Team

Re: Tracking Inventory for individual SKU numbers

Good day, dal1cas2!

 

I'll be glad to help you set up your inventory items with their SKU numbers.

 

But first, you'll have to turn on the Track inventory quantity on hand feature.

 

Here's how:

  1. Go to the Gear icon.
  2. Under Your Company, select Accounts and Settings.
  3. Select Sales.
  4. Click Products and services.
  5. Check the box for Track inventory quantity on hand.
  6. Click on Save, then Done.

Once done, you can now add your inventory items with their SKU numbers.

  1. Go to Sales.
  2. Select Product and Services.
  3. Click New.
  4. Select Inventory.
  5. On the name field, enter the name of the product.
  6. Under the SKU field, enter the SKU number of the product.
  7. Enter additional information as needed.
  8. Click on Save and close.

You check the screenshot below for visual references.

 

 

To add, please note that each product should have its unique SKU.

 

Here's handy reference that you might want to take a look at to learn more about inventory tracking: How to Set up Inventory and Tracking?

 

Please feel free to come back here to the Community if you need any other help. It will be our pleasure to always help you

Established Community Backer ***

Re: Tracking Inventory for individual SKU numbers

enter it where?

best option is open the products & services list and use the droop down selector far right and select report

Super Explorer **

Re: Tracking Inventory for individual SKU numbers

My question is how can I follow that SKU through the process of invoice, sales, ect. I have the SKUs entered. I want to be able to enter a SKU and see where that item was used when no longer a part of inventory. Once you add a SKU to an invoice, is there a way to track it without knowing the invoice number? Or to see if it maybe was adjusted from the inventory? The Product Service List does not show that information. It only shows the quantity left.

Super Explorer **

Re: Tracking Inventory for individual SKU numbers

My question is how can I follow that SKU through the process of invoice, sales, ect. I have the SKUs entered. I want to be able to enter a SKU and see where that item was used when no longer a part of inventory. Once you add a SKU to an invoice, is there a way to track it without knowing the invoice number? Or to see if it maybe was adjusted from the inventory? The Product Service List does not show that information. It only shows the quantity left.

Established Community Backer ***

Re: Tracking Inventory for individual SKU numbers

Reports>Sales and Customers>Inventory Valuation Detail, Customize>Filter, select Product/Service

Super Explorer **

Re: Tracking Inventory for individual SKU numbers

That does not tell me where the inventory has gone only that the quantity is now 0

Established Community Backer ***

Re: Tracking Inventory for individual SKU numbers


@dal1cas2 wrote:

My question is how can I follow that SKU through the process of invoice, sales, ect. I have the SKUs entered. I want to be able to enter a SKU and see where that item was used when no longer a part of inventory. Once you add a SKU to an invoice, is there a way to track it without knowing the invoice number? Or to see if it maybe was adjusted from the inventory? The Product Service List does not show that information. It only shows the quantity left.


True, that is what the products & services shows, but I suggested you use the drop down selector arrow on the far right side of the item and select report

 

that WILL show item movement

View solution in original post

Super Explorer **

Re: Tracking Inventory for individual SKU numbers

Okay I see where you are saying. That's perfect. Thank you.

Not applicable

Re: Tracking Inventory for individual SKU numbers

Hi @JonpriL,

Within a certain SKU, can you add the serial numbers of the stock on hand?

 

i.e. SKU 123 is Product A. Recently bought a shipment of 10 Product A's from a supplier, with serial numbers 1001-1010. At customer Z's site, I installed 2 Product A's of serial numbers 1009 and 1010. 

Is there anywhere I can track this in Quickbooks Online, so that when I do an inventory check in the warehouse it will show for SKU 123 that I should have serial numbers 1001 through 1008?

QuickBooks Team

Re: Tracking Inventory for individual SKU numbers

Hi there, KZH28.

 

While there's not a way to add a serial number for the item, you can add the figures in the Sales/Purchase information box. Then, manually edit them for tracking purposes. 

 

I've added a sample screenshot for your reference.

 

I'll make sure to take note of this suggestion and pass it to our product engineers. Most of the update comes from our customer's feedback, and this might be added in the future.

 

Feel free to reach out to us if you have any other questions or concerns. Thanks.

Not applicable

Re: Tracking Inventory for individual SKU numbers

Thank you @RenjolynC that would be a really really helpful feature if your product engineers could please implement it.

Need to get in touch?

Contact us