Quantity automatically rounds off to two decimals..
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])
FROM OITM T0