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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Bank Reconciliation - ...
Microsoft Dynamics NAV (Archived)

Bank Reconciliation - Foreign Currency

(0) ShareShare
ReportReport
Posted on by Y_NAV_1716 134

Hi All,

I have been trying to carry out a bank reconciliation and when matching the entries I've come across one particular entry (payment) that was posted in foreign currency. The posting was done correctly i.e. Amount in USD is 10 while in LCY is 5.58. (Base currency of the company is EURO and currency in Bank Account card left empty)

Now the problem is that when running the Suggest Lines function , the Statement Amount in the Bank Statement Lines came up in the foreign currency i.e. 10 . This has caused a difference between the statement ending balance which is totalled in LCY i.e. EUR5.58 and the Total balance since NAV is treating the USD10 as EURO! Screenshot attached to show the amounts.

In this case, shouldn't the Statement Amount have been filled in LCY by NAV? Is there a way to fix this?

Thanks!

Reconcile.PNG

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,004 on at

    Hi,

    in standard NAV when posting the currency transaction to the LCY bank, system automatically applies the exchange rate and posts the transaction in LCY, that is, fields 'Amount' and 'Amount (LCY)' ALWAYS hold the same value. As it doesn't in you system, I can only guess you have a bespoke development to store original currency and transaction value in the bank account ledger. That has broken the bank account reconciliation. You should ask for a fix from your NAV supplier.

    Robertas

  • Y_NAV_1716 Profile Picture
    Y_NAV_1716 134 on at

    Hi Robertas,

    Thanks for your reply :) The above was done and tested even in the Cronus database with the same result. I've also tried the same scenario in a new NAV version (2017) and it works correctly i.e. getting the LCY. Looks like this is a bug in NAV2013 R2. Maybe someone knows of a hotfix for this?

    Thanks!

  • Suggested answer
    RobertasR Profile Picture
    RobertasR 5,004 on at

    It is not the standard NAV bug as it always worked the same. If you have tested in Cronus company on the same database as your other companies, there is a big chance the development is still there (same development work on all companies in the same database). Of course, the issue might be in the localisation as well.

    I would still recommend contacting your NAV partner.

    Roberats

  • Suggested answer
    Tuan Dinh Profile Picture
    Tuan Dinh 45 on at

    Hi,

    I think the issue is the setup of bank card, not bank reconciliation

    When Currency in Bank Account card left empty, this means its' Currency = LCY

    So when you post FCY, NAV will use exchange rate of the posting date to calculate for Amount (LCY)  (in this case it is for Amount too). No FCY recorded in Bank LE. This is not the bug, it's the NAV behavior.

    The difference BTW Currency = blank and Currency <> Blank

    • Currency = blank, you can post any currency code  to Bank card, but NAV records it as LCY 
    • Currency <> blank, you can post only this type of currency code to Bank card, and NAV will record it for Amount (with currency code) and Amount (LCY)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 2

#1
sliderxb Profile Picture

sliderxb 2

#1
broberts Profile Picture

broberts 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans