Functional Currency Troubleshooting

Functional Currency Troubleshooting

eConnect messages relating to CurrencyID assignment example: This Company you are trying to insert this Currency ID for does not have access to this Currency ID in the Multicurrency Currency Access Table - DYNAMICS..MC60100 or related to a currency field example: Receiving error related to discount percentage calculations.

Troubleshooting Steps

Is Functional Currency Set Up?

  • If no, set up Functional Currency
  • If yes: Was checklinks run? If not, run checklinks
  • If yes and checklinks was run, verify the following: In the DYNAMICS table MC60100, verify the currency for the company processing the transaction against is set up for the Currency ID. Company is coded; therefore, corresponding company name can be found in table SY01500

Check for Multi-Currency Fields

If you have any items in the IV00105 or checkbooks in the CM00100 that have a non-blank CURNCYID value, eConnect will proceed with steps based on you having multi-currency enabled.

  1. select * from IV00105 (nolock) where CURNCYID <> ''
  2. select * from CM00100 (nolock) where CURNCYID <> ''

You have two choices from there because using multicurrency is really an all-or-nothing option:

  1. First, if you want to use multi-currency you will need to go to the registration window in GP and Multicurrency Management option. This will prompt you to run Check Links against a multicurrency table, which will go through the system and populate CURNCYID and CURRINDX fields.
  2. If you do not want to use multicurrency you will need to set CURNCYID to blank and CURRINDX to 0 in the IV00105 and/or CM00100 as necessary.

Additional Check

Were any other types of transaction successfully processed? An issue with functional currency set up will typically result in a fail for all transactions.

To Enable Functional Currency

From Microsoft Knowledge Base:

  1. On the Microsoft Dynamics GP menu, point to Tools.
  2. Point to Setup.
  3. Point to System.
  4. Tap Currency. If the existing currencies that are set up fit your needs, you may use them and skip this step.
  5. On the Microsoft Dynamics GP menu, point to Tools.
  6. Point to Setup.
  7. Point to System.
  8. Tap Multicurrency Access. Select the currency ID you will be using as a functional currency and mark the Access box for every company that is receiving this error. (This is the step that should specifically resolve the error message above.)
  9. On the Microsoft Dynamics GP menu, point to Tools.
  10. Point to Setup.
  11. Point to Financial.
  12. Tap Multicurrency. Select the currency ID as the Functional Currency and Reporting Currency. You will also need to populate the Default Transaction Rate Types.
  13. Tap OK to close the window. You will receive a message stating you will need to run check links on the Multicurrency Setup Files. Tap OK to this message.

Run Check Links

  1. On the Microsoft Dynamics GP menu, point to Maintenance and tap Check Links.
  2. Select Financial as the Series and insert the Multicurrency Setup Files from the Logical Tables section to the Selected Tables section.
  3. Tap OK and print the report to the destination you choose.
    • Related Articles

    • Functional Currency Setup in GP

      Important: Even if you don't use functional currency, it must be enabled to support eConnect. Common eConnect Currency Errors You may encounter eConnect error messages like: "This Company you are trying to insert this Currency ID for does not have ...
    • Connected Sales with Multi-Currency

      When creating new orders through PanatrackerGP sales transactions, you must configure the currency setting appropriately based on whether you use multi-currency in Dynamics GP. Multi-Currency Enabled If you use multi-currency in Dynamics GP: The ...
    • eConnect Errors that may be encountered when using PanatrackerGP

      "Error 1189: taSopHdrRecalc - Payment total does not match deposits+payments" Error: Payment total does not match deposits+payments entered for the document This error usually occurs when the taSopHdrIvcInsertPre stored procedure has been modified. ...
    • Windows Embedded Handheld PGP Setup and Connectivity Troubleshooting guide

      Download the setup guide for instructions on connecting your Windows Embedded Handheld device to your internal network. These steps must be completed before installing PanatrackerGP.
    • Troubleshooting and FAQ

      Why are the orders that I fulfilled not showing up on Order Verify? Check for one of the following reasons: Automatic Verification Setting Under Order Fulfillment Settings, check if you have Order Fulfill Ship ID Behavior enabled AND CreateSOPick ...