Right clicking on Purchase Orders Invoices and Receiving Items is slow

book

Article ID: 161488

calendar_today

Updated On:

Products

Asset Management Solution

Issue/Introduction

Right clicking on Purchase Orders Invoices and Receiving Items is slow taking 20 + seconds before the options appear.

NA

Cause

There are two stored procedures that are called when right clicking on these resource types to determine if the options to Generate Invoice and Receive Items should be shown.  These stored procedures appear to be slow in some environments.

Resolution

This will be resolved in a future version however for the short term the attached sql can be run in SQL Management studio to update these allowing them to run quicker.


Applies To

7.5

Attachments

spAsset_Receiving_ItemActions_GenerateReceivingItemAction_DoesItemActionApply.sql get_app