Physical Inventory

I need a VB program that will import a list of items from a sql database or validate the items against the database so when recording the counts, the item numbers entered are real item numbers. The program will also have to record the physical counts and bins from items that could be on more than one inventory tag. Then total all counts for a given item number and export that to an excel spreadsheet. There are 2 companies in my database 1 & 2 with various locations for each Co. I would like the ability to choose which company/location I am recording the count for. Each company/location would hold its own set of items & counts. I would like program to use its own sql database and I could link the item numbers to it or we could simply add necessary tables to our existing database. It would be good if there was an option to set a connection to the database in the program so could use it with our test systems as well. I can provide a "mock database" that has the exact same structure as our production database if necessary. Summarizing: the program would need to record: Company Id (ability to default this) Warehouse Location ID (ability to default this) Quantity Unit of Measure (Drop down list) Item Number (Validated as an item with-in the production database) Description (should pull from the item record) Bin Location Tag Number (unique by company) As long as the data can stored in a table or tables, either with in our production database or in one of its own (I can link tables from the production DB) I won't need the excel export. Otherwise I would need to export it to excel. The reports that I will need to produce will be a summery of counts per item and a detail of counts by item, listing all tags and bins that made up the count. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform windows 2000