adding Items in Transfer

Did u ever import items in HQ instead of adding them from HQ Manager? i faced this problem in a testing database in which i imported some items from excel, the problem was corrected when i re-import the items being more careful, but unfortunately, i don't remember the trick!

u might "SELECT * FORM Item WHERE ItemLookupCode='x' or ItemLookupCode='Z'" where x is an item that added normally, and 'y' isn't added then compare the 2 records trying to catch what is different

Nashat

I think you might have a problem where the items do not exist in ItemDynamic for one of the stores. In HQ Manager, open the item properties and look at the Store Quantity tab - does the display look normal?

If this ends up being your issue, Retail Realm has a fix for this -

Glenn Adams Tiber Creek C> Did u ever import items in HQ instead of adding them from HQ Manager?

Naveed,

find attached a script to insert the missing items into ItemDynamic table, please BACKUP FIRST

begin 666 Correct ItemDynamic.sql M9&5C;&%R92! 4W1O

Nashar, thanks for your help. after executing this script problem is resolved but these items showing zero inventory inhand for all stores but stores have alot of inventory. How it will effect if we create trafer in HQ from one store to others.

Regards,

"Nashat" wrote:

The qty information will remain 0 until the item is updated in the store that a 401 worksheet is processed, u might create and process a 501 worksheet (request a full item count)

Don't worry about creating transfers in HQ, quantities will remain accurate in the stores and will be uploaded to HQ whenever they r updated.

Nashat,

Could you attach this script again or email it to me snipped-for-privacy@kidsstuffsuperstore.com I was unable to get an attachment of this script through Outlook.

Thank you, Neil

"Nashat" wrote: