BOM rounding quantities
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?
Thank for all answer !
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
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