Does anyone know where the default decimal/roundin...
# general
c
Does anyone know where the default decimal/rounding setting can be altered? Our POs are not calculating based on the discount factor rate that our vendor uses because the vendor uses a rate which is sometimes in the third decimal place. For example: one of our vendors uses a rate 0.203, which rounds down to .20. for an item list price which is at 343.00. This causes an item which should should populate in our system at 69.63 to populate as 68.60.
b
probably not the route you want to be following
c
@battk why not? I just need be able to get the third decimal place to count.
b
read the help topic
k
I'd probably just have the user key over the difference when it's wrong because of this.
or add it as an extra line on the order as an expense.
c
The currency decimal precision is still 2 for USD even if the feature is disabled on my account I assume?
b
if you don't have multiple currency, you should be able to find your currency precision where you configure company information
Same restrictions. Its a pain to change and your only choices are 0 or 2
j
Would not recommend changing precision for this. Agree with Kevin's approach.
b
keep in mind that currency precision affects the amount
you can still set the rate to more digits,
c
So, a better route would be to create custcol_expense field, then set the rate field equal to custcol_expense + the value passed in from our vendor's order acknowledgement?
Or have the user manually enter in the number in the custcol_expense field & set the amount equal to (+/-) the rate field + the custcol_expense field?
b
if you trust your vendor's math, set the rate equal to the list price multiplied by the discount factor
if not, set the amount to match
safest is probably do both, weird things happen when amount does not equal quantity times rate