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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Can Report Writer show...
Microsoft Dynamics GP (Archived)

Can Report Writer show correct foreign originating currency symbol?

(0) ShareShare
ReportReport
Posted on by Dan Pepin 60

I am using SOP Blank History Invoice form and want my currencies to display in the originating currency. I have each currency setup with its own symbol and am sure to select "Originating" as the currency type when I print. I have edited the F/O Unite Price, F/O Extended Price, etc. fields so that (C) Force Functional > 1. By doing this, I am getting the orginating amount to print. My problem is that the currency symbol on, say, a Euro invoice will display as "$" instead of "EUR" ever though the ACTUAL AMOUNT is changing to the correct number. So my invoice that I want to print as EUR 100 is printing as $100. Does anyone know how to get the currency symbol to change along with the amount? Where is the "$" driven from? Thanks in advance for your help!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hello Dan

    If you go to Tools > Setup > System > Currency on each of your companies can you verify which sign is in use? as GP gives you Dollar, Euro, Brittish Pound and Yen

    If there is setup correctly then my second choice will be your regional settings

  • Dan Pepin Profile Picture
    Dan Pepin 60 on at

    As stated above, all currencies have already been set with their unique signs. Thank you for trying!

  • Community Member Profile Picture
    Community Member on at

    Double click the F/O unit price field in the report and see if there are any format settings changed. Also ensure that its format is based on the Currency ID field.

    If in doubt, create a second Reports.Dic and open it in another session of GP. Insert the unmodified version of the SOP Blank Invoice into it and compare the settings for the two same fields.

    Why did you edit the F/O fields? These do the job they are supposed to do - print eithre the originating or functional currencies based on the choices you make when printing.

    If you print the original version of the SOP Invoice - does it print the currencies as expecected?

  • Community Member Profile Picture
    Community Member on at

    I am having the same issue on one of my customer's PC. The blank invoice was OK yesterday. Today even the quantity field has the Functional Currency displayed which is not the same as the Originating Currency. How can the report just change?

    Any help would be greatly appreciated.

    Saras

  • Community Member Profile Picture
    Community Member on at

    Hi,

    The report can't change. There is some other issue.

    Yesterday - were you printing the report from the exact same PC?...using the exact same Icon to launch GP?

    Different PC's and indeed different Icons on the same PC, could be pointing to a different Dynamics.set file...and therefore potentially a different Reports.dic file....so you could be looking at two different modified versions of the report.

    Or - someone could have modified the report since yesterday.

    ian.

  • Community Member Profile Picture
    Community Member on at

    Hi Ian,

    The user tried the report on other PCs and it's the same. The Quantity field, the Unit Price field and the Invoice Subtotal field are printing on the blank invoice form with the Functional Currency symbol while the Extended Price field is in the Originating Currency symbol.

    I checked the layout in Report Writer and nothing has been changed.

    Thanks, Ian

    Saras

  • Community Member Profile Picture
    Community Member on at

    Hi Saras,

    The issue has to be with the formats assigned to the fields. (or possibly the format of the calculated field - if these fields are calculated fields).

    I would check the formats in the modified version against the formats in the original version by opening GP wice and opening the Report Writer. - each session of GP should be pointing to a different reports.dic so that in one you can reinsert the original report and open it. (Make sure this version is not your LIVE reports.dic!!).

    Its also possible that the report is corrupted. To test - I would make a copy of the Reports.dic.

    Then open Report Writer and delete the modified report...and inport it again from the Reports.dic backup. Its not a fool proof way - but you might get an error.

    I would also try printing the original version to see if the same error exists. Just to be 100% sure the issue is the modified report.

    Ian.

  • Community Member Profile Picture
    Community Member on at

    Hi Ian,

    Just to update you. The report was corrupted. Thank goodness for me, I found there was a backup of Reports.dic somewhere on the server which I imported as you suggested.

    Thanks a lot, Ian.

    Regards,

    Saras

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans