I require a simple software program that allows me to track inventory on some products (there are about 5 total that I need to track, but I would like to have an "Add Product" option just in case.) When we receive inventory, I need to be able to input the amount received to update the current stock. Likewise when units are sold, I need to be able to subtract that from the inventory. Also, I would also like the option of putting in who I sold the product to, a record of the date, and their method paid (cash/check/credit). But the additional information would be optional for the user to input, with only the total sold of each product being required.
When the inventory of a product is less than a specified number, I need the program to automatically submit a new order to the supplier. I'd also like to have a View Inventory History option where I can see the amount sold/added on each day. (Basically just a dump of the inventory database.) Nothing too fancy is needed for this, as it's for a small business that only stocks around 50 units of each product. The reorder procedure is just a simple email to the manufacturer that says something like "Send # of Products" -- it's not a large manufacturer and I spoke with the owner earlier and he said email ordering is flexible. Lastly, I'd like this to update to a database of some sort on the local computer, but also have the option for the user to enter mysql information so that it could update to a website. (That could be useful for keeping a constant inventory if the program is loaded on multiple computers, and if a future web app is needed.)
Of course at the completion of this I'd own all rights to the code, and would need the code to be sent to me (So please comment it so I can follow along if something needs to be changed in the future.) I figure this is a pretty simple task and would rather pay someone here than someone in some random country. I started making it in vb.net I just don't know how to do the database functions. I'll attach a picture of the form I made, which could be a basis to work off of.
PM me if you're interested in making this, I'd need it by the middle of next week at the latest..but I'm sure someone here could whip this up in a night or a weekend.
I posted this on Rent a Coder but I don't want to hire someone foreign. I'd rather pay someone here, but I don't have much to spend. The bid I was going to accept on RAC was for $35 and was from an American, but he backed out last minute due to changing from Windows to Linux. I'd like to stay around that price range, but am open to bids.