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 access to this Currency ID in the Multicurrency Currency Access Table - DYNAMICS..MC60100"
• Errors related to currency fields (e.g., discount percentage calculations)

Troubleshooting Steps

Step 1: Check if Functional Currency is Set Up

Navigate to Microsoft Dynamics GP > Tools > Setup > Financial > Multicurrency.

• If Functional Currency is not set up, proceed to enable functional currency.
• If it is set up, continue to Step 2.

Step 2: Run Check Links

If functional currency is set up but errors persist:

1. Navigate to Microsoft Dynamics GP > Maintenance > Check Links.
2. Select Financial as the Series.
3. Add Multicurrency Setup Files from Logical Tables to Selected Tables.
4. Run Check Links.

Step 3: Verify Currency Access

In the DYNAMICS database, check the MC60100 table to verify the currency is set up for the company processing the transaction. The company is coded; find the corresponding company name in table SY01500.

Step 4: Check for Non-Blank Currency IDs

If items or checkbooks have non-blank CURNCYID values, eConnect will proceed as if multi-currency is enabled:

SELECT * FROM IV00105 (NOLOCK) WHERE CURNCYID <> ''
SELECT * FROM CM00100 (NOLOCK) WHERE CURNCYID <> ''

Choose one of the following options:

Option 1: Enable Multi-Currency

1. Go to the registration window in Dynamics GP.
2. Enable the Multicurrency Management option.
3. Run Check Links against the multicurrency table to populate CURNCYID and CURRINDX fields throughout the system.

Option 2: Disable Multi-Currency

Set CURNCYID to blank and CURRINDX to 0 in IV00105 and/or CM00100 as necessary.

Step 5: Test Other Transaction Types

If functional currency setup is the issue, typically all transactions will fail. Test whether other transaction types process successfully.

Enable Functional Currency

Follow these steps to enable functional currency in Dynamics GP (from Microsoft Knowledge Base):

1. Set Up Currency (If Needed)

1. Navigate to Microsoft Dynamics GP > Tools > Setup > System > Currency.
2. If existing currencies fit your needs, skip to the next section.
3. Otherwise, add the required currencies.

2. Grant Currency Access to Companies

1. Navigate to Microsoft Dynamics GP > Tools > Setup > System > Multicurrency Access.
2. Select the currency ID you will use as functional currency.
3. Check the Access box for every company that needs this currency.

3. Configure Functional Currency

1. Navigate to Microsoft Dynamics GP > Tools > Setup > Financial > Multicurrency.
2. Select the currency ID as the Functional Currency and Reporting Currency.
3. Populate the Default Transaction Rate Types.
4. Tap OK to close the window.
5. You'll receive a message stating you need to run Check Links on the Multicurrency Setup Files. Tap OK.

4. Run Check Links

1. Navigate to Microsoft Dynamics GP > Maintenance > Check Links.
2. Select Financial as the Series.
3. Move Multicurrency Setup Files from the Logical Tables section to the Selected Tables section.
4. Tap OK and print the report to your chosen destination.