CREATE ORDER ENTRY PROGRAM IN ACCESS

IN PROGRESS
Bids
35
Avg Bid (USD)
$482
Project Budget (USD)
$250 - $750

Project Description:
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.

Skills required:
Microsoft Access, SQL
Additional Files: ebay Inventory Tracker Tables for FB.xlsx Order Word.docx
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 555
in 5 days
$ 750
in 7 days
$ 250
in 7 days
$ 947
in 20 days
$ 526
in 25 days
Hire alekhine1962
$ 250
in 10 days
$ 684
in 10 days
$ 555
in 15 days
$ 400
in 10 days
Hire jawadaman
$ 250
in 10 days