Invalid inventory search filters for Category 3 and Category 4 corrected

Owned by Beth Blok (Unlicensed)

Last updated: Nov 25, 2019

1 min read

Problem

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

Solution

SQL skills required

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

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