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
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
Microsoft Dynamics Navision auto-post an entry to forex difference when I apply payments from a bank account to a vendor invoice of the same currency, although I posted the payment and invoice in the same month, and in the currencies I set the currency exchange rate for example on 1st January, so I presume that Navision should use that currency exchange rate for rest of the month. and I did not update the currency after that day, the invoice date posted was 27th January. The currency of the invoice and bank were both GBP. How can I fix this error, no currency exchange difference should be posted in such transaction.
FX will be calculated into LCY always.
And, yes, when the last available FX-rate is from the 1st January, an invoice with the posting date 27th january will pick this up.
There are fields in the Purchase Header & Purchase Line which are filled when the invoice is created.
These fields might did contain old information. Updating the Currency Exchange Rates does not update the documents automatically.
Create a new invoice & payment and give it another try. Make also sure that all your other documents dates are past the date of the exchange rate you want to use.
Thank you a lot for the help. After looking into the matter, it turned out that the reason for the incorrectly created forex difference is that the posting date was different from the document date, the user entered the document date as the invoice date, and the posting date as the date they are posting the invoice. Once I aligned both the document date and the invoice date in a newly created invoice, that incorrectly created realized forex difference entry by the system previously did not get posted this time.I think that the system does the forex difference calculation based on the document date and payment date, not the posting date and payment date (there are cases when the invoice is created by the vendor long ago but sent to the customer this current month when the exchange rate is different, then ideally the system should post it based on the posting date exchange rate, and when payment is posted and applied on the same date, no forex difference should be picked up) Sorry for the late reply, and thanks again!
I can't change the currency, have you solved it?
I see so many people start trading and so many of them are writing reviews about how bad Forex trading is. I hate seeing those reviews because that is not the true story and maybe some serious traders won't start trading because of that. The problem is that people who have no idea what forex trading is start to trade and they lose all of their money. It is completely their fault and they should have known better. The main thing for trading is knowledge, patience and good broker. I trade with Binary brokers which is a really reliable broker. I recommend reading about them on https://tradersunion.com/ratings/binary/common/ .
I managed to solve out this problem that time, and I think it is important to update it here since I get email notifications sometimes of people encountering the same issue.
As I found out, the reason for the difference was that the document date & the posting date were different. 1 of them had a date falling under a different period affected by a different exchange rate than the one meant to be used. So what the system did is that it posted forex gain/loss for the difference between the forex rate of the document date and posting date. This is what the system did.
Solution: Just keep the document date the same as the posting date. Or make sure that you update the currency exchange rate for the document 'date' to be the same as the posting 'date' exchange rate.
This happens mostly when you recieve vendors' invoices this month for example to post but the actual invoice's date is way older.
I hope this was helpful.
Thanks for the explanation, I find it very useful. I found a great article about the top 20 Forex books here and maybe this would be useful for someone too. People should share their knowledge with each other.
Business Applications communities