Open Forum

Expand all | Collapse all

Odd currency printing on SOP Invoice

  • 1.  Odd currency printing on SOP Invoice

    SILVER CONTRIBUTOR
    Posted 12 days ago
    I thought that I might share this with everyone as it seems to have come up after the big Windows update which broke some other items.  This is something that I don't think that I have ever seen happen before.

    I had a client that noticed that their invoices starting printing Euro currencies on the Discount & Unit Price columns all of a sudden.  No one had modified the system or the report.
    SOP Blank invoice shows Euro in Discount and unit price fields
    A couple of things to know:
    - Customer is running on GP 2016 (16.00.0439)
    - This was a modified form
    - It printed the Euro currency only from 1 or 2 workstations.
    - They do not use multi currency and the only currencies that this company had access to was the US and Canadian currencies.
    - Their reporting currency is US Dollars
    - We checked the regional settings on the machine to make sure it had not changed from US
    - When printing from the original Dynamics GP form it did not have this issue.

    To fix the issue I opened up the modified form in Report Writer.  In looking at these 2 fields I noticed that they were using a format field called MC Decimal Places.
    Properties show MC Decimal Places
    Looking at all of the correct currency fields, they were showing '(C) Curr Index Body' as the format field.
    Extended price shows format field Curr Index Body
    Correction to the FormatField

    I changed the FormatField type from MC Decimal Places to (C) Curr Index Body on the 2 fields saved my report format & tested again to see that the currency was fixed.
    Corrected invoice showing the correct currency format.
    I posted this information in the hopes that this might help someone else.
    Have a great day!



    ------------------------------
    Sheila Jefferson-Ross
    Senior Consultant
    Sheila Jefferson-Ross Co.
    Rocklin CA
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Odd currency printing on SOP Invoice

    SILVER CONTRIBUTOR
    Posted 9 days ago
    Thanks for sharing, Sheila!

    ------------------------------
    Aref Karam
    Data Consultant
    LTI Information Technology
    Ann Arbor MI
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role