In Progress

Microsoft Access Inventory/Sales Database (track inventory, costs, sales and illustrate data)

Below are the basics of what we would like the program to include. Uploading information from excel should be easy to do. Feel free to ask questions and provide your previous Microsoft access sample work.

Budget is $200-350

Cheers,

Add inventory/Purchase Order

___________________________

Item Number (Our internal SKU)

Description (Model, Manufacture, Stock Type- New, Used, Open Box, etc)

Unit Price (must have the ability to average out costing, FIFO)

Quantity

Tax Paid (Our tax is not a set amount, it varies across business operations and stock origin)

Vendor Name & Address

Location (Different warehouses)

Basics: Order Number, Date, Subtotal, Total, Receive & Pay button to confirm, Additional Information Field

Extras: Ability to scan a serial or UPC and have the Item Number automatically generate as a match

Extras: Non-Vendor Costs/Commission field to incorporate this cost into the average unit cost

~ everything to auto populate in correlating summary fields and show history of doing so +/- stock into an Inventory Summary Page showing Item Number, Description, Location, Quantity and current average costing. Summary fields are able to be manually changed if inventory adjustments are needed

Inventory to always be manipulated and organized by 1. Item number (stock option) 2. Manufacture brand 3. Model 4. Quantity 5. Days in inventory

~ ability to upload all existing data on an excel document to input on both inventory and sales sides, this will be used weekly for inputting our ecommerce sales

Sales

_____

Basic Version: List products sold at what price, date, quantity, customer, address, location, payment status (unpaid, paid, partially paid), order number, tax (make custom amount or ability to input formula),

Advanced Version: Summary sheet to list products sold at what price, date, quantity, customer, address, location, payment status (unpaid, paid, partially paid), order number, tax (make custom amount or ability to input formula), columns which can be summed up to be in a total column

Administration

_____________

Ability to easily extract data both manual and automatically (sales, profit, cost, warehouse) to produce charts, for tax purpose, etc

Multi-user capability to limit access to some users if required (limit customer names, supplier names, sales, charts )

Skills: Microsoft Access

See more: sales inventory database access, sales inventory database, access sales database, access inventory database, access inventory database free, access database sales inventory, access sales inventory, access sales inventory database, inventory sales database, access database inventory sales, microsoft access sales database, sales inventory access, sales database access, excel stock, sales database microsoft access, sample sales inventory database, basic sales inventory database, stock inventory database, stock inventory access database, inventory database access sample, free access stock database, free access sales inventory, free database track inventory, database sales inventory, microsoft access user inventory

About the Employer:
( 2 reviews ) Toronto, Canada

Project ID: #4374161

Awarded to:

jhaynes75

Professional software developer with over 13 years experience. Please see PM.

$385 USD in 10 days
(29 Reviews)
6.1

18 freelancers are bidding on average $321 for this job

kulhanekd

I have 15 years exp in access design and creation. I would like to bid. Donna

$350 USD in 5 days
(29 Reviews)
5.7
winnet21

Hi, I have experience with this project, I happily if work with you in this project. Best Regards

$300 USD in 13 days
(10 Reviews)
4.7
infoshree80

Having more than 12 years of experience in Ms access.Ready to start immediately. Please check PM

$299 USD in 20 days
(12 Reviews)
4.3
haseebhm

5+ years of Access/VBA experience.

$264 USD in 10 days
(5 Reviews)
3.2
srdas2012

Hi We are Expert Database Programmers we would like to do this.

$400 USD in 10 days
(2 Reviews)
2.1
sudewa

Hi, I m am keen to do the project and have good skills in form design and db design. You want to restrict users. For that I have the following solution. 1. Use the windows login name to differentiate the users. More

$400 USD in 5 days
(1 Review)
2.0
Reza2012

Hi I have more than nine years experience in database administration and development. I want to do the job and ensure better quality. Please see PM. Thanks.

$250 USD in 5 days
(1 Review)
1.7
SalimuddinSultan

Hi, I like to work on this project. I can do this within your budget 200 USD. Please view the private message to view the sample. Thanks, Salimuddin Sultan

$250 USD in 6 days
(1 Review)
1.6
BadihBarakat

VB.NET and Database Management expert at your service... Please, refer to my profile for previous projects, and check private message for more details...

$250 USD in 21 days
(2 Reviews)
1.0
nmlarsath

Lets Start. I have perfect skills and Experience to complete this project with 100% Accuracy and Quality. Please refer PM.

$260 USD in 7 days
(1 Review)
0.0
MaanKB

I am able to build you this tool

$275 USD in 4 days
(0 Reviews)
0.0
sbs85

Hi, I am an experienced IT Professional. Please feel free to contact in case you are interested in my bid. Cheers, Sbs85

$275 USD in 7 days
(0 Reviews)
0.0
Tablassus

More than 15 years of programming experience. Professional VBA solutions and webscraping, data mining and automated bots. Please check a few sample works in PM. Best regards Filipe Francisco , VB Expert =============== More

$302 USD in 7 days
(0 Reviews)
0.0
alltechworks

Very strong Ms Access Skills along with skills developing Business Software. Results Guarateed!

$500 USD in 10 days
(0 Reviews)
0.0
ManojV

We would like to do this project. please check your Inbox

$250 USD in 7 days
(0 Reviews)
0.0
grandmastersaxay

Will be able to provide you the best service within the time specified.

$275 USD in 7 days
(0 Reviews)
0.0
mrintelligence

Look for LIVE DEMO in PMB

$496 USD in 11 days
(0 Reviews)
0.0