Essentially I need an application that will compare the contents of an uploaded file (Current inventory) to that of matching items in a database (desired inventory) and spit out a report. The uploaded file contains a SKU (Numerical identifier), Description, Quantity, etc.. The database will contain the same SKU and a "desired quantity" Once the report is generated the store will know what items to order based on the difference between the uploaded "on hand inventory" and the "desired on hand" database. (For example the desired inventory may state 5 Cases and the on hand inventory displays only 3 Cases. The user would know they need to order 2 more.) I would like one single login but multiple datbases for each store. (Each store will have their own "desired on hand inventory" and their own current inventory) Stores can select their location through a drop down menu (or an alternative if you think of a better option) The store selection should look something like this: Province Alberta British Columbia Ontario Quebec If Alberta is selected: Edmonton North Edmonton South Calgary Central Calgary South If Calgary Central is selected choose store: Store1 Store2 Store3 Once a user selected their location they can be prompted to view the last difference report or upload a new On Hand file. I would prefer if the page could display the date and time the last On Hand file was successfully uploaded. I would like the ability to run a report to see which stores are using the application. This could be done in a number of ways: Which stores have uploaded their On Hand inventory recently / which stores have Generated a Difference Report lately. What percentage of stores in each region are using the application (in the last month perhaps) Which Provinces are using the application. Perhaps a drilled down pivot report would work best for this.
Writer is a powerful online word processor, designed for collaborative work.