cancel
Showing results for 
Search instead for 
Did you mean: 
USV360
Level 2

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

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

7 Comments 7
Jovychris_A
Moderator

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

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.


1.png

 

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!

USV360
Level 2

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

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

ZackE
Moderator

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

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!

hans_axiom
Level 1

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

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.

IrishA
QuickBooks Team

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

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!

hans_axiom
Level 1

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

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.

Erika_K
QuickBooks Team

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

Thank you for providing clarity on the product you’re using, hans. I appreciate your continued engagement in this conversation.

 

The option to display purchase orders and quantities in the Purchases by Item Detail report isn't available. However, we appreciate your feedback and encourage you to submit your feature suggestion to our Product Development Team. Your input is crucial for identifying areas for improvement, and our team will review your recommendation thoroughly.

 

I'll show you how you can send one:

 

  1. Locate the Help option.
  2. Choose the Send Feedback Online option.
  3. Select the Product Suggestion option. A pop-up window displays. Enter your feedback suggestion.
  4. Click the Send Feedback button.

 

In the meantime, I'd recommend exporting the Purchases by Item Detail report into an Excel file for further analysis and customization.  

 

Additionally, check out these articles to help you with adding personal touches to your reports and saving the personalized settings to be available for future use:

 

 

Just a reminder that I’m here to support you every step of the way! If you have any questions or need assistance managing and customizing your financial reporting, share them in the comments below. Together, we’ll make sure you get the most from your QuickBooks experience.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us