Have this potency calculation issue,
Our final Product is : xxxxxxx 500 Capsules
As per BOM one of the require material has details as below. Consider below example
Material name Batch number quantity (kg) Assay
Xxxxx xxxxxx1 286.898 99.15%
Xxxxx xxxxxx2 90.000 99.37%
Actual required qty of xxxxx is 344.333 ( with potency 100% i.e. Assay)
Actual Require Qty = qty * 100 / Assay on Anhydrus basis
Now we have qty of xxxxx with Assay 99.15% and we want 100% potency Material to be used in final product….
So Formula will be
Now require qty is 344.333
Available qty 284.459
Shortage of QTY = 344.333 – 284.459 = 59.874
So this shortage of QTY will be calculated from batch number xxxxxx2
Now in Batch no. xxxxxx2 potency of Material is 99.37%
So it will be calculated …..
So total qty will be used from both batches will be
Need your help to Map this potency calculation in SAP,Looking forward for your rply.
Thnx in advance.