Suljettu

Inventory Database

I have a MS ACCESS Based inventory database. I have built the table structure and most of the forms; I need someone to produce any necessary forms and code for the following functions:

Primary Components

-User System Logins etc

-Customer Orders

-Products

-Supply Orders

-Internal Customer Order Approval system : Forms Not Created Yet

-Internal Supply Order Approval System : Forms Not Created Yet

-Export Contact and Appointment Information to Personal Outlook File of the user.

APPROVAL SYSTEM SPECS:

APPROVING IN-COMING ORDERS

1. Department A Creates Order -Must be able to change line item prices and enter an amount in the QUOTED field that may be different from the SUBTOTAL or ESTIMATED value.

2. The order must then be approved by Department B. (Should be a YES or No…meaning, no back and fourth questioning)

3. The Order returns to Department A once approved/denied.

4. Department A marks order as sent and prints a Purchase Order and faxes or emails it the supplier.

5. STEP 4 updates the Product table ON ORDER field value.

6. Once product is received, Department A goes to the order and corrects any differences in number of items received verses ordered, and sets the value of the AMOUNT PAID.

7. Step 6 should update the product tables IN STOCK and ON ORDER values.

APPROVING OUTGOING ORDERS

**** Only orders with products in a specific category need to be go through the approval process. **** If at any stage, the order is not approved, it should go back to Department 1.

1. Department 1creates the Order

2. Order goes to Department 2 for Approval

3. Order goes to Department 3 For Approval

4. Order goes to Department 4 for Approval

5. Order returns to Department 1 for Processing : Prints Packing Slip

6. Once package has shipped Department 1 updates the SHIPPED DATE

7. Step 6 updates the product tables IN STOCK field value.

REPORTS

•Packing Slip for Customer Orders and a Standard Avery 5163 Shipping Label

•PO For Supply Orders

Aesthetics

Must use color scheme and design of form template provided

Winning bid will be the one who can do this with as little code as possible; need application to developed almost wholly in ACCESS, using STANDARD ACCESS TOOLS, some code is acceptable and assumed.

I always have Access work to outsource.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Complete ownership and distribution copyrights to all work purchased.

## Platform

Windows 98, 2000, and XP

ACCESS XP

## Deadline information

Beta to be complete by 10/17/02.

Any post beta corrections must be addressed/made/delivered within 24 hours.

Please speak good english.

Taidot: Tietokannan hallinto, tekniikka, MySQL, PHP, tietojärjestelmäarkkitehtuuri, Ohjelmistojen testaus, SQL, Visual Basic

Näytä lisää: product supplier database, products database design, product label design software, product design outsource, packing design software, package label design prices, package label design, outsource template design, outsource database design, outsource database application, outsource c# code, outsource basic code, on line supplier, on line stock supplier, not yet received, not received yet, need someone to design product package, n.c. department of corrections, ms access purchase order system, ms access purchase order database

Tietoa työnantajasta:
( 44 arvostelua ) Lancaster, United States

Projektin tunnus: #2874126

50 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

debihammel

See private message.

$85 USD 14 päivässä
(39 arvostelua)
6.5
kna125

See private message.

$85 USD 14 päivässä
(40 arvostelua)
5.9
creativexso

See private message.

$85 USD 14 päivässä
(81 arvostelua)
5.9
danvlas

See private message.

$85 USD 14 päivässä
(74 arvostelua)
5.6
DrumLin

See private message.

$85 USD 14 päivässä
(34 arvostelua)
5.4
sanatanvw

See private message.

$85 USD 14 päivässä
(72 arvostelua)
5.5
miguelgarcia78

See private message.

$85 USD 14 päivässä
(76 arvostelua)
5.2
kuulest

See private message.

$85 USD 14 päivässä
(16 arvostelua)
4.5
MGrassman

See private message.

$85 USD 14 päivässä
(6 arvostelua)
4.1
zabashta

See private message.

$85 USD 14 päivässä
(5 arvostelua)
4.0
georgegraff

See private message.

$85 USD 14 päivässä
(20 arvostelua)
4.0
techfortsystems

See private message.

$85 USD 14 päivässä
(9 arvostelua)
4.3
crucialcode

See private message.

$85 USD 14 päivässä
(8 arvostelua)
3.9
emobadov

See private message.

$85 USD 14 päivässä
(14 arvostelua)
3.8
webffiliates

See private message.

$85 USD 14 päivässä
(19 arvostelua)
3.7
simplycreativevw

See private message.

$85 USD 14 päivässä
(8 arvostelua)
3.2
rryerson

See private message.

$85 USD 14 päivässä
(6 arvostelua)
2.9
abhishek16978

See private message.

$85 USD 14 päivässä
(14 arvostelua)
2.9
bradmoore

See private message.

$85 USD 14 päivässä
(3 arvostelua)
2.7
ulu

See private message.

$85 USD 14 päivässä
(2 arvostelua)
2.7