Issue
When Creating PO For select Vendor and choosing Item Type “Catalog Item” you should get a drop
down for “Item Name” with a catalog part selection list if parts are associated with Vendor. In
some cases when loading “Item Name” after choosing Catalog Item as “Item Type” The selected Item
breifly appears then disappears. This is because the catalog Item on some parts associated with
the Vendor have Null Part IDs. To correct this do the following:
Steps
1.Backup Database
2.To find Catalog Items with null IDs, run the following query:
SELECT * FROM CatalogItem
where PartID is null
3.To delete Catalog Items with null IDs, run the following query:
Delete From CatalogItem
where PartID is null
4.Close all windows and create a new Purchase Order.
A.choose Vendor.
B.Choosing Item Type “Catalog Item”
C.Choose dropdown list for “Item Name”
You should now be able to add the desired part choosing Catalog Item as your Item Type.
Source
Contributor: Larry Lang
Date: 02/11/2014
Version: Control 05.10.1402.0501
_