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.
Any solution to this?
Appreciate someone could share the solution
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.
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
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.
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156