Hi - anyone dealt with a doing a vendor management system with Sage 100. The concept is like having a vendor going into a Lowes or Walmart and inspecting(counting) what all is on the shelf in the store. So the user will count what is on the shelf - they counted 2 and then this info gets back to their system - the system says there should be 10 on hand and it creates a sales for 8 to replenish. There could be 100 products being counted also. So imagine doing this for 50 stores every week. I am sure there are probably various stats that Jim counted Roswell NM Walmart on these X dates. There might be a survey also about cleanliness of the shelve or product etc.
My idea is maybe using Scanco/Scanforce app and setup a separate sage 100 company to store the stock level by warehouse for each store and then do a physical count against the warehouse for this store. Then compare the shortage with the inventory stock level and create a vi job to import orders into their live company based off the difference.
Any other ideas or addon that does something like this?
TIA
Thanks