Hello All,
We have a scenario, where we need to calculate Order fulfillment based on Item fulfillment.
Eg: I have sales order A10000 with Item 10, 20, 30 and 40.
Based on few conditions like initial delivery is equal to POD date, Initial Order Quantity is equal to POD quantity, No rejection reasons.
When all conditions are satisfied, we have Item fulfilled Key figure will be updated with a flag 0. If any one above conditions doesn't satify then the Item is not fulfilled.
When all Item are fulffiilled in a order, then order is comlpetely fulfilled (closed).
If any one item is not fulfilled then order is not fulfilled and updated with flag 1. Based on the item fulfillment , I need to calculate the each order fulfillment in Bex reporting level.
Please let me know the solution to overcome this situation.
Thank you in Advance .
Thanks,
Sai.Kari