/
Loading Inventory - Order - On Order tab can error with An error occurred while parsing EntityName Line 1 position 4735
Loading Inventory - Order - On Order tab can error with An error occurred while parsing EntityName Line 1 position 4735
- Beth Blok (Unlicensed)
- Mike Sheen
Owned by Beth Blok (Unlicensed)
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.
Related articles
, multiple selections available,
Related content
Import of inventory transactions errors 'Object reference not set to an instance of an object
Import of inventory transactions errors 'Object reference not set to an instance of an object
More like this
Loading a purchase order errors for one user only - 'multi-part indentifer could not be found'
Loading a purchase order errors for one user only - 'multi-part indentifer could not be found'
More like this
Inventory > Orders > Used in Work Orders quantities are incorrect where Production Quantity > 1
Inventory > Orders > Used in Work Orders quantities are incorrect where Production Quantity > 1
More like this
'Creditor warehouse not found' error reported when loading inventory in a newly upgraded 6.5.13 database
'Creditor warehouse not found' error reported when loading inventory in a newly upgraded 6.5.13 database
More like this
Invalid inventory search filters for Category 3 and Category 4 corrected
Invalid inventory search filters for Category 3 and Category 4 corrected
More like this
Loading Creditor Transaction batches may error with "Conversion from string %s to type decimal is not valid"
Loading Creditor Transaction batches may error with "Conversion from string %s to type decimal is not valid"
More like this