Former Member

### BOM rounding quantities

Hi Gurus,

At first, sorry for my English, it isn't my first language, I will improve!

I got a problem with quantities rounding off in BOM

The BOM I created is 1 TON of Product "A" consuming 1 unit of bag

In order to produce 1,1 TON or above, until 2 TON, of product "A" the SAP will always to suggest to use 2 units of bags.

I would like that the system suggest 1 unit of bag when it's producing until 1,4 TON, above this quantities, suggest 2 units of bags.

Is that possible without exits, just using customizing?

10|10000 characters needed characters exceeded

Former Member
Oct 30, 2015 at 11:46 AM

My colleague suggests an another solution and it's worked.

In Master Recipe we use the Material Quantity Calculation and put a formula in the material we desire to rounding off.

The formula is:

IF (Finish Product Quantities - TRUNC (Finish Product Quantities) < 0.5) THEN TRUNC (Finish Product Quantities) ELSE (Finish Product Quantities)

The function TRUNC keep an integral number .

Example: TRUNC (1.8) = 1

TRUNC (2.145) = 2

Therefore:

1. Producing 30.4 TON of Finish Product

IF (30.4 - 30 < 0.5) THEN 30 ELSE 30.4

Result: 30 unit

2. Producing  30.6 TON of Finish Product

IF (30.6 - 30 < 0.5) THEN 30 ELSE 30.6 ----> this last quantity, the SAP will behave normally, rounding up, therefore the system suggestion is 31 unit.

Result: 31 unit

Regards,

10|10000 characters needed characters exceeded
• Oct 29, 2015 at 04:39 PM

Hello

On the standard system, component quantities are always rounded up, in order to avoid material shortages.

Rounding down in case of very small quantities (0,1), means that the quantity could be rounded to zero and that would lead to a component with zero quantity, which is not desired.

Regards
Caetano

10|10000 characters needed characters exceeded
• Former Member Caetano Almeida

Hi Caetano,

I've created a new unit of measure with decimal but unfortunately the system didn't behave as I expected. It's still rounding up.

• Former Member
Oct 30, 2015 at 03:12 AM

Hi

I am also working for  industry where the BOM is for 1 MT but the final product is in pallet which is 1200KG or 1800KG. In this case best way is to define the BOM item qty in decimal like based on the calulation for 1200KG / 1800 KG with respect to 1000 KG.

Thanks

Kishan