Discussions
Vendor Usage Report
I want to create a Vendor Usage Report using Saved search.
Select vendor. See usage by item. Location is often useful… nice if we can have it expand on demand (see usage details). Usage = sales and WO consumption. NOT inventory adjustments.
Other fields from item / location would be needed: min / max, description, vendor code, quantities (available, on hand, on po). Parameters for date (default to prior 12 months) I am struggling to get MonthYear in column from Item Saved search . The Month should be dynamically set for past 12 months .