Spire 3.x can show unwanted accessories on some part numbers, in Production Orders and Sales Orders.

These were orphaned records that were ignored in BV, BVEssentials and Spire 2.x.


If accessories were never used by the client (on manufactured items) and you want to remove these unwanted accessories, please run the following script in pgAdmin.



DELETE FROM inventory_components WHERE parent_id in (SELECT id FROM inventory WHERE type = 'M');