<Unknown Supplier>

(0) Share

Report

Posted on by Community Member Microsoft Employee

I have a couple of items in HQ that show <Unknown Supplier> on the Supplier tab in the Item Properties. When I run an HQ query on the item it shows a SupplierId number that does not exist in my Suppliers query. I've deleted the supplier from the Suppliers tab in the item properties and sent a 250 worksheet down to a store. When I chose the Supplier tab in store manager for that item I'm getting a Run-time error -2147417848 (80010108): Automation error. The object invoked has disconnected from its clients. Then the Store Manager closes. Any suggestions?

*This post is locked for comments

All responses (3)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: <Unknown Supplier>

I was able to run the above query with a little modification. Thanks!
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: <Unknown Supplier>

Run the following query on the store database, BACKUP FIRST

--1

--replace the xxxx with the correct supplier code

--this query will fix the primary supplier for the 2 items

update item

set supplierid=(select id from supplier where code='xxxx')

where itemlookupcode in ('item1','item2')

--2

--this query will remove any entries in the SupplierList table for the two items

delete supplierlist

where itemid in (select id from item where itemlookupcode in ('item1','item2'))

--3

--this will insert necessary information into SupplierList table for the primary supplier

INSERT INTO SupplierList([MinimumOrder], [ItemID], [SupplierID], [Cost], [ReorderNumber], [MasterPackQuantity], [DBTimeStamp], [TaxRate])

select '0',item.id,item.supplierid,item.cost,'',1,null,0

from item

where itemlookupcode in ('item1','item2')

A Hassan

RMS Leaders
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: <Unknown Supplier>

You have a reference error between the Supplier table and the Item table. Or a problem with the SupplierList table.

You can delete the item and recreate OR

Set the supplierid in the Item Table = 0 for that item and delete the entries in SupplierList that match the SupplierID and ItemID.

After that you should be able to open the propertied for that Item and fix the supplier.