re synchronize the HQ database

Create and approve worksheet 250 for the items that are not in the store databae. Processing that worksheet will add them to the store operations db

- h> I need to re synchronize the HQ database with store operations database.

Check that the item is not flagged as inactive at the store.

Query the store database as another option: select hqid, itemlookupcode, description from item where itemlookupcode 'type_the_itemlookupcode_here'

the hqid in the store db must match the item id in the hq db

h> Thanks for the help convluted. the 250 worksheet did not work. In the

In the item table I see all the items with the HQID, StoreID, and the itemlookupcode. But when I look in the Store operations database the itemlookupcode for that specific item is not in that database. I sent the

250 worksheet but that did not work. The item exist > Check that the item is not flagged as inactive at the store.

I think you could export a new store database (DBX) using the old store database (DB) as a template. Then delete the old store database (DB) and restore the new store database with the same name as the old. Everything should be up-to-date at that point.