GP Web Services and ISO Currency Code

  • GP Web Services and ISO Currency Code

    Posted by DSC Communities on December 29, 2022 at 3:58 pm
    • Michael Beaupre

      Member

      December 29, 2022 at 3:58 PM

      I’m using GP Web Services to create a Payables Invoice.
      I’m getting this error:Ā  Operation failed: Create PayablesInvoice, Message: An ISP 4217 Currency Code must be three characters long.

      I Googled the error and found a solution that said that I can’t have two Currency Codes with the same ISO Code (which I did).
      I so I deleted the duplicate record (in Test)Ā  on the Currency Setup Screen, but I’m still getting the error.

      Any suggestions?

      Thank you.

      ——————————
      Michael Beaupre
      Systems Analyst
      Connexus Energy
      Ramsey MN
      ——————————

    • David Morinello

      Member

      January 5, 2023 at 8:53 AM

      It sounds like a bad value is stuck in other table(s). Have your SQL guy trace while forcing an instance of the error.

      That should help you find the problem.

      ——————————
      David Morinello
      Senior Developer
      TruckPro LLC
      Cordova TN
      ——————————
      ——————————————-

    • Derek Albaugh

      Member

      January 6, 2023 at 8:13 AM

      Along with being three characters long, the ISO currency codes must all be unique, you cannot have the same ISOCURRC value for two or more currencies.

      This script makes it easy to verify, which you’ve probably already looked at:
      select ISOCURRC, * from MC40200

      ——————————
      Derek Albaugh
      Sr. Support Engineer
      Microsoft
      Moorhead MN
      ——————————
      ——————————————-

    DSC Communities replied 2 years, 10 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘GP Web Services and ISO Currency Code’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!