Report Writer - Print Amounts in the Originating Currency and Round Decimals

(0) Share

Report

Posted on by Peter Muchira

1,912

Hi there,

I want to print a Purchase order with the originating currency amounts, respective currency symbols and my preferred decimal places.

My challenge:

When I choose 'Format Field', and pick any 'Currency-Index' format, the currency and amounts show correctly. However, the decimal places cannot be modified, say from 4 to 2. Even when I set the places to 2, the amounts still show the default 4.

Any LPO in the functional currency is ok, for the amount, currency symbol and decimal places.

Any one who has encountered this, or has ideas to share is welcome.

*This post is locked for comments

All responses (7)

Answers (0)

Suggested answer

Naga Kiran on at

Like (0)

Report

RE: Report Writer - Print Amounts in the Originating Currency and Round Decimals

Hi Peter,

Tristan's suggestion would answer your question. I found one more report writer function under 'Inventory' series in Dynamics GP that you can use just by sending the currency value and number of decimal places.

Rounded Currency Value = rw_RoundAmountForBM( Currency Value, Decimal Places)

Note : If you want 2 decimal places pass 3 to the Decimal Places parameter of this function.

Hope this helps.
Suggested answer

Tristan Clores 2,812 on at

Like (0)

Report

RE: Report Writer - Print Amounts in the Originating Currency and Round Decimals

Hi Peter,

You can use the KB Article below:

support.microsoft.com/.../872275
Peter Muchira 1,912 on at

Like (0)

Report

RE: Report Writer - Print Amounts in the Originating Currency and Round Decimals

Ideas ?
Peter Muchira 1,912 on at

Like (0)

Report

RE: Report Writer - Print Amounts in the Originating Currency and Round Decimals

Any new ideas , out there on this item ?
Peter Muchira 1,912 on at

Like (0)

Report

RE: Report Writer - Print Amounts in the Originating Currency and Round Decimals

Hi Soma,

Thanks for your response. I have worked with the format property, but it does not address my need. My requirement is to round decimal places, on an FCY amount. Format property works property works perfectly on the Functional currency.

My Foreign Currency has 4 decimals in the setup, but in the report, I want it display 2 decimal places.
soma 24,410 on at

Like (0)

Report

RE: Report Writer - Print Amounts in the Originating Currency and Round Decimals

The 'Format Field' is used to set the currency values and amount. You can use 'Format' property to change the currency decimal places for the particular currency field.

Hope this helps!!!
Tristan Clores 2,812 on at

Like (0)

Report

RE: Report Writer - Print Amounts in the Originating Currency and Round Decimals

Hi,

You will need to use calculated fields to get this done.

You can convert the currency field (ie: cyExtCost - Extended Cost) to string using the CUR_STR system defined function.

Once done, you will then need to use either the RW_Right or RW_Left user-defined function to make sure that it does not print the last 3 digits of the field.

You will need to play around this for quite some time to get it right - but this is doable.

Let me know if you have further questions.