How to manage decimal / fractional return values in static LOV?
Hi,
I created a LOV for selecting the tax rate that should be applied to a sales invoice.
The LOV includes values 0 displayed as 0%, 0.1 displayed as 10%, and 0.15 displayed as 15%.
The problem is that if you select 15%, the rate 0.15 is saved in the respective TAX column and you can see the tax amount in the report, but the LOV keeps showing 0%, and if you click on SAVE one more time, the value saved is 0.
It doesn't matter what value the record has stored, the LOV always displays 0%.
If I change the order in the static LOV definition and put 15% first, then the LOV will always display 15%, no matter if the value stored is 0 or 0.10 or 0.15.
I guess this is a problem caused by the return values being between 0 and 1. Is that correct? How can I manage the LOV to display the correct stored value?
Thanks,
Francisco.