I have a issue to get the consumption detail. Below the scenario .
I have company 1000 and 2000 and have different plant like 1001 for 1000 and 2001 for 2000.
Plant 1001 gives a job work to 2001 with raw material 1000 kg . Plant 2001 receive raw material and send 200 kg to other plant 2002 for same .
Now 2001(inclueded 2002 job material) return the job work material in number to 1001.
Now organization want that given raw material consumption detail from 2001 and 2002 plants for particular invoice because 2001 create a invoice to 1001 for return.
So they want to track all material which are in Invoice , give the consumed component with quantity.
I need your help in this regard.