cancel
Showing results forĀ 
ShowĀ Ā onlyĀ  | Search instead forĀ 
Did you mean:Ā 

Purchase Quantity not accepting decimal values

ImIronMan
By Level 6 Flexeran
Level 6 Flexeran

Hi All,

We see there is a requirement from a customer that to import purchase orders with purchase quantity in decimal values like 116.264884 or 4399.2 etc, in few cases, these are just costs/values in some cases these are actually valid quantities.

But FNMS not accepting decimal values in the purchase quantity field, is there any way to change this property? Changing this property also need a change in other dependent quantity fields as well like effective quantity or entitlements, etc., in different pages/reports

Thanks in advance

(1) Solution
mfranz
By Level 17 Champion
Level 17 Champion

Hi,

The underlying database tables define these as integer (not floating point), therefore not accepting FP data.

2021-09-15_17h01_48.png

While these could theoretically be changed, it would be an endless story of changing related tables, views, procedures etc. to work with floating point values. I don't think this will be happening anytime soon.

Best regards,

Markward

View solution in original post

(1) Reply
mfranz
By Level 17 Champion
Level 17 Champion

Hi,

The underlying database tables define these as integer (not floating point), therefore not accepting FP data.

2021-09-15_17h01_48.png

While these could theoretically be changed, it would be an endless story of changing related tables, views, procedures etc. to work with floating point values. I don't think this will be happening anytime soon.

Best regards,

Markward