Search
Search

# 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?

##### Former Memberreplied

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,

1 View this answer in context
View more on this topic or