Definition of ADR for WIP Valuation based on Product Category

Hi,

We are using same raw material (ingredient) for producing multiple products either in a single production batch or in different batches.

e.g.
 
Ingredient  is ' A'
Products are 'B' & 'C'

The item category of 'A' is "Raw Material" and that of 'B' and 'C' is "FG-B" and "FG-C".  The WIP Valuation accounts are defined for each product category (Item Category) separately, i.e. "WIP - FGB" and "WIP - FGC"

The requirement is:

                    if we are using ingredient 'A' for producing the Product 'B', the account "WIP - FGB" should hit; if producing the product 'C', the account "WIP - FGC" should hit.