Some users may have issues creating a community account. For more information, please click here.

ImIronMan
Flexera
Flexera

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
Trusted advisor

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

1 Reply
mfranz
Trusted advisor

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