Error 1581 - Line = SELECT C_Kitset_Parts

System Version =8.526
Build Date =17/09/2020
Datetime =25/09/2020 11:35:21 AM
User ID =PARTNER
Audit # =35686
Error Number = 1581
Message =Field DESC does not accept null values.
Module =KITSET.INIT
Line =SELECT C_Kitset_Parts

The error occurs when you try to open a kitset that has components included that are deleted products -  partner or support will need to remove it.

FOR SUPPORT / PARTNERS

To identify kitsets with components that are deleted products:

SELECT * FROM prodbld WHERE item NOT IN (SELECT code FROM products)

To identify kitsets with componenets that are inactive products:

SELECT * FROM prodbld WHERE item IN (SELECT code FROM products WHERE inactive)

Open prodbld brow for the codes that have been identified and delete the products that no longer exist.