Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by Dexin

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

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

All responses (5)

Answers (0)

Suggested answer

AXGeek33 10 on at

Like (0)

Report

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.
Dexin 434 on at

Like (0)

Report

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 on at

Like (0)

Report

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 434 on at

Like (0)

Report

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

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

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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