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.
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
WHERE name = 'IN_XPITI_INVOICE_ID'
AND object_id = OBJECT_ID('[DBO].[X_PICK_TICKET]'))
INDEX IN_XPITI_INVOICE_ID ON dbo.X_PICK_TICKET (X_INVOICE_ID)
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.
Pull sheet processing time should improve and all pull sheets should come off the report without errors.