I need to build or customize a filemaker pro 11 database to work as an inventory control for our parts room. We have thousands of skews of various bearings, sprockets, electrical components, belts etc. which are all spare parts to various machines. Each item needs a barcode label and when scanned is found in the database and when confirmed as the correct part is removed from inventory. The database also needs to be searchable by part name, category, machine etc to find find parts. There should be re-order point alerts when a stock item get lows.
New items also need to be scanned into inventory and a label printed for it. If the item does not exist I would like a form to enter new item in the db.
The Filemaker inventory starter solution seems like a good place to start I just don't have the time to customize the scanning in and out of items or organize the workflow scripts.
Hello. Thanks for the invitation to bid. I am sure I can help you with this job. All you need is an inventory file? I am attaching some of my designs for you to get an idea.