You’re offline. This is a read only version of the page.
75
I am using MC for payables, and when printing the Payables TB (With options, Historical...), I am getting some illogical figures for the Multicurrency transactions:
The Originating and functionnal may not be correct by cuurency, thought the total fnctionnal is correct!
I have noticed also that this is mainly appearing when I apply functionnal payments against foreign invoices!!
I have done some external report to validate that based on the distribution lines, I am also having a same total functionnal total but not matching originating amounts!
Did anyone faced this situation, and what reports wouldbe used to get originating correct totals?
Also, I havesome cases where the distribution is showing a big amount with a rounding distribution type! what could cause that?
*This post is locked for comments
Dear Richard,
thx for your reply,
It is a little lengthy in our case to do a Revaluation before each posting;
My main concern is from where can we get Originating balances for Vendors; Note that for customers the statement routines is great, why no such option exits for Vendors?
thx again
MC can be tricky until you realize that when you start a transaction in one currency, you need to complete that transaction in the same currency. For example, you enter a PO in Yen, you need to receive it in Yen, match the invoices in Yen and pay it in Yen.
The conversion to your functional currency updates your GL with then current figures that change by the minute. So when you have an invoice in your system that was entered in an originating currency and revalue it at month end, you are adjusting your GL AP balance for that particular point in time. One minute later, the converstion rate will change.
To pay these invoices, I recommend having your currency converter wire the proper originating currency amount (Yen in my example) to the vendor and then tell you how much of your functional currency was consumed at what exchange rate. Enter that exchange rate, revalue that invoice, and enter the payment.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (