I wanted to make a buyer wise inventory report as per the purchase group assigned to each and every material.
The inventory should be classified as per category and this ABC classification should be from the material master, Inventory planned should be from the open schedule raised. Short and excess will be the difference between the stocking norm as per ABC and actual stock in hand. The stocking norm is 7 days inventory for A cat, 10, days for B cat and 15 days for C cat items.
Please suggest how I should go ahead.