Cheque report Amount cur field (Comma separator)

(0) Share

Report

Posted on by karan sambher

550

In cash and bank management, I am trying to develop a check report for an Indian client for which I have made some modifications in Cheque_Uk report which is present in the base system. Everything is working fine except the Amout Cur (Numeric ) field which is being printed on the check. Th comma seperator which is displayed is based on millions/billions system .

However indian client requirement is that the comma should come in thousands format.

For eg (12,234) however its coming like(223,342)

I have tried all the approaches from changing regional settings of the system to the formatting that particular field through SSRS design.

Still no changes are refelected on that numeric Amount field.

Kindly suggest how can that be achieved in AX 2012 R3, Is it even possible or not ??

Thanks in advance!!

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Bashir Ahmad 5,248 on at

Like (0)

Report

You may use these expressions for the value:

=replace(Format(12345.3456, "## ### ##0.###") ,".",",")

=replace(Format(3455.34, "## ### ##0.###") ,".",",")

=replace(Format(654677, "## ### ##0.###") ,".",",")

=replace(Format(145.4565727,"## ### ##0.######"),".",",")

also:

community.dynamics.com/.../84011

Was this reply helpful? Yes No
Bashir Ahmad 5,248 on at

Like (0)

Report

The issue is in AX2012 R2. Financial statement generated in Excel shows incorrect values- wrong Decimal separator, Thousands separator missing and wrong number of Decimals, when:

- Decimal separator- set to Comma

- Thousands separator- set to Point

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

I think you would have bright chances of getting a more valid answer here, because ax don't knows what SSRS doing with format, after throwing data.

Job of ax is finished after data is thrown

Was this reply helpful? Yes No
karan sambher 550 on at

Like (0)

Report

Dear Bashir Ahmad,

Kindly specify where and how do i have to use this expression in Visual Studio ??

Was this reply helpful? Yes No
karan sambher 550 on at

Like (0)

Report

thanks Sohaib.

Was this reply helpful? Yes No
Verified answer

Manmohan Mehta 1,185 on at

Like (2)

Report
Hi Karan,

Follow the steps to resolve the issue:

Go to text box property and change the text box format to "C0" (c and zero)

Go to report Property and change the reporting language. In your case its "en-in"

Now Go to text box property , Numbers -->select currency and select below settings:

Now go to textbox expression and write the following expression :

=format(field.value,"C0")

eg. =format(Parameters!Parameter1.Value,"C0")

Hope It helps !!

Was this reply helpful? Yes No
Manmohan Mehta 1,185 on at

Like (0)

Report

Thanks Karan, also here C0 is used for zero precision where as you can use C1, C2 etc for different precision values.

Was this reply helpful? Yes No
karan sambher 550 on at

Like (0)

Report

Dear Manmohan,

Thanks for this post, its doing wonders. I was struck with this issue from past few days now it stands resolved :)

Was this reply helpful? Yes No