Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

Mixed currencies in project posted transactions

Posted on by 1,418

It looks like that project posted transactions are showing up in mixed currencies. The accounting currency is Tanzanian Shilling (TZS) and the project contract sales currency is USD. If you see the total cost amount in the project posted transactions, the big amounts at the top seem to be in TZS and the smaller amounts at the bottom in USD. I need your help to understand whether something is wrong in the setup which is causing this discrepancy.

pastedimage1604493632259v1.png

If we view the transaction details, I do not understand how the system is calculating the cost price values and what's the currency of these values?

pastedimage1604493874960v3.png

If we view the transaction details of the cost amount 215, it looks like the cost price is in USD here. 

pastedimage1604493965337v4.png

Your help would be appreciated to explain these mixed up currencies in project posted transactions.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Mixed currencies in project posted transactions

    Good morning Muhammad,

    Many thanks for the feedback.

    To me there seems something wrong.

    First, the project/posting date of the line and the voucher seem different.

    Second, if I translate the TZS amount of 20525269 into USD then I do not even come close to the 1200 USD shown above.

    Do you have a developer around who could have a look at the data?

    Also, have a look at LCS.

    There are a number of hotfixes available when it comes to foreign currency transactions.

    Maybe one of those fixes matches your issue.

    Best regards,

    Ludwig

  • M Anas Khan Profile Picture
    M Anas Khan 1,418 on at
    RE: Mixed currencies in project posted transactions

    Hi Ludwig, this is what I see when I click on View voucher button.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Mixed currencies in project posted transactions

    Good morning Muhammad,

    The voucher transactions form that you show in front shows a date in August (17 August)

    The form that you show in the background shows a different date in September.

    Does this voucher really belong to the project no. TZP-000003?

    Can you please double check?

    Many thanks,

    Ludwig

  • M Anas Khan Profile Picture
    M Anas Khan 1,418 on at
    RE: Mixed currencies in project posted transactions

    The accounting currency is Tanzanian Shilling (TZS). Project contract sales currency is (USD). Please find the voucher screenprint below.

    pastedimage1604535827638v1.png

  • Suggested answer
    RE: Mixed currencies in project posted transactions

    Hi Muhammad,

    There are a number of known issues regarding currency conversion on project transactions, for example these two fixes that you can find in LCS.

    My suggestion will be for you to open a support case so we can investigate what is the exact scenario and provide the correct fix.

    pastedimage1604500335636v1.png

    pastedimage1604500455353v2.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Mixed currencies in project posted transactions

    Hello Muhammad Anas Khan,

    The project transactions should all be posted in your accounting currency.

    Project sales prices are different because you can define that you invoice a customer in a currency other than your accounting currency.

    What is your accounting currency?

    Also, can you share a screenprint of a voucher of one of your transactions?

    Many thanks,

    Ludwig

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

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

Product updates

Dynamics 365 release plans