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.

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
  • 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.
    
    select * from IV00105 (nolock) where CURNCYID <> ”
    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.
    
•  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
   • Point to Setup
   • Point to System
   • Click Currency. If the existing currencies that are set up fit your needs, you may use them and skip this step. 
2. On the Microsoft Dynamics GP menu
   • Point to Tools
   • Point to Setup
   • Point to System
   • Click 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.)
3. On the Microsoft Dynamics GP menu
   • point to Tools
   • point to Setup
   • point to Financial
   • Click Multicurrency. Select the currency ID as the Functional Currency and Reporting Currency. You will also need to populate the Default Transaction Rate Types.
4. Click OK to close the window. You will receive a message stating you will need to run check links on the Multicurrency Setup Files. Click OK to this message.  Use these steps to run check links:
   • On the Microsoft Dynamics GP menu, point to Maintenance and click Check Links.
   • Select Financial as the Series and insert the Multicurrency Setup Files from the Logical Tables section to the Selected Tables section.
   • Click OK and print the report to the destination you choose.