Invalid inventory search filters for Category 3 and Category 4 corrected

Problem

Loading the search window attached to Category 3 and Category 4 in Inventory Maintenance have invalid filters that required correction

Solution

Run the following SQL statements to update any existing filters:

UPDATE SY_Filters SET FilterNo = 50054 WHERE FilterNo = 68
UPDATE SY_Filters SET FilterNo = 50055 WHERE FilterNo = 69

NOTE:  This applies to database 7.02.01 and earlier

Related articles