CREATE ORDER ENTRY PROGRAM IN ACCESS
This project was successfully completed by expertcoder1vw for $250 USD in 7 days.Get free quotes for a project like this
Project Budget$250 - $750 USD
Completed In7 days
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online