We have a situation where we cannot promise to the customers the availability of material on a right day. Sales order is showing incorrect available day, due to this there is a chance of losing customers.
The problem is explained below.
Finished products - A1, B1, C1 (Each has lead time 28 days) - this is packaged material.
semifinished product - D1 Lead time 3 days
Semifinished can go in any of the finished product. BOM is maintained fir finished goods and each has component D1.
So when the sales order is created, system is showing the availability after 28 days, which is correct and based on lead time.
When we have semi finished already in stock, but still in sales order availabilty showing as 28 days which is incorrect. It should show the availability is 3 days.
So whenever the sales order is created for finished product, it should check the semi finished availability, and if there is a stock available for finished product then system has to promise customers after 3 days or else it should promise after 28 days.
Please suggest me on the above business process. Your inputs are highly appreciated.