Loading Inventory - Order - On Order tab can error with An error occurred while parsing EntityName Line 1 position 4735

Owned by Beth Blok (Unlicensed)
Last updated: Mar 16, 2018 by Mike Sheen
1 min read

Problem

Loading an inventory record and selecting the Order > On Order tab can error for some inventory items, but not others.  This applies to V7.01.00 databases

Solution

SQL skills are required

A Working knowledge of SQL Management Studio is required to complete this task.

The issue is caused by an ampersand (&) in a shipment number and the underlying stored procedure not handling that character.  It has been logged for correction in 7.01.01 under DEV-6484.  In the interim, attached is the corrected stored procedure to be downloaded and applied to the database.