Hi ,
We have a requirement from one of our clients to split the Change in Inventory posting based on profit centers (PC).
As you know the FI posting at the time of backflush is
Dr Inventory-FG 300 PC based on Material master-1205
Cr Change in invet 300 PC based on Material master- 1205
Dr Raw mat consump 100 PC based on Material master- 1201
Cr Raw mat Invent 100 PC based on Material master- 1201
(The difference between the consumption values & Change in inventory value is the labor & OH component )
Suppose the Labor Cost is 200 & has assignment to a cost center(based on work center) which belongs to different Profit center(1207) other than that of material, then we would want the Change in inventory to be broken down between two lines.
Dr Inventory-FG 300 PC based on Material master-1205
*Cr Change in invent 100 PC based on Material master- 1205 *
*Cr Change in invent 200 PC based on Work center -1207 *
Dr Raw mat consump 100 PC based on Material master- 1201
Cr Raw mat Invent 100 PC based on Material master- 1201
If anybody could guide me how this can be accomplished, that would be of great help
Appreciate your help.
Thanks
Harish