Database
We are trying to get a data base program( may be MS access?) made for running all aspects of our business in technology items buy and sell.
Basic functions are RFQs, QUOTES , ORDERS, RECEIVING and SHIPPING function (warehousing ) etc, both from customer and to Vendors. We do use variety of Spread sheets now to do this. We should be able to feed these sheets and program should be able to pull in data and store in respective locations for past data loading up.
inputs are such spreadsheets , vendor list, item list etc from QB, custom input forms (scanning is may be in future) , Outputs are reports, RFQs Orders, ship labels, Commercial Invoices , Bill of lading etc…..just name some. Few users (need not be simultaneously accessing) will have assignable by administrator, access to data and fields.(ex. shipping will not see quotes etc. Data need to exported to Quick book for initiate paying vendors and Invoicing customers once activity finished. Item Cells may have link to specification sheets and web links, scanned documents etc, notes. Safety error proofing at many places cautioning with pop ups and or restricting illegal entries will be there to add. It may be hard to explain all in advance but may be flexible enough to accommodate.
