Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Report Writer - Print ...
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by Peter Muchira 1,910

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

  • Suggested answer
    Naga Kiran Profile Picture
    Naga Kiran on at
    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 Profile Picture
    Tristan Clores 2,812 on at
    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 Profile Picture
    Peter Muchira 1,910 on at
    RE: Report Writer - Print Amounts in the Originating Currency and Round Decimals

    Ideas ?

  • Peter Muchira Profile Picture
    Peter Muchira 1,910 on at
    RE: Report Writer - Print Amounts in the Originating Currency and Round Decimals

    Any new ideas , out there on this item ?

  • Peter Muchira Profile Picture
    Peter Muchira 1,910 on at
    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 Profile Picture
    soma 24,406 on at
    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 Profile Picture
    Tristan Clores 2,812 on at
    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.

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.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans