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 :
Business Central forum
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Display currency on Sales Invoice

Posted on by

Caveat that I know nothing of how dynamics/bc works. 

Our organization is based in the US but does business around the world. We are working with a Microsoft Partner to implement BC and we're hung up on a maddeningly trivial detail - how can I show the currency code on the Sales Invoice report (1306)?

My customer card shows the client as using AUD as currency code

2021_2D00_04_2D00_12-17_5F00_06_5F00_33_2D00_Edit-_2D00_-Customer-Card-_2D00_-Dynamics-365-Business-Central-_1420_-Mozilla-Firefox.png

My posted sales shows a currency code of AUD

2021_2D00_04_2D00_12-17_5F00_46_5F00_14_2D00_View-_2D00_-Posted-Sales-Invoice-_2D00_-PS0000117-_2D00_-Dynamics-365-Bus.png

I have built an RDL version of the 1306 report that just dumps all the fields available to the data set. It prints them as either Field Name and the Field Value (i.e. DocumentTitle_Lbl -> Invoice) or if there's a label version of the field, I display as Field Label, Label Value, Field Name, Field Value (i.e. DocumentDate_Lbl -> Document Date. DocumentDate -> April 2, 2021)

I see the `ExchangeRateAsText` field in there and the value there aligns with what I would see if I clicked the button to Change Exchange Rate so it seems the dataset can access some of the data in the posted invoice's currency card thing there but not the actual Currency Code.

2021_2D00_04_2D00_12-17_5F00_12_5F00_21_2D00_View-_2D00_-Posted-Sales-Invoice-_2D00_-PS0000117-Dynamics-365-Bus.png

However, if I go through all the data in this data dump report, nowhere is AUD available to me. Or any obscure numerical code that might be translateable to AUD. What am I missing? Has the Partner not wired up some setting to let the currency code flow through to one of the 200+ fields available to me?

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans