I cant seem to find a report even with customization that will give me item usage by date range for multiple items. The issue comes in to play with assemblies. If I just view a sales report, it does not pull the items in assemblies. I have found a way to get the data by opening a quick report and adding starting quantity and all the received items and subtracting the what is in stock balance at the end. However that's pretty time consuming for 900 parts. I need the data to know what quantities to order and to readjust my reorder points as sale change thru time. I am really surprised as simple of a report it should be, and as important as sales and usage data is, that there isn't something there for it.
Solved! Go to Solution.
Hello there, @OXUSA.
I'm happy to present the steps on how to access this kind of report in QuickBooks Desktop.
Let's pull the Stock Valuation Detail Report. You'll see all the transactions of each item on the specific dates. Also, this report is the monetary amount associated with the goods in the inventory at the end of an accounting period. The valuation is based on the costs incurred to acquire the inventory and get it ready for sale.
You can also customize the report by clicking the customize report on the upper left side. For more details, check out this article: Customize reports in QuickBooks Desktop.
I've added some articles about different reports, managing assemblies, items, and other related topics.
Comment below if you have other questions. Take care always, and stay safe.
Hello there, @OXUSA.
I'm happy to present the steps on how to access this kind of report in QuickBooks Desktop.
Let's pull the Stock Valuation Detail Report. You'll see all the transactions of each item on the specific dates. Also, this report is the monetary amount associated with the goods in the inventory at the end of an accounting period. The valuation is based on the costs incurred to acquire the inventory and get it ready for sale.
You can also customize the report by clicking the customize report on the upper left side. For more details, check out this article: Customize reports in QuickBooks Desktop.
I've added some articles about different reports, managing assemblies, items, and other related topics.
Comment below if you have other questions. Take care always, and stay safe.
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
These cookies are strictly necessary to provide you with the services and features available through our site. Because these cookies are strictly necessary to deliver the site, you cannot refuse them without impacting how the site functions.
These cookies are used to make advertising messages more relevant to you and your interests. They also perform functions like preventing the same ad from continuously reappearing, ensuring that ads are properly displayed, and in some cases selecting advertisements that are based on your interests.