Skip to main content

Notifications

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

AX2012R3 - Manual exchange rate not working in inter-company payment

Posted on by 434

Guys,

Appreciate someone could have help me on this.

Scenario: 

Company home currency = SGD

Case: Make an Intercompany company payment in USD

Issue: Wanted to manual insert the exchange rate before posting the payment journal but the manual exchange rate enter is not working

I am in USRT entity, i am making a vendor payment for USSA entitiy

payment-1.png

I am making an payment of 1,000 USD, system default rate was 4.2831 SGD to USD.

I wanna to change the rate to 4.000 before posting.

I notice that my debit amount for home currency in my voucher did not reflect the exchange rate of 4.000, causing the journal unable to post due to journal is not balance.

7357.payment2.png

Any solution to this?

Appreciate someone could share the solution

  • Suggested answer
    AXGeek33 Profile Picture
    AXGeek33 10 on at
    RE: AX2012R3 - Manual exchange rate not working in inter-company payment

    Yea, that works if the company is the same but for intercompany it does not update.  I even tried to use the Forced Exchange rate on the payment journal under the Setup tab but it will not update for intercompany.  If i change the company back to the same entity it will update using the forced exchange rates.  

    Not sure if this is a bug or if it was meant to be this way.

    The only other option i have found is to process it through a general journal (daily journal) there you can manage the exchange rates and it updates the totals.

    After some code checking, there is a limitation for Vendor Payment Journal with intercompany exch rate overwrite.

    pastedimage1631813195249v1.png

  • Dexin Profile Picture
    Dexin 434 on at
    RE: AX2012R3 - Manual exchange rate not working in inter-company payment

    Hi Cody,

    It doesn't works for me.

    Did you try interncompany payment?

    I follow your method, 

    1. I created new payment journal, i added 1 payment line, chosen an accounting in foreign currency., i changed the exchange rate then go settlement to mark the invoice to be settlement. When i closed the form the exchange that i entered was back to default

  • Suggested answer
    CodyB Profile Picture
    CodyB on at
    RE: AX2012R3 - Manual exchange rate not working in inter-company payment

    Hello,

    In order to get this to work, the exchange rate needs to be changed to what you want it to be before executing any payment proposal lines.

    I tested myself where I just created a new line, changed the exchange rate, than added payment lines and it took the exchange rate I had entered.

  • Dexin Profile Picture
    Dexin 434 on at
    RE: AX2012R3 - Manual exchange rate not working in inter-company payment

    Hi Ludwig,

    They are both in USD @ 4.000

    I simulate by combine into 1 lines instead of split the line, i still found the exchange rate that 1 put in 4.00 not reflect.

    I am expecting to see the 1,000 usd x 4.00 = 4,000

    Issue a payment journal in 1 payment line for intercompany payment.

    I selected a intercompany customer > function > Settlement to mark the invoice to settle

    Payment3.png

    Manually insert the rate as 4.00. i found no change in the journal amount. I am expected to see 4,000.00

    Payment4.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: AX2012R3 - Manual exchange rate not working in inter-company payment

    Hi,

    Why do you make a split payment and do both lines have the same currency assigned?

    DR and CR don't seem to fit and I wonder why.

    Would be great if you could provide more information.

    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,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans