Exchange rate not print properly. Strange issue, how to fix it...

(0) Share

Report

Posted on by P NOUSHAD

1,821

Hi,

I am using GP 2013 SP2 with functional currency AED , other currency USD with exchange rate 3.675. I found a strange issue in printing exchange rate on sale invoice report. Sales invoice report has been customized to print exchange rate with 3 decimal places. but it print 3.675 with sa user. but other users, it print 3 only as shown in below screen, sometime when user logout and login it print 3.675. Kindly help me to find a solution to fix this strange issue.

Please find screen-shot for more details.

Customization details on sale invoice report.

8877.e1.png

I tried to change result type from currency to variable currency but the same result.

4503.e2.png

*This post is locked for comments

All responses (3)

Answers (0)

Justin Thorp 2,265 on at

Like (0)

Report

RE: Exchange rate not print properly. Strange issue, how to fix it...

Hi P NOUSHAD,

In this case, also create or use an existing "Format" that is left aligned. The "Format Field" decimal digits appears to over-ride the decimal digits on the assigned "Format". (I hope that makes sense).

Justin
P NOUSHAD 1,821 on at

Like (0)

Report

RE: Exchange rate not print properly. Strange issue, how to fix it...

Hi Justin,

Thanks for support with detailed steps. It working now but only the issue, user need alignment to wards left. Please check the exchange rate on report can we do left alignment. so all formation will in left alignment.
Suggested answer

Justin Thorp 2,265 on at

Like (0)

Report

RE: Exchange rate not print properly. Strange issue, how to fix it...

Hi P NOUSHAD,

I recommend making use of a "Format Field" instead of assigning a "Format".

You will need to make 2 calculated fields:

1.)
Name: (C)ExchangeFormat
Result Type: Integer
Expression Type: Conditional

Conditional Expression: SOP_HDR_WORK.Currency ID = "AED"
True Case: 1
False Case: 4

2.)
Name: (C)ExchangeRate
Result Type: Currency
Expression Type: Conditional

Conditional Expression: SOP_HDR_WORK.Currency ID = "AED"
True Case: 1.00000
False Case: SOP_HDR_WORK.Exchange Rate

====================================================================

Put the (C)ExchangeRate field onto the layout, doubleclick on it, then select (C)ExchangeFormat as the Format Field. (Also, make sure to leave "Format" blank/empty). Screenshots below:

Please let me know if this works for you.

Best Regards,

Justin