I have modified the starter report Sales Item Forecasting in QBAR to show sales year over year for the past 3 years. Unfortunately, many of our inventory items are not sold outright, but are used in Inventory Adjustments or Builds to make a variety of other products. This report is only showing invoiced sales, however, I need to add in Inventory adjustments and builds as well.
This is the expression being used to total sales: sum({$<$(vExprDayRangeFilter(365,0)), $(vExprSales)>} [Transactions.Quantity With Sign])
I'd like to add Inventory Adjustments and used in builds into this expression so that it will show all instances of the item being used.
I'd also like to see Adjustments and builds as separate columns so that we can evaluate to see if we are spending too much time on builds as opposed to ordering the items whole.
We use QB Enterprise Desktop for Manufacturing and Wholesale.
Thanks in advance for any assistance you can provide.
