A/P Service Invoice User Defined Value Setup Query?
Scenario/Issue example: A/P Service Invoice
Accounting person adds (Price = .2525) and (Qty = 3) correct output should be $.76 but the Query gives $.75 output.
--A/P Service Invoice User Defined Value-Setup Query for "Total (LC)" based on the Price * Quantity--
Select $[pch1.u_svcqty.number] * $[pch1.u_svcprice.number]
See image for example...
It did Calculate correct in B1 8.8 using SQL 2005.
We upgraded to B1 9.1 and using SQL 2012 and now it is not working.
Is there an easy edit to the Query or is this a setting in B1?
Did try a few different queries, including rounding...
It is not picking up the .2525 I entered on the B1 “Price” column, what it seems like is B1 converts/rounds it before it reaches the query to calculate on "Total (LC)".
Any help or advice would be appreciated.
Frank Wang replied
u r right, there is no workaround. If it was working under 8.8, then I would say SAP changed the sequence of the operations, in 8.8, they sent data to FMS before data format validation on the price, and in 9.1, they sent data to FMS after data format validation on price.
Increase a price decimal is not that hard, I would suggest add the decimal length in your case.