Calculation for volume on sales order VBAP-VOLUM

[Former Member]

Our materials have a base unit of measure and an alternate unit of measure. We want to be able to enter the alternate unit of measure on the order as the sales unit, but have the volume calculated on the base unit of measure.

For example:

Base UOM is Case with a volume of 40 CFT

Sales UOM is Eaach with a volume of 9 CFT

One Case equals 4 Eaches

If a customer orders 1 Case the volume is 40 CFT. If a customer orders 4 Eaches (which really is 1 Case), the volume is 36 CFT. We need the volume calculation for the Eaches to equal 40 CFT in this example.

We cannot change the volume of the alternate unit of measure in the material master to be 10 CFT per Each so we need to figure out a way to automatically change that value on the sales order.

Is anyone aware of a way to have the order volume get calculated using the base UOM instead of the sales UOM?

Thanks

Diana

[Former Member]

Hello Diana

There is a fallacy if you say that I case = 4 Eaches, but the volume of a case is different from 4 eaches. I am also assuming that if the customer orders 3 eaches, you want to compute the volume as 27 CFT. What will happen if customer orders 6 eaches? Will it be 60 CFT or 58 CFT or 54 CFT? I am guessing 58.

I totally understand that you may have business reasons for it.

If you can't have the Alternate UOM to specify 1 Each is equal to 10 CFT, that makes it even more difficult.

There are broadly 3 options for you:

1) Maintain 2 separate material numbers for Cases and Eaches. I hate this but this is a clean option.

2) Maintain Each as Base Unit of measure and Case as alternate unit. Whenever a customer orders case, then add a sub item ( say Packaging material) with a volume of 4 CFT.

2) If you want to have just one material and case as the Base Unit, you will be haunted by Z code for life. You need to keep on replacing the item volume in orders, deliveries and Invoices ( VBAP/LIPS/VBRP) with this logic I will mention below. This essentially consists of 2 broad steps:

a) In the material master, let the volume be 40 CFT as it always refers to the Base Unit.. But in field 'Size/dimensions' (physical dimensions) maintain the information as follows: 4X3X3X1 or even 4X9. Here 4 signifies the number of eaches in a case. Understood the field 'Size/dimensions' is for information purpose only but you will use it for calculations. Actually you will use part of it, the part after' X'. I know this will be an ABAPer's nightmare.

b) Whenever Sales Unit is not base Unit, check if Sales unit is a whole multiple of the Base Unit and if so replace the item volume with the equivalent base unit volume. So if customer orders 8 eaches, then the volume will be fetched from 2 cases,i.e., 80 CFT. If the if Sales unit is not a whole multiple of the Base Unit , then replace the whole numbers with equivalent base unit volume and the balance eaches with the volume from the 'Size/dimensions' field. In this case if the customer orders 6 eaches, it is equivalent to 1 full case and 2 eaches, so it will be 40+ 2x9 = 58.

Complicated? Sure.

Let me know if it helped you in any way.