How to pull the last 12-months usage for each item and calculate the 12-month usage value (12 month
Hi All,
The business requires an enhancement to this report that will pull the last 12-months usage for each item and calculate the 12-month usage value (12 month usage x standard cost) and calculate the turns (12 month usage/Quantity On-Hand). They also require a flag of Y or N to tell if the item has a Forecast setup or not.
Regards
Jagadish