40
Hello,
I am trying to change a field in Data Exchange Definition to mandatory 2 decimal places. Under Data Format in Column Definitions, I changed the data type to Decimal, the data Format Culture as en-US and inputted the following in Data Format:
Not sure why the above formats is not working.
If the amount if $100, I want to show 100.00 in the EFT(ACH) file.
Thanks,
Rosen
What multiplier field?
Hello
I'm using <Precision,2:2><Standard Format,0> and en-US in my data def - and I'm not getting a decimal?
This did not help me :-(
I need help with this also. I also need to change the payment journal amount from no decimals to show decimals - any suggestions would help. There is nothing for documentation on this.
My old friend Sai once again saving me. I spent about 2 hours trying to sort this out came across this post and sure enough it fixed my issue.
Hi there,
On the 'Field Mapping' window, for the Payment line, enter "100" at "Multiplier" field. This will solve the issue.
I had to break my head during this setup!
When you use the AutoFormatType and AutoFormatExpr properties to format a field, a trigger called AutoFormatTranslate in codeunit 1 is called. AutoFormatTranslate has ID 12 and takes two parameters: one from the AutoFormatType property and one from the AutoFormatExpr property. The AutoFormatType property can contain one of the following integers: 0, 1, 2, 10, or 11. These settings are described in the next section.
When a field appears on a page or report, you can set the AutoFormatType and AutoFormatExpr properties directly on the page field or report field (column), or you can set them on the underlying table field. If you specify the properties on the table field, then format applies wherever the field is used. Specifying the properties on the page or report field will only apply the format on the specific page or report. If you specify the properties on the table field and the page or report field, then the settings on the page or report field take precedence.
You can see an example implementation of the AutoFormatType logic in the CRONUS International Ltd. demonstration database. In the CRONUS International Ltd. demonstration database, the AutoFormatTranslate trigger calls codeunit 45 AutoFormatManagement which handles the formatting.
Admin
Hello, did you finally solve the problem? I'm in the exact same situation
Hi Rosen,
As per my understanding, the data comes with a DOT already.
Also you don't need to create any transformation rules.
Just check your data format in Data Exchange Definition probably you are missing something as I was getting with the DOT.
Let me know if you need further help.
Thanks for your Response Olister. I see on the blog that you created a transformation rule for REPLACEDOT and I used the Replace transformation type but not sure how to make it dynamic so that all values will be converted.
Yes, I would appreciate your help.
#1
YUN ZHU
628
Super User 2025 Season 1
#2
Mansi Soni
495
#3
Sagar Dangar, MCP
395
Share
Report
All responses (
Answers (
