Decimal values in amounts in quotes

[bslindhardt]

Hello,

I started using Sugar Professional a few weeks ago and I'm currently seting up functionalities.

My problem is that I need to specify decimal values when stating amounts of a given product in a quote. We are selling service hours and we sell - for instance - 1,5 hours of service. When I type "1.5" or "1,5" I get an error and the value is corrected to either "1" og "15".

Can anyone help? Thanks.

[sts]

Please check the type of the field in admin->developer tools->Studio.

[bslindhardt]

Thanks for your reply.

You are right; the type of the field (product/ amount) does not allow decimal values. But how do I change that? It seems that I am not able to change the data type as this is a standard field.

Do I need to create a new field that allow decimal values and replace the standard field?

[sts]

It is not possible with Studio to change the type of an existing field. But it is possible to do this in files and without changing the standard code.
If you look into the developer guide, chapter 4 "Customizing Sugar", you'll find a description for "Vardefs". There is a nice example for changes by creating a file in /custom/Extension/modules/<MODULE_NAME>/Ext/Vardefs/ directory.
In your case it should be enough to create such a file with the entry
$dictionary['<MODULE_NAME>']['fields']['<FIELD_NAME>']['type'] = <NEW_TYPE>;
where you have to set the values of the module name, field name and new type off course. After a quick repair (changes the database entry) the field should have the new type.

[Please save your installation before ... create a zip of the sugar directory and a dump of the database!]