Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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:
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!
Thank you, this is the only time that QB solve a problem
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!
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.
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:
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:
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:
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!
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.
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here