Currency has wrong no. of digits after decimal

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
ppinto
User
Posts: 138

Currency has wrong no. of digits after decimal

Post by ppinto »

Hi,

Currency is showing 4 digits after decimal, when 2 are set both in the 'Format/Nº. of digits after decimal' field setting and in the json locale file.
It shows OK (2 digits as set) in list and view pages, but if I edit the record it adds two zeros, totaling four digits after the decimal character.
In my json file:
"thousands_sep": " ",
"mon_decimal_point": ",",

Pedro


ppinto
User
Posts: 138

Post by ppinto »

UPDATE: The error occurs in MS SQL, for data type 'money'.
Changing the field to numeric(18,2) corrects the issue.

Cheers.


Post Reply