Dynamics Community Forum Thread Details

The EXCEPTION_CLASS_SCRIPT_OUT_OF_RANGE error in Dynamics GP typically indicates that a script or process is attempting to access data outside of a valid range or trying to reference an invalid value, often due to data corruption or an issue with a record in the Receivables module. Here are some steps to troubleshoot and resolve this issue during Receivables Reconciliation.

Step-by-Step Troubleshooting and Resolution

1. Verify the Latest Dynamics GP Service Pack and Updates

Ensure you’re on the latest service pack or hotfix for your Dynamics GP version. Microsoft frequently releases updates to address bugs, and this error could be a known issue that’s fixed in a more recent update.
Go to Help > About Microsoft Dynamics GP to check your version, then compare it to the latest update available on the Microsoft Dynamics GP Support and Services Blog or download the update from Microsoft’s website if needed.

2. Run Check Links on the Receivables Module

Check Links is a utility in Dynamics GP that can fix data integrity issues in the system by checking tables for consistency. Running it on the Receivables Management series may help resolve any underlying data corruption.
To run Check Links:
1. Go to Microsoft Dynamics GP > Maintenance > Check Links.
2. Choose Sales in the Series dropdown.
3. Select Receivables Transaction Logical File and Receivables Open File (or all tables related to Receivables if you’re unsure).
4. Click Insert and then OK to run the check.

Note: Running Check Links can affect data, so it’s recommended to back up your GP database before performing this action.

3. Use the Reconcile Utility in Receivables Management

The Reconcile tool can fix discrepancies in balances and transaction records in Receivables Management. Use it to verify that all amounts are accurate and consistent.
To reconcile:
1. Go to Microsoft Dynamics GP > Tools > Utilities > Sales > Reconcile.
2. In the Reconcile Receivables Amounts window, select Outstanding Document Amounts and Apply Records.
3. Click Process to start the reconciliation.

This process will re-align any miscalculated amounts and may help clear up the script error.

4. Identify and Correct Corrupt Data

Sometimes, a specific record in the Receivables tables is corrupt or has invalid data, leading to the out-of-range error during reconciliation.
Steps to check for corrupt data:
- Run a SmartList report on Receivables Transactions to review recent or suspicious entries.
- Look for any unusual amounts, dates, or records that appear incomplete or incorrect.
- You can also query the RM tables in SQL (such as RM20101 for open transactions and RM30101 for historical transactions) to identify records with missing or out-of-range values.

SQL Query Example:

sql

If you identify any corrupt records, you may need to delete or update them carefully in SQL. However, make sure to back up your database and consult with a GP partner or DBA before making direct changes to the data.

5. Clear User-Related Temporary Tables

Sometimes, the issue is due to cached or temporary data that is out-of-sync. Clearing user temporary tables can help.
Run the following SQL script to clear temporary tables for all users (again, make sure to back up your database before running):

After running this, have users log out of GP and then log back in to clear any session-related data that might be causing issues.

6. Review Security and Modified Forms

Sometimes, customizations or modified forms/scripts can lead to script errors in Dynamics GP. Check if there are any third-party add-ons or modifications applied to the Receivables screens.
If there are customizations, try disabling them temporarily to see if the error persists.
You can also try logging in as the SA user or another user with full access to see if security restrictions are causing the issue.

7. Consider Rebuilding the Receivables Summary Data

If all else fails, you might need to rebuild the Receivables Summary data. This process can be done using the Reconcile to GL function.
Go to Microsoft Dynamics GP > Tools > Utilities > Financial > Reconcile to GL and select Sales to reconcile Receivables data with the General Ledger.