Import is not working for currency field in suitecrm

SuiteCRM Forum - English Language
#1

I Tried to import the currency field in suitecrm in european format but it is not saving the correct value .

If I am importing 14,00 from file then it is saving 1400.00000 in database.

Please help in this issue. How this issue can be resolved

#2

@bismaidhara

Welcome to the community!

You should use correct decimal separator for current user. Look at parameters for the user.

#3

Problem is not with the separator . whenever i import 14,00 . it replaces the comma with zero and extra zero get added while import and value becomes 1400.00 .Please find the below screen shot for the reference

date format
date format1013×341 17.6 KB

Please suggest if anywhere I am going wrong.