Good afternoon,
This question is related to inventory management. I work for a company which has several locations treated as separate warehouses in the inventory management module. We use physical counts to determine materials usage for Cost of Goods Sold. An operations manager would like to see month-by-month usage by item and by branch (warehouse). Is there a report in Sage 100 that would provide this detail?
Hi J05ephL, if this suggested answer helped, please mark it as verified 
(by clicking the "…."next to Reply, on the response) for the benefit of others in this forum 
. Thank you!
Context:
(Enhancements may add more codes).
I assumed "we use physical counts to determine material usage..." as meaning they don't do traditional transactions for inventory consumption, and only needed to count the IP records.
Something like this?
This took less than 5 minutes to set up, but what really matters is your transaction volume. Excel sometimes doesn't handle massive data sets (...millions of rows) very well.
