Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 16, 2015 at 11:11 PM


    Please refer this thread Decimals in query on General Settings | SCN


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Frank Wang

      Understood, thank you Frank!

      When you say increase price decimal you are referring to under the General Settings, correct? I got it to work with setting the Amount Decimal to 4 in our test DB, but it hits all the sales forms with 4 decimals and we cannot revert back to 2 decimals so it was decided that we do not want to that. 

  • Oct 16, 2015 at 09:16 PM

    Administration->System Initialization->General Settings->Display tab.

    Check Decimal place for Price. I believe u set it to 2. that's the reason.


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Did make this change in our test DB since you cannot revert back to less decimals on the price level... It still gave out same output... Do you think it has to do with it being a Service invoice and fields being UDFs.

      Add-on edit: After looking at the UDFs i did notice it used Amount and under General settings there was an Amount which I changed to 4 and it works... What does Amount affect if i do this in our Production DB? If i do change it i cannot revert back...