Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I'm on QB Desktop
I need a report that shows in the in/out of an inventory item with a running inventory amount. I did this report before so I know it's possible, but I cannot figure out how to do it again. ARG! It had the running list of items used in builds and items received into inventory from POs.
I find it frustrating that QB makes item receipt records go *poof* when you enter the bill.
TIA
Solved! Go to Solution.
Thanks for following up with the Community, Maverick2.
Your Inventory Valuation Detail report shows information about inventory value, stock status, and pending builds. You'll also see transactions for each item on it.
Here's how to run it:
If you need more detail on the report, you can export and further customize it outside of QuickBooks.
Here's how to export reports:
Now you can customize your exported report further in Excel.
I've also included a couple detailed resources about working with reports which may come in handy moving forward:
Please don't hesitate to send a reply if there's any questions. Have a wonderful day!
I can show you how to generate a report that shows the running balance of an inventory item quantity, @Maverick2.
We can create a custom report to show the in/out of an inventory item with a running inventory amount. Let me show you how:
Additionally, I've attached some links you can utilize to guide you in personalizing reports as well as how to save them on its current customization setting in QuickBooks Desktop:
Fill me in if you have further questions about running reports in QuickBooks. I'll be around to help you always. Keep safe!
I need to revisit this thread. The method outlined in the 2nd post only shows the qty of items removed from inventory when an item is built. It has two columns: Item Number, and the total taken out of inventory for that time period (for assembly builds).
I need to see these columns: Item number, qty added to inventory by any method, qty removed from inventory by any method, and the total running quantity. I need to see each in / out.
Again, I've done this before, I just can't figure out how I did it before.
Thanks for following up with the Community, Maverick2.
Your Inventory Valuation Detail report shows information about inventory value, stock status, and pending builds. You'll also see transactions for each item on it.
Here's how to run it:
If you need more detail on the report, you can export and further customize it outside of QuickBooks.
Here's how to export reports:
Now you can customize your exported report further in Excel.
I've also included a couple detailed resources about working with reports which may come in handy moving forward:
Please don't hesitate to send a reply if there's any questions. Have a wonderful day!
AHA! Yes that's it. Thank you.
And an FYI, if you type Inventory Valuation Detail in the search field in the top right, it doesn't find it. However it was easy enough to find by clicking on the inventory choice in the left pane.
You're most welcome, Maverick2.
I’m glad to hear that the information provided by my colleague above helped you locate the inventory report you need.
Please feel welcome to reply here or create a new thread if there are any other QuickBooks-related questions. Have a great day ahead!
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