Simple Purchase Order Entry Program

Closed

Description

Need a simple Purchase order entry system.

Purpose: To generate a report that 'rolls up' quantities of each product we offer from each purchase order to assist in production planning

Tool: I envision a spreadsheet that lists all of our products in which we can enter the quantity of each item ordered for a particular Purchase Order. There needs to be a place to include the PO #/customer name to check which POs have been loaded. The quantity of each item is kept in a database (I guess) and then the total quantity of each item can be accessed in a report so we know how much of each item we need to produce.

## Deliverables

I already hired a developer to create this program once before. If we ineffective because to enter each product, it had to be found using a pull-down menu. We have thousands of products, so that was extremely time consuming.

Therefore, what I need is the products listed in a spreadsheet format to allow me to easily find a product and put the quantity in the box next to it or something.

Product Information: My company makes children's swimwear. Most product styles have 10 sizes. Ideally, the way the spreadsheet would be set up is to have each style listed by name, color and style number in Column A of the spreadsheet. Then Column B would be the cell for size 1, Column C for size 2 etc up to size 10. That set-up would make the number of rows in the spreadsheet 1/10 of the total (for example 200 vs. 2000). I do not know if that is very difficult, but that would be the ideal. The 2nd option is of course to have each size of a style listed in a row and the quantity for a particular Purchase order entered manually in the column next to the style name.

Skills: Engineering, Excel, Microsoft Access, Microsoft Exchange, Powerpoint, Project Management, Software Architecture, Software Testing, Windows Desktop, Word

See more: put in production, purchase order number example, production tool, production spreadsheet, production management tool, i need to make production create, how to find a database developer, how to create database program, find a program, find a box developer, what is a po number, very ineffective, how to find a developer for a product, purchase, purchase order, purchase my, Production planning, place order, create purchase order, pos system database, example planning report, project report pos, create pos using 2010, simple purchase system, windows order

Project ID: #3638605

9 freelancers are bidding on average $272 for this job

mstechIN

See private message.

$216.75 USD in 14 days
(74 Reviews)
6.6
tonythksl

See private message.

$722.5 USD in 14 days
(102 Reviews)
6.1
solutionsauzlx

See private message.

$425 USD in 14 days
(38 Reviews)
5.6
iqmax99

See private message.

$11.05 USD in 14 days
(49 Reviews)
4.1
sunshinelabs

See private message.

$510 USD in 14 days
(9 Reviews)
3.9
mwstewart

See private message.

$297.5 USD in 14 days
(3 Reviews)
2.7
zshaan07

See private message.

$102 USD in 14 days
(3 Reviews)
1.2
molecularplane

See private message.

$106.25 USD in 14 days
(2 Reviews)
0.5
sudharshanamohan

See private message.

$59.5 USD in 14 days
(0 Reviews)
0.0