Hi,
I have a reporting requirement where I need to provide user with flexibility to report on 2 different levels. For example there is a material with 12 packs. The actual unit of measurement is 24packs for a case.So 12 packs form 1/2 case. If there are materials belonging to 12 packs the user should be able to report it as 12 packs as well as 24 packs. So if we have to report it as 24 packs, the quantity has to go against the 24 pack material. Pls see example below.
Material Qty
1224 - 12 Pack Orange Juice 49
1294 - 24 Pack Orange Juice 60
In report the user should be able to see it as
Material Qty
1224 - 12 Pack Orange Juice 50
1294 - 24 Pack Orange Juice 60
as well as
Material Qty
1294 - 24 Pack Orange Juice 85 (60 + 25 from 12 pack)
How do I achieve this? Any ideas?
Thanks
Suja