{$page}

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:

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.

Contributor: Larry Lang

Date: 02/11/2014

Version: Control 05.10.1402.0501

_

• Backlinks include_pagepage_componentbacklinks