Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Exchange rate in Project accounting

Posted on by 520

Hi,

My accounting currency is USD.

I created a PO in project accounting in Canadian dollar in the amount of CAD1,000 dated Aug 10, 2020.

The last exchange rate in the setup USD-CAD is 95.23809 dated Feb 2020, so I'm expecting that the total amount in USD is USD952.38 which can be viewed if you click Totals in PO.

But when I click Project budget status in PO>>Line details>>Financials>>Project budget status, the system uses different exchange rate which is the old exchange rate dated Dec 2013.

The system also updated the Remaining budget based on the old exchange rate which is wrong.

Pls see attached screenshot that shows the discrepancies.

Is this a bug or is there an explanation for this?

Thank you.

discrepancy-in-PO-transaction-exc-rate-vs-project-budget-status.docx

  • marypeace Profile Picture
    marypeace 520 on at
    RE: Exchange rate in Project accounting

    Hi Ludwig,

    Noted on this.

    I will have this check by our developer.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Exchange rate in Project accounting

    Hi marypeace,

    Can you log a support case or get into contact with somebody from your technical / development team.

    They should be able to help you with that.

    On LCS I could not find something that seems to fit to your system version; so, seems to be indeed a bug.

    Best regards,

    Ludwig

  • marypeace Profile Picture
    marypeace 520 on at
    RE: Exchange rate in Project accounting

    Hi Ludwig,

    Yes I believe it is a bug because when I tried it in different environment, it's working fine which uses the exchange rate that is setup in the table.

    The AX version that I use this time is AX2012 R3 with kernel versions and application versions 6.3.5000.138.

    Thanks.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Exchange rate in Project accounting

    Hello marypeace,

    I tried replicating the issue on my demo machine and got a similar interesting outcome.

    Seems to be a bug in my opinion.

    Do you have a developer who could take a look at this issue and/or can you contact the MS support?

    Best regards,

    Ludwig

  • marypeace Profile Picture
    marypeace 520 on at
    RE: Exchange rate in Project accounting

    Hi Ludwig,

    I'm not using budgeting module.

    I'm only using project budgeting.

    Thanks.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Exchange rate in Project accounting

    Hello marypeace,

    You are on Cu13, which is not the very latest version but I have not found anything on LCS that indicates that there is a bug related to your system version.

    Can you thus share a screenprint of your ledger form and what you see in the budget form?

    I am not sure absolutely sure what has been setup there.

    Many thanks and best regards,

    Ludwig

  • marypeace Profile Picture
    marypeace 520 on at
    RE: Exchange rate in Project accounting

    Thanks Ludwig.

    I'm using the default exchange rate type.

    There are only 2 setup of exchange rate in default exchange rate type.

    AX version is AX2012 R3 Kernel version 6.3.6000.151 and application version 6.3.6000.149.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Exchange rate in Project accounting

    Hi marypeace,

    What budget exchange rate type is setup in the ledger form in GL?

    Also, what's the Ax2012 version that you operate?

    If you run an older AX2012 version, I would recommend having a look at LCS (requires login)

    fix.lcs.dynamics.com/.../Results

    Best regards,

    Ludwig

  • Suggested answer
    Junaid Idrees Profile Picture
    Junaid Idrees 12,740 on at
    RE: Exchange rate in Project accounting

    Hi Mary,

    What default exchange rate type you used under the GL > Setup > Ledger screen?

    I can see your budget year is 2019 so did you check exchange rate of 2019?

    Secondly Did you check any hotfix on LCS on the same issue? There used to be so many foreign currency budget related issues earlier in AX 2012 version.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans