Does any one know the effect of increasing the bytes returned from a decimal field in SQL?
For instance I want to increase the unit price decimal place from 5 to 10, the field is set to decimal(17, 5). If I set it to decimal(17, 10) will there be any affect to the UI in epicor 10?
I did not see a way through Epicor UI, I did try to increase the decimal places from the company configuration however it only supported 5 places
What field are you trying to increase? There are a couple ways to increase a decimal place in Epicor.
I have not tried to increase anything yet, I am looking at orders and parts. We are currently re-structuring our cost per product and we ran some initial pricing algorithms that placed some products, when ordered in the millions, to be less than 0.0001
We are trying to figure out how to increase the decimals from 2 to 4 or 5 for a surcharge Misc Line Charge percentage. What are the couple of ways you mentioned Eric?