Skip to main content
O
OXUSA
January 9, 2021
Solved

Item usage by date range for multiple items

  • January 9, 2021
  • 1 reply
  • 0 views

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.

Best answer by MichelleBh

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.

1 reply

MichelleBh
MichelleBhAnswer
January 9, 2021

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.

Terms & ConditionsAccessibility statement