how to convert Quantity filed on cost_plan table to Decimal

[SNOWSBC24]

[Rafael Batistot]

Hi @SNOWSBC24 

Change the Field Type

The most direct solution is to change the Quantity field's data type from Integer to Decimal. This will allow it to accept decimal values directly.

1. Navigate to System Definition > Tables.

2. Find and open the Cost Plan table (cost_plan).

3. Go to the Columns related list and find the Quantity field.

4. Open the record for the Quantity field.

5. Change the Type from Integer to Decimal.

6. Click Update.