Skip to main content
U
USV360
November 9, 2022
Question

How I can run a report for quantity been purchased of each item/SKU from day one

  • November 9, 2022
  • 2 replies
  • 0 views

How I can run a report for quantity been purchased of each item/SKU from day one

2 replies

M
mv32
November 9, 2022

Hi @USV360.

 

You can run the Inventory Valuation Detail report to see the number of items purchased starting from day one. Then make sure to adjust the Report period to a starting date up to the recent date.

 

Here's how:

  1. Click the Search icon on the top right.
  2. Type Valuation in the Search box and then select Inventory Valuation Detail.
  3. Change the Report period to Custom.
  4. Adjust the dates.
  5. Hit Run report.

 

You'll see the number of items purchased and the number of items being added. Also, it will show you there the remaining on-hand total of each item.

 

 

You can reference this article for more details: Run reports in QuickBooks Online. This covers how to run reports for specific accounts, print, email, and export reports.

 

Additionally, you can add other helpful columns to your reports. Just click the mini Gear icon of that specific report found on the upper right of it or Customize report data to see more specific details. From there, you can include some columns or remove them by checking and unchecking the boxes.



 

Feel free to comment if you have to need more assistance. I'm always here to help you out. Stay safe and more power to your business!

U
USV360Author
November 16, 2022

Thank you, this is the only time that QB solve a problem

R
rvrfrf
November 16, 2022

Thanks for getting back with the Community, USV360.

 

I'm happy to hear Jovychris_A was able to help with finding a report you can run to see the number of items purchased.

 

You'll also be able to find many detailed resources about using QuickBooks in our help article archives.

 

Please feel welcome to send a reply here or create a new thread if there's ever any questions. Have an awesome Wedsnesday!

H
hans_axiom
December 4, 2024

This is the question I have, but not the answer I'm looking for.  How do you find the total quantity of an item purchased in a particular timeframe.  PURCHASED, as in created and sent a PO to a vendor, not invoiced or something else.  If you do a quick report on an item, it shows a quantity of zero for any PO that has been fulfilled.  I want to see the total quantity of the item as it appears on POs for the year.

I
IrishA
December 4, 2024

Good day, @hans_axiom.

 

Yes, In QuickBooks Online (QBO), you can view the product quantities from the purchase order report.

 

I'm happy to walk you through the process. Please refer to the steps below:

 

  1. Go to Reports.
  2. Navigate from the find report by name in the upper right corner.
  3. Type in the Open Purchase Order Detail report on the search bar.
  4. Filter the report period to All Dates.
  5. Once done, click on Run Report.

 

Moreover, you can generate a report for open purchase orders. Nonetheless, once a purchase order is converted to a bill, there isn't an available option to pull up that report. Otherwise, you can still check your QTY manually once it is converted to a bill. Here's how you can do it:

 

  1. Go to Expenses menu.
  2. Click on Expenses.
  3. On the All Transactions section, click on the dropdown.
  4. Choose the desired Purchase Order to see the quantities.
  5. Once there, click on Item details.

 

Our goal is to cater to the business needs of all our customers. I understand that adding this reporting option would greatly enhance the efficiency of your business operations. Please rest assured that your concern will be heard and addressed. We can propose this to our software engineers for consideration in future updates. To share your feedback, please follow these steps:

 

  1. Go to Setting.
  2. Under PROFILE, click on Feedback.
  3. Once done, click Next.
  4. In the feedback section, you can type in your suggestion to be directed to our product engineers.

 

Lastly, I've included a useful article that provides insights on how to customize a report: Customize reports in QuickBooks Online.

 

If you have additional questions or concerns, please add a comment. We're happy to help. Have a wonderful day ahead!

H
hans_axiom
December 4, 2024

I'm on desktop, not QBO, but I assume it's the same as Purchases by Item Detail.  If it is, it doesn't give you a list of the purchase orders and quantities, just item receipts and bills.  Those items could be receipts from purchase orders prior to the intended period and it doesn't show you items purchased but not received.  It seems like the answer is "no, quickbooks can't show you what order quantity has been placed in a given period".  Am I correct?  The best solution would be for the programmers to fix the quick report for items to show the ordered quantity instead of showing a value of "0" for orders that have been fulfilled.  Showing a value of "0" doesn't seem to offer anyone any useful information.

Terms & ConditionsAccessibility statement