Extended Pricing SQL Locking
Summary
A client site that uses our MO Receipt Integration (MORI) module recently reported a frequent occurrence of SQL deadlocking from a stored procedure called sopExtPricingPriceBookSetup. Posting an MO Receipt (with or without MORI) adds inventory to the system, which results in an update to the item’s Current Cost. The issue was particularly noticeable with MORI because the module creates a large number of MO Receipts at a rate not possible if users were manually entering and posting transactions. A site with a large number of users, or other automated integrations that touch inventory, could also be impacted by this Extended Pricing issue. Since MORI runs by itself on a dedicated GP client, our “fix” for this (which we released in a build yesterday) was to add switch on the MO Generator window to “Disable Extended Pricing”.
Classifications
AskAI Classifications
LabelsLinked Companies
