Looking to hire someone to customize the following for RMS/HQ.
We are an 11 store chain and run a custom report every week to see what item(s) we've sold out of a particular category.
Once I have that report, I paste it into EXCEL - remove items I no longer want or still show my having multiples of in stock.
That leaves me with a list of almost 50 items every week that I need to manually cut and paste into MANAGER and hit the CHECK STORES button to see if any of the other stores have EXTRAS of those items so I don't waste money restocking inventory that's already within the chain.
Needless to say this is very time consuming when doing one at a time.
In a perfect world I'd like to be able to send the information from the excel spreadsheet (.csv file?) - have it check the item description compare it and kick back a report letting me know which locations have a stock level >1 or a stock level >0 (whichever I choose) on ALL the items on the list vs one at a time.
This way the individual store can have a clean report letting them know which locations to call and confirm on the extra inventory.
Let me know if this is something you or your company can do and I'd like to hire to you to make this.
John
