Variance Report between uploaded file and database contents

Variance Report between uploaded file and database contents

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.


Budget : $100.00 | Duration : 5 days

To leave a private message, please click the link for private response in post Action section. Download Attachments

    Zoho Desk Resources

    • Desk Community Learning Series


    • Digest


    • Functions


    • Meetups


    • Kbase


    • Resources


    • Glossary


    • Desk Marketplace


    • MVP Corner


    • Word of the Day


      Zoho CRM Plus Resources

        Zoho Books Resources


          Zoho Subscriptions Resources

            Zoho Projects Resources


              Zoho Sprints Resources


                Zoho Orchestly Resources


                  Zoho Creator Resources


                    Zoho WorkDrive Resources



                      Zoho Campaigns Resources

                        Zoho CRM Resources

                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner




                          Zoho Writer Writer

                          Get Started. Write Away!

                          Writer is a powerful online word processor, designed for collaborative work.

                            Zoho CRM コンテンツ




                              ご検討中の方