Dear Gurus,
In my stock:
Material Batch Qty
DS050 0000114312 734.585
DS050 0000114315 300.000
DS050 0000114316 100.000
DS050 0000114317 200.000
DS050 0000114318 50.000
I made one report for issue qty form excel data sheet.
Material Qty
DS050 1000.000
DS050 150.000
My requirements is:
the data will issue by batch wise automatically.
it means it will take first batch number where the qty is 734.585
Then rest of qty(1000 - 734.585) = 265.415 will take from 2nd batch.
if any balance it will take from 3rd batch.
Please help me if anybody has this idea.
Thanks and b/R
Bishnu
19/04