Sales Order Valuation - Production order goods receipt

[former_member257735]

We have a MTO scenario where our Sales Order creates multiple production orders. For example, if Sales Order line item 100 is is for 5 EA for model ABC123, the system will always create 5 production orders - say Orders 1 through 5. The twist is that the BOM for all 5 orders can and will vary, consequently making the 101 E Goods Receipt value for each of them to be different.

Per standard SAP functionality, once the first Prod Order GR is complete, EBEW table for SO Line Item 100 gets stamped with that value. From that point onwards, every subsequent GR picks that value (and ignore the true cost of the production order). Which means, if Order 1 had a cost of $100, EBEW will be $100 and Orders 2-5 will also be $100 each, making the total GR inventory value to be $500 - whereas the true GR for all 5 orders should have been, let’s say, $750.

I've been struggling with how to drive the valuation of each Prod Order based on its own cost – meaning how do I update EBEW dynamically every time I do a new GR for that sales order line item. I was thinking of invoking either MR21 or some unit costing functionality – but wasn’t sure if EBEW record would be locked forever. Any hints or insights will be appreciated