HQ - SO Inventory Discrepencies

I eliminated at the SO level the ability to create new items, however it seems that I did not catch that my employees could add new items at the SO level through the PO receiving function. Now I have items in SO that are not in HQ. I have now eliminated this feature through my security function. Now I need to figure out what items are in my SO database and not in my HQ database. Is there a simple way to do this? Any reports etc? so that I can either delete or add the items?

I am willing to overwrite my store databases by creating new databases in HQ if that is possible - I'm not that familiar with HQ. I don't think many items were created at the SO level so if this is an easy way to get my databases synchronized I'm all for it.

Thanks

Reply to
Grier
Loading thread data ...

I've written a SQL that shows the discrepancies between the HQ database and the SO database. If you would like for me to e-mail you a copy of the SQL code you may contact me at snipped-for-privacy@venus.com.

Scott

"Grier" wrote:

Reply to
Luminox

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.