Skip to main content

Notifications

Customer Service forum

Error on Mail Send: transactionCurrencyId needs to be supplied to format a transaction money field

Posted on by Microsoft Employee

Hi All,

We're seeing this error randomly while sending out emails via workflow "transactionCurrencyId needs to be supplied to format a transaction money field". We are not using transaction currency anywhere. Any ideas/thoughts.

Thank you in advance!

Categories:
  • Suggested answer
    Guibz Profile Picture
    Guibz 5 on at
    RE: Error on Mail Send: transactionCurrencyId needs to be supplied to format a transaction money field

    On-Premises here. Got same issue with InstantiateTemplateRequest with templates related to Incident with a customerId = an account created in V9. No problem with customerId = an account created in V8.

    Difference between accounts in V8 and V9 in database is the openRevenue field which is NULL in V8 and '0' in V9. Setting it to NULL resolves the issue.

    So for newly created accounts in V9, changing defaultValue in MetadataSchema.Attribute from 0 to NULL did not work.

    As we don't use this field or any Sales related fields, I ended up creating this trigger to force NULL value during an account creation :

    CREATE TRIGGER new_AccountOpenRevenue
    ON AccountBase
    AFTER INSERT
    AS
    BEGIN
    	Update AccountBase
    	SET OpenRevenue = null 
    	from AccountBase ab
    	Inner join inserted ins on ins.AccountId = ab.AccountId
    End
    Go

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error on Mail Send: transactionCurrencyId needs to be supplied to format a transaction money field

    Hi All,

    We experienced  a similar issue when inserting an email template into a new email message (to Account).

    The fix for us is:

    1) Make sure the Default Currency for the current user has been set.

    2) Make sure the Currency for receiver (Account for our case) has been set.

    Hope this helps.

  • Suggested answer
    Maxine Profile Picture
    Maxine on at
    RE: Error on Mail Send: transactionCurrencyId needs to be supplied to format a transaction money field

    I have raised this with Microsoft and they have identified it as a bug - but no ETA. This is the response I received in Sept 18:This is a known bug in current version of Dynamics 365 where in email templates are throwing such errors. I have contacted them about an ETA on a fix, but nothing yet.

  • Suggested answer
    Dynamics365 Rocker Profile Picture
    Dynamics365 Rocker 7,755 on at
    RE: Error on Mail Send: transactionCurrencyId needs to be supplied to format a transaction money field

    Below post may help you:

    customereffective.typepad.com/.../transactioncurr.html

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error on Mail Send: transactionCurrencyId needs to be supplied to format a transaction money field

    Set the currency for the user in personal setting. This will resolve the issue.

    7723.Capture.PNG

  • Neurone3 Profile Picture
    Neurone3 30 on at
    RE: Error on Mail Send: transactionCurrencyId needs to be supplied to format a transaction money field

    Hi, if the template regards an account or a contact entity you need to set the currency type on the account. In my case this solved the problem.

  • Franji Profile Picture
    Franji 25 on at
    RE: Error on Mail Send: transactionCurrencyId needs to be supplied to format a transaction money field

    Hi,

    Have you finally found a solution for this?

    We have the same problem since we update to dynamic 9.0 when a workflow tries to send a template by email, it gives us the error:

    transactionCurrencyId needs to be supplied to format a transaction money field

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error on Mail Send: transactionCurrencyId needs to be supplied to format a transaction money field

    We tried engaging Microsoft but no resolution yet

  • Neurone3 Profile Picture
    Neurone3 30 on at
    RE: Error on Mail Send: transactionCurrencyId needs to be supplied to format a transaction money field

    I'm facing the same problem but on an InstantiateTemplateRequest via web api. Any Solutions?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error on Mail Send: transactionCurrencyId needs to be supplied to format a transaction money field

    In Parent Workflow we are checking condition and sending out mail ,On Status Change of Case.

    Workflow_5F00_3.PNG

    Workflow_5F00_3.PNG

    Workflow_5F00_4.PNG

    Thanks,

    Anwesha

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans