Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Multicurrency revaluation financial series

Posted on by 5

Hi

I have setup multi currency feature 

My functional currency is GBP  and my originating currency is EURO. My reporting currency is USD

I have created Payment transaction with a vendor operating in EURO currency

When I  did a Purchase series  revaluation   the system generates a Purchase revaluation report as expected.

The distribution of accounts looks fine according to me. 

I have defined the necessary currency accounts for unrealized/realized, Purchase and Finance accounts..

I checked the Inquiry>Financial>Detail   for  the account that I had configured. It shows the posted values 

However when I am trying to get a report for Financial series Revaluation,    the report gets generated but there are no accounts displayed. in the report.   It just prints a blank report with headings..   

Can any one help in this...

pastedimage1591633094960v4.png

pastedimage1591633068989v3.png

Categories:
  • RE: Multicurrency revaluation financial series

    Hi,

    Looks like you were able to find the resolution.  That's great news!   Thanks for sharing and thanks for using the communities. 

    Angela

    Microsoft Dynamics GP support

  • Suggested answer
    RE: Multicurrency revaluation financial series

    Thanks 

    I was able to resolve the issue

    Now the Financial series  report shows the account codes and currency info. 

    The issue , I think was  in couple of area

    I was all along doing a revaluation for an already re-valuated  Purchase transaction with different  configurations in the Posting setup screen. 

    I had used the 'All ' option for Origin   in both 'Purchasing' and 'Financial' series definitions

    Now I enabled  the following entries in Financial series setups 

    • Currency Revaluation>'Post through General Ledger Files' 
    • General Entry>Allow Transaction Posting
    • General Entry>Include Multicurrency  Info
    • General Entry>'Post through General Ledger Files'
    • Create a Journal entry per> Transaction Posting. 

    I enabled  the following entries in Purchasing series setups 

    • Payables Trx Entry>'Post through General Ledger Files'
    • Payables Trx Entry>Allow Transaction Posting
    • Payables Trx Entry>Include Multicurrency  Info

    set up the same values for Payment Entry and Purchase Invoice Entry Origins

    I created a new Purchase Invoice with for a foreign currency vendor and  did a fresh Financial revaluation.. 

    It worked.. 

    pastedimage1591780176444v1.png

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans