Error message when you look up a project number in Project Accounting in Microsoft Dynamics GP 9.0: "Index 0 of array '(R) Project Status' is out of range in script 'Project_Lookup_Scrolling_Window SCROLL_FILL'"


Symptoms


When you look up a project number in Project Accounting in Microsoft Dynamics GP 9.0, you receive the following error message:
Unhandled script exception: Index 0 of array '(R) Project Status' is out of range in script 'Project_Lookup_Scrolling_Window SCROLL_FILL'. Script terminated

Cause


This problem occurs if there is an incorrect value in the PA Status (PASTAT) field in the PA Project Master File table (PA01201).

Resolution


Note You must be an administrator to perform the following procedure.

To resolve this problem, update the PA Status field in the PA Project Master File table. To do this, follow these steps:
  1. Have all users exit Microsoft Dynamics GP, and then make a complete backup of Microsoft Dynamics GP.
  2. Click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
  3. Log on to Microsoft SQL Server as the sa user.
  4. In the database list, click the Microsoft Dynamics GP company database that you want to update.
  5. In the query pane, type the following query:
    select * from PA01201 where PASTAT < '1' or PASTAT > '10'
  6. Click Execute Query.
  7. Use the correct PASTAT value to update the records that were returned in step 6. To do this, type the following query in the query pane:
    update PA01201 set PASTAT = 'x' where DEX_ROW_ID = 'zz'
    Notes
    • The x placeholder represents the status of the project. The zz placeholder for the DEX_ROW_ID value represents the row that you want to change.
    • To determine the correct PASTAT value to use in the update statement in step 7, point to Setup on the Tools menu, point to Project, and then click Status to open the Access the Project Status - Setup Options window. This window lists the status options and the corresponding values that are available for the PA Status field. For example, a status of 1 equals an open status.
  8. Click Execute Query.