Some users may experience issues accessing the case portal. For more information, please click here.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ImIronMan
Level 6 Flexeran
Level 6 Flexeran

Purchase Quantity not accepting decimal values

Jump to solution

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
Level 16 Champion
Level 16 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

Softline Group is Europe's leading independent expert in Software Asset Management.

View solution in original post

This thread has been automatically locked due to inactivity.

To continue the discussion, please start a new thread.

1 Reply
mfranz
Level 16 Champion
Level 16 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

Softline Group is Europe's leading independent expert in Software Asset Management.