We are Facing Problem in Consumption of Mateial and Excise setoff as mention in the following scenario.
Suppose you have opening stock of RM as 100,and your purchases of 1000 qty of a particular material,
Now your actual consumption is of 700 qty in production process.
But my Client is showing it as consumption of 1000 qty instead of 700 qty in their legacy system.
(Excise as well as book entry).
And after that whatever they have not used actually i.e 300 qty they bring it back in WIP Acct.
i.e WIP A/C Dr
Profit & Loss A/C Cr.
That means for Excise Purpose they take a setoff on Purchases.
We are in dilema how to Map this scenario in SAP ,Please Guide us.
Points will be duly awarded for all the Good answers.