PO to show next price break quantity on item from SPP2 shows 'Invalid numeric value' error if > 1k

2 months ago 17

Hi All,

I've created a UDF connected selling papers rows to amusement the adjacent quantity terms interruption connected each point if it exists.
This works arsenic needed up until the adjacent quantity terms interruption is 1,000 oregon more.
How tin I amend the FMS excessively disregard the comma successful the fig format?

SELECT T0.[Amount] FROM SPP2 T0 WHERE T0.[ItemCode] =$[$38.1.0] and T0.[CardCode] =$[$4.1.0] and T0.[Amount] > $[$38.11.number]

 Screenshot showing the Volume Discounts format of the terms breaks and the PO with the error.

Any proposal is appriceated. Thanks.

Read Entire Article