Decimal issues in Delivery

[Former Member]

1. We have a material whose base UOM is M2

2. However, it is usually sold in ROLLs. The conversion on MM is say 1ROL=1000M2.

3. But physically in warehouse, the ROL could be either 1020 M2 or 990/994 etc. M2 depending on what we receive  from vendor

4. Since inventory is maintained in Base UOM M2- these will convert to 1.020 ROL and 0.990 ROL

5. The problem arises when- say a SO for this material is available with requirement 10 ROLs, in the delivery the batches will be determined as (in case 10 batches each of 0.990 ROL is available in stock) 10*0.9990 making cumulative 9.990 delivery quantity.  When automatic WM picking happens only 9.990 ROL is picked making the delivery partially picked and we will not be able to PGI

6. Another case is when 10 batches of 1.020 ROLS are available, if I choose only 1.000 from each batch in delivery, the WM will also pick 1.000. But in inventory we will have a residual of 0.20 ROL of that batch. This will not exist physically, obviously we don't cut the ROLs and sell.

We are looking at a solution to round of the inventory quantities when in ROLs. So when the receiving office enter a value of 1020 M2 into SAP this should show as only 1 ROL and not 1.020 ROL.

[Former Member]

Santosh,

I agree with Jurgen that the best way to combat this issue is to use batch specific UOMs. The beauty of this functionality is that you can represent the physical reality exactly as measured. So if you measure 1356 M, the inventory will be 1356.000 M, not 1356.001 M or 1355.999 M. Also, and most importantly for your issue, each roll will show up in inventory as exactly 1.000 rolls.

I hope this helps.

Dave

[Lakshmipathi]

Why dont you try with Overdelivery and Under Delivery tolerances ?

G. Lakshmipathi

[Former Member]

Hi,

The customer here do not want to pay for extra delivered or non delivered quantity.

[JL23]

A computer system can be pretty annoying in regard to the accuracy, isn't it?

Rounding of physical quantities does not happen in SAP. You can only round virtual quantities like order quantity.

If you want cheat your computer then you have to round with your protein computer and enter a rounded quantity directly, see case b below.

a) If each roll has a different length and hence square meters then you eventually need to use batch specific units of measure  and receive each roll with a separate batch number. You may be able to combine those who have the same size.

b) Or alternative, you do not receive in exact square meters, instead you receive it in rolls which is your alternative unit with a fix ratio to the square meters. So you always have the full roll and sell the full roll and your customer pays for the roll no matter whether it has 990 or 1020.

If you have to pay the exact size to your vendor, then you can still do it and SAP will adjust the moving average accordingly, so you have to expect some fluctuations in the price. In case of standard price evaluation such differences between invoiced and received quantity will go to the difference account.