web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Best way to get MC AP ...
Microsoft Dynamics GP (Archived)

Best way to get MC AP balances for MC transactions...

(0) ShareShare
ReportReport
Posted on by Camille Monsef 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

I have the same question (0)
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    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.

  • Camille Monsef Profile Picture
    Camille Monsef 75 on at

    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

     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans