Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
amyp
Level 2

Reply to message

I couldn't agree more.

The inventory reporting is HORRIBLE in QB.

The information HAS to be there!

I can't get a slow moving inventory report.

My fix:

run a sales report of items sold within a given time period-export to excel

run the inventory valuation report as of a certain date or physical inventory count-export to excel

use funtions (conditional formatting or index or other) in excel to compare the two reports and identify items that HAVE sold within the given time frame thus what has NOT sold should be a slow-moving item.

 

Another frustration-why can't I get a physical count that shows the inventory on hand valuation?  Don't want to count ALL the inventory but want to count 80-90% of inventory value.

Instead I have to export to excel and use excel to calculate same.  UGH.

 

Amy

Need to get in touch?

Contact us