Skip to Content
0
Former Member
Feb 24, 2009 at 06:04 PM

Conversion from 1/2 Case to full case

20 Views

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