CREATE ORDER ENTRY PROGRAM IN ACCESS
$250-750 USD
Paid on delivery
We operate a number of websites and ebay stores. We don't make a lot of money so we don't want to invest in a multi-channel online system. We sell both inventory that we have and drop shipping.
We need an access database which will allow us to enter orders - in two currencies, track the customer information, order information (products purchased, quantity, what site the order came from) and the taxes. We also need to track when the order was placed with one of our vendors (date), shipping information (date shipped, method, tracking #). Shipping cost to customer needs to be set up as well.
We also need to be able to produce an invoice; and the invoice # has to be automatically generated. The invoice needs to relate to the source of the sale (i.e. we only own one company but need to produce an invoice based on the website it was purchased from - so we need to either select the invoice report (there should be 4 of these), OR the source of the order, automatically identifies the invoice produced.
We need to be able to produce pick lists and maintain an inventory of actual items we have in stock. Product Code, Product Description, Selling Price and Quantity on Hand. We would like to override the selling price, as we have items which sell for different prices on different sites.
I've attached a word document with more information and an excel file showing the tables that need to be created.
Project ID: #5726159
About the project
32 freelancers are bidding on average $489 for this job
Hello DISCOUNTWIG , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Micros More
Dear Buyer, I have been working with Access databases since 1998 ... I have gone through your attached documents. Both are really descriptive about your requirements ... About the selection of Company Name / Logo More
Hi, I'm very interested helping you creating your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfol More
You need an MS SQL Database setup using .NET, NOT Access...MSSQL is "Access' Big Brother" You can get a 1-year free Amazon AWS account that will let you have an MSSQL server and web server if you don't already have More
Hello, I can develop your application. I'm a Freelance With 10 Years of Experience In Developing Applications On Ms Access For Small, Medium And Large Companies For Public And Private Sector.
Respected Sir, I read what you want do this project... Me and my team ready for you.. I hope from your side.. Pyramid Group (Ankit Barot)
I would very much like to do this for you as I have set up many databases for people to use. I would love to work on this for you and I am available shortly.
Hi I'm doing Custom Inventory Applications development for vendors here. I almost have your requirement completed. It included Purchase, Purchase Return, Sales, Sales Return, Product details Entry, Customer & Supplier More
Hello I can do the project, if you like I cant build a prototype, then I'll send it for your evaluation. I hope you choose my offer. Regards. Jose Mendoza
Hi, I have an excellent solution for you. How would you like a web based application (that works great on any internet browser and doesn't ask you install any heavy components on your machine), with Oracle database More