Skip to Content
0
Former Member
Apr 21, 2009 at 05:23 AM

Quantity automatically rounds off to two decimals..

149 Views

Hi experts,

I have inventory UoM of boxes. When goods are returned, i receive them back in pieces (I cannot have the UoM in pieces). I created a UDF in the item master (data type: Quantity) and have set the decimal places in General settings as 4 decimals.

In the AR credit memo, I have created a UDF to capture the quantity in Pieces (Data type: Quantity). Also, I have assigned a FMS in the quantity field (which would be computed as Pieces returned/ No of pieces per Box). When I run the FMS, it rounds off to 0.125 to 0.13. However, when I manually key in 0.125 in qunatity field, the value is accepted.

Please advise as to how I can prevent this automatic rounding off in FMS. This is my FMS

SELECT CASE $[RIN1.U_OtherUOM]

WHEN 'Boxes' THEN (SELECT $[RIN1.U_QtyUOM] / T0.U_Boxes)

WHEN 'Pcs' THEN (SELECT $[RIN1.U_QtyUOM] / T0.U_Pcs)

When 'Kgs' then (SELECT $[RIN1.U_QtyUOM] / T0.U_Kgs)

ELSE (SELECT $[$38.11.N,6])

END

FROM OITM T0

WHERE T0.ItemCode=$[$38.1.0]

FOR BROWSE

Thanks,