Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Amount field with currency

Posted on by Microsoft Employee

Hello,

I want to add a new amount field to a workflow.

I want to do it as this example:

pastedimage1573475120137v1.png

This is my new field:

pastedimage1573475178774v2.png

New field's properties:

pastedimage1573478904964v1.png

Could you please give me some hints to achieve this?

Thank you in advance.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Amount field with currency

    Hello,

    I solved it.

    I did not have the properties set correctly on the new field and I did not have the relation with Currency table.

    Properties are following:

    Relation Context - Table relation name

    Currency Code Table - Related table name (Currency)

    Currency Code Field - Related field name (CurrencyCode)

    Currency Code - The field on which the relation is based.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Amount field with currency

    Hi Ludwig,

    I am making a sum of Purchase agreement lines net amounts, I can not tell you in what process they need it as I am not functional.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Amount field with currency

    Thank you for suggestions Martin, I will investigate this further and write here if I manage to solve it.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Amount field with currency

    Hi sharabarati,

    Why you need this new field?

    In the name your write if the amount is under 75000 CHF, which can be configured with the available fields and functionalities.

    Can you explain what you try to achieve and what cannot be handled in the standard application?

    Best regards,

    Ludwig

  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: Amount field with currency

    Hmm, wrong guess then...

    What if you use default values of Relation Context and Currency* properties?

    Also, you can try to debug ExpressionCurrencyDefaultProvider.isCurrencyEnabled().

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Amount field with currency

    Thank you for your reply.

    I have tried it, it does not work. Could it be that I am missing a model as reference and the project build is not popping an error? I do have reference on Currency model.

  • Suggested answer
    Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    RE: Amount field with currency

    AmountMST is always it the company currency, therefore there is no reason for currency selector.

    Try Amount EDT instead.

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

Product updates

Dynamics 365 release plans