EXCISE+EXCESS CONSUMPTION +BY-PRODUCT
Hi all ,
I have got Raw material in KG , managed in batches each of certain kg weight.
when I procure i avail credit on the material & part 1 & 2 are updated .
when i consume this material against a production order , i may consume certain kgs of this material from one or more batches, partially or fully.
For certain reasons , I WANT TO BOOK THE COMPLETE BATCH AS CONSUMPTION IN EXCISE( even if consumed partially ) AND the balance actually existing physical (partial batch) material shold be available for subsequent use in inventory.
To achieve this i wanna proceed as under :
1.Procure 1000 kg material and update entries in part 1 excise register with 1000kgs.
2.In production order , use 700kg of material BUT BOOK CONSUMPTION OF 1000kgs .Excise registers show consumption of 1000kgs , hence balance qty is nil.
3.As i want to use the remaining 300kgs i create a BY PRODUCT ( a different material) in production order of qty 300kgs.
MY QUESTION IS :
As my raw material has a price control of "V" that is moving average , I want to maintain the byproduct with a moving average price .HOW CAN I DO IT ???
IF U CAN THINK OF ANY OTHER WAY OF TACKLING THIS PROBLEM , PLS DO REPLY ...
Edited by: anis bazmi on Oct 14, 2008 6:17 AM