HQ - SO Inventory Discrepencies

Oct 10, 2008 1 Replies

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


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:

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required