Show Bid Request
MS Access Inventory Database Project Prototype
Bid Request Id: 15177
|
|
|
|
Posted by: |
Riquet1 (3 ratings)
(Software buyer rating 10)
|
|
Non-action Ratio: |
Very Good - 0.00%
|
|
Posted: |
May 1, 2002
5:53:28 PM EDT
|
|
Bidding Closes: |
May 8, 2002
5:59:37 PM EDT
|
|
Viewed (by coders): |
664 times
|
|
Deadline: |
5/13/2002
TIME EXPIRED
|
|
|
|
|
Description:
The system will eventually be ported to mysql. The front end will stay as Access, the backend (tables) will be moved to mysql tables.
Given the attached Inventory Database, the system must be able to:
1) Request for a User&'s First Name (which must be in the Employees table)
Use this User Id to save who entered the data along in the rest of the operations, Orders and Delivery and Inventory Adjustment Tables.
2) Orders -
a) When entering an Order, the Products Database must be updated as Received Inventory (the on-hand quantity must be increased)
b) The last received Order Number must be saved in the LastOrder field of the Products Table.
c) A printable totalized purchase invoice must be generated displaying the order details.
3) Deliveries -
a) When entering a Delivery Order, the Products Database must be updated as Received Inventory (the on-hand quantity must be decreased)
b) The last Delivery Order Number must be saved in the LastDelivery field of the Products Table.
c) A printable totalized Sales invoice must be generated displaying the order details.
d) A printable packing slip must be generated displaying the order details.
4) A manual inventory adjustment mechanism must be possible by using the Adjustments Table, in which the user can enter + or - quantities together with a comment in order to explain the reason of the manual adjustment.
5) An Inventory Report per Customer
6) A Delivery Report by Product
7) An Order Report by Product
8) An Inventory Adjustments / Log Report which includes a sequential history of all the operations on a Product.
The code must use SQL queries and statements, keeping in mind that the backend will be ported to mysql, so the tables will be “Attached” tables via mysqlodbc.
Deliverables:
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
Complete copyrights to all work purchased.
Platform:
Access 2000 with mysqlodbc connection to a mysql
database, running on Linux. The workstations have
Windows 98 / Access 2000.
Must be 100% finished and received by buyer on:
May 13, 2002 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.
Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.
Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements.
We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
|
|
|
Bidding/Comments:
|
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. |
See all rejected bids (and all comments)
| Name |
Bid Amount
|
Date |
Coder Rating |
|
|
This bid was accepted by the buyer!
|
$95 (USD)
|
May 2, 2002
1:16:17 AM EDT
|
9.9
(Excellent)
|
|
|
Hi there,
Please check on my profile and tell me if you're OK to start working together.
I understand very well your description and can start ASAP.
Regards,
A-Gun-G |
|
|
|
|
|
|
