This article addresses the issue when partially received Purchase Invoices are opening very slowly with uncharacteristic delays whereas fully received invoices can be opened without delays.
This issue can be caused by slow response time when querying the INVENTOR table which can be improved by the MSSQL Database Administrator indexing the fields in this table as described below:
- Execute the SQL Server Profiler utility for query analysis from SQL Server Management Studio, and take note of any recommendations for fields that should be indexed.
- Create the below index in the Inventor table, making sure to add any other fields that were recommended for indexing:
CREATE NONCLUSTERED INDEX SUP_IN_PDTY_PO
ON [dbo].[INVENTOR] ([PD_TYPE],[PO_ID])
Partially received invoices should open without delays.