Announcements
No record found.
I am trying to get two decimal places.
I thought this would work but it doesn't:
*This post is locked for comments
Hi,
"Data Format" is used to identify the source value only.
It doesn't have an impact in the target value which is used in NAV.
The field (which the value is imported to) can control the decimal places.Go into the Properties of the field, the property is called "DecimalPlaces".
I'm using a mapping definition, and it is defined like this:
It still ouputs "1008" when the amount is 100.80
"Data Format" is used for Date-values only.For Decimal-values, the column "Data Formatting Culture" is used.
But, this will not help you to interpret "1008" as "100.80".You can create a Mapping-Codeunit to solve the problem.
It's the other way around, I am exporting the decimal value to a CSV file.
The value I am getting now in the CSV is "1008", but I want "100.80". The culture is set to "en-us"
hello,
you have to post more information how you generate the CSV.
I am using the Data Exchange Framework (comes basic with NAV2018).
I debuggued the code and I really see the line where it uses the FORMAT function based on the format string I provided.
It works fine for my dates with "<Year4,><Month,2><Day,2>", but I can't make the decimals work for some reason.
To make another test, I put the format to "#.00", but it then exported literally to "#00". Looks like something really doesn't like the dot.
I found the problem, somwhere in the export framework it forcefully removed dots from decimal values... so I removed that and now everything works fine.
Hey SamCha,
I am actually trying to remove the dot from decimal value. I would appreciate if you can share where did you find the configuration that removes dots.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
