Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
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 | Talent TechTalks | Upcoming TechTalks
I have a question regarding displaying balances in the original currency in which they were posted.
I set up following in the report column definition:
- currency display = natural / originating currency
I started the report, and an error popped up "A reporting currency of NAT cannot be used unless a currency filter is specified".
So I went on by setting the currency filter. Now if I specify one foreign currency, this works fine. But in my case I have more than one currency. I understand MR cannot add multiple currencies, but I was wondering if the only way to achieve this is to create one column definition per currency, or if there is any smarter way to achieve this?
Many thanks and best regards
Do I understand this correctly when I say that you have postings in multiple currencies on one ledger account (e.g. USD, AUD, EUR, etc.) and want to see the USD, AUD, EUR amounts posted separately as they were posted or do you want to see the whole account balance converted into USD, AUD, EUR, and so on?
I would like to see amounts posted separately as they were posted.
My understanding is that you have to create one column for each currency then where you filter for the specific currency.
If you work with a couple of currencies this might be ok.
Yet, if you have many currencies and regularly record transactions in currencies that you have not used before then the setup and configuration of the column structure might get cumbersome.
Might be faster and easier to user Power BI then ...
I like the option with the separate columns; in my case I only have 3 currencies.
Business Applications communities