We stock inventory out 4 decimal places, 1.0000.
I see that the database holds values properly, such as 1.5683 while in the form it displays as 1.57 on hand. When trying to move or adjust out, our users receive an error that 1.57 cannot be moved because only 1.57 are available. Obviously, this kind of error is difficult for them to discern.
If however they type in 1.5683 it will adjust or move perfectly. We have found that certain fields have a property called NoOfDecimals. If we put this out to 4, instead of Auto, it will display values correctly to our users and let them perform their required operations successfully.
We are curious what setting this ‘Auto’ pulls from, as it does not seem to automatically determine the length of precision for any particular value.
Thanks as always daxers!