Processing an Increased Number of Documents Resulting in Pull Sheets not Coming off the Report

Overview

This article describes the process to follow when a customer is reporting a performance issue with pull-sheet/pick-ticket processing, resulting in some pull sheets not coming off the report. Further, some users may experience errors with an increased number of documents being processed together.

Solution

The above issue can be mitigated by adding an index on the Pick Ticket Details table as described below:

1. Open SQL Server Management Studio on the server system. 
2. In the left Object Explorer window, use the navigation tree to find the Company database.
3. Right-click on the database name and select New Query and execute the following query.

IF NOT EXISTS
 (SELECT *
 FROM sys.indexes
 WHERE name = 'IN_XPITI_INVOICE_ID'
 AND object_id = OBJECT_ID('[DBO].[X_PICK_TICKET]')) 
BEGIN
CREATE 
  INDEX IN_XPITI_INVOICE_ID ON dbo.X_PICK_TICKET (X_INVOICE_ID) 
END 
GO

This query will create a new index for the "X_PICK_TICKET" table in the company database thereby increasing the speed of running Pull Sheets. 

Testing

Pull sheet processing time should improve and all pull sheets should come off the report without errors.

Back to top