Hi, I would like to know if the following can be achieved with Master Planning or must this be a customization in a form of a report or process.
This is the requirement from the client, The "report" should calculate 3 months stock and average it as a usage figure for the month. Then the required quantity should be as follows: Average multiplied by 3 Less Quantity on Purchase Order & Back Order. The "report" was to automatically generate updated figures after compiling a three month history. For the first three months, the report was to draw details from the Maximum Stock holding fields and thereafter it was to auto generate as per the history. The client has master planning already configured for min\max qty's. Looking forward to your response. Thanking you in advance Regards, Anisha