Skip to main content

Notifications

Microsoft Dynamics NAV forum
Answered

Payment Visibility

Posted on by 11
If I want to view the GL details for a payment, it always defaults to USD. However, the payment made was in CAD but the GL details are only showing in USD. Is there a way I can view the GL details in CAD? Also, is there a rhyme or reason as to why NAV auto populates two specific FX gain/loss GL codes on these payments?
  • Verified answer
    Jun Wang Profile Picture
    Jun Wang 5,088 Super User on at
    Payment Visibility
    you could have a dev build a customization to include the currency code for other currencies. The out of box gl only shows local currency.
     
    Jun Wang
  • Esther Profile Picture
    Esther 11 on at
    Payment Visibility
    Thank you again, Zhu. I can see the different currencies in Customer Ledger Entries but unable to once I drill into the GL Entry (Navigate / GL Entry). This is where it would be helpful to see the various currencies. 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 62,529 Super User on at
    Payment Visibility
    Hi, there are Currency Code and Original Amount fields in Customer Ledger Entries, which are standard functions and do not require additional settings.
     
    Hope this helps.
    Thanks.
    ZHU
  • Esther Profile Picture
    Esther 11 on at
    Payment Visibility
    Thank you Zhu! But what if we conduct business in more than two currencies? For example, we have USD, CAD, EUR, GBP, and NZD. Could I add all additional currencies in the setup and then see them in customer ledger entries?
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 62,529 Super User on at
    Payment Visibility
    Hi, I recommend looking in Customer/Vendor Ledger Entries, it's easier.
    Or you can try the function below.
     
    Hope this can give you some hints.
    Thanks.
    ZHU

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,907 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,189 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans