Daily Sales & Vendor Invoice Blocking Issues in AX2012

The client

A retailer of furniture, appliances, electronics and home furnishings, running Microsoft Dynamics AX 2012 and relying on IT-Commune for ongoing technical support.

The challenge

• Daily sales posting — the overnight batch job that posted daily sales would halt whenever amount differences exceeded the configured limits. This left the Customer table blocked every morning, preventing staff from entering new customers until the job was manually resolved.
• Vendor invoice posting — posting a single vendor invoice would block the Inventory tables, making it impossible to post the next vendor invoice until the block cleared.

The solution

Investigation traced both issues to the same root cause: mass-updates were creating exclusive locks on the InventTrans table (and the related InventDim and InventTransOrigin tables). The fix was to change the bulk row updates to update line-by-line instead, using the existing index on the RecId field — eliminating the exclusive locks without changing any business logic.

Technology

Microsoft Dynamics AX 2012.