Sort order

There is a specific sort order which Sterling Order Management System Software uses for all custom code.

When you develop custom code, you should be aware that Sterling Order Management System Software obtains YFS_INVENTORY_ITEM locks in the following sort order:

Item ID, Product Class and UOM

If you adopt this sort order, you should greatly minimize the chance of deadlocks.