Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by Dexin

452

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

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Dexin 452 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

CodyB on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Dexin 452 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

AXGeek33 10 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No