Forum GLPI-Project

ldakvn1

Member

Registered: 2008-09-19

Posts: 11

Contract Cost

Hi Everyone,

I tried to add Contract, and off course input their cost as well.

However, if I put high number such as 2.780.231 $, then it will show 2.7803E+6 (something like that).

How can I force it shows 2780231 exactly.

Thanks,

JMD

GLPI - Lead

Registered: 2004-09-13

Posts: 9,180

Website

Re: Contract Cost

Use this Mysql comand :

ALTER TABLE `glpi_contracts` CHANGE `cost` `cost` DECIMAL( 20, 4 ) NOT NULL DEFAULT '0.0000'

The next version of GLPI would include this patch

---

JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir

ldakvn1

Member

Registered: 2008-09-19

Posts: 11

Re: Contract Cost

Thanks, I followed up with your instruction.

Now it seems to be correct except it show 4 digit .0000 after every cost.

Please help

ldakvn1

Member

Registered: 2008-09-19

Posts: 11

Re: Contract Cost

I fixed it myself by changing in mySQL database.

Thanks

JMD

GLPI - Lead

Registered: 2004-09-13

Posts: 9,180

Website

Re: Contract Cost

I close

---

JMD / Jean-Mathieu Doléans - Glpi-project.org - Association Indepnet
Apportez votre pierre au  projet GLPI   : Soutenir