Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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!
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.
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?
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.
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
Business Applications communities