Hello, Does anyone know a script to tell what items were added in store ops after sychronizing with hq. I have a client who gave out the password for administrator to users who added items in a store database after the store was synchronized with hq.
How to tell what Items added in store ops after synchronizing with
May 12, 2009
1 Replies
First reply
if the item was created at the store, then the hqid should be 0. Try this: select itemlookupcode, description, extendeddescription,price,quantity,datecreated from item where hqid=0
Read the full reply