Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you drill back to a Payables Management document in Microsoft Dynamics GP: "Unhandled script exception Index 0"

Error message when you drill back to a Payables Management document in Microsoft Dynamics GP: "Unhandled script exception Index 0"

SYMPTOMS

When you drill back to a Payables Management document in Microsoft Dynamics GP and in Microsoft Business Solutions - Great Plains 8.0 , you receive the following error message:

Unhandled script exception Index

↑ Back to the top

CAUSE

This problem occurs if the PM Key Master File (PM00400) table contains records that have incorrect Document Type ( DocType ) values.

The following are valid Document Type values in the PM00400 table:

• 1 = Invoice
• 2 = Finance Charge
• 3 = Miscellaneous Charge
• 4 = Return
• 5 = Credit Memo
• 6 = Payment
• 7 = Scheduled Payment

↑ Back to the top

RESOLUTION

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
To resolve this problem, follow these steps:
1.

Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.

Method 1: For SQL Server Desktop Engine

If you are using SQL Server Desktop Engine (also known as MSDE 2000), start the Support Administrator Console. To do this, click Start , point to All Programs , point to Microsoft Administrator Console , and then click Support Administrator Console .

Method 2: For SQL Server 2000

If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start , point to All Programs , point to Microsoft SQL Server , and then click Query Analyzer .

Method 3: For SQL Server 2005

If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start , point to All Programs , point to Microsoft SQL Server 2005 , and then click SQL Server Management Studio .
2. Run the following script against the company database to identify records that have an invalid Document Type value: 
Select DEX_ROW_ID, * from PM00400 where DocType < '1' or DocType > '8'
3. Run the following script against the company database to set the value in the DocType field to the correct value: 
Update PM00400 set DOCTYPE = 'value' where DEX_ROW_ID = 'value2'
Note Replace the value placeholder with the appropriate value for the DocType field. Replace the value2 placeholder with the DEX_ROW_ID value from step 2.

↑ Back to the top

Keywords: kberrmsg, kbtshoot, kbprb, kbFreshness2007, kbMBSMigrate, kbMBSPartner, BemisKB864598, kbMBS10, kbExpertiseBeginner

↑ Back to the top

Article Info
Article ID : 864598
Revision : 1
Created on : 3/8/2017
Published on : 3/8/2017
Exists online : False
Views : 72