Show Bid Request Inventory Database Bid Request Id: 29685 Bookmark in my 'To Do' list Posted by: TheDarin (0 ratings) Non-action Ratio: Above Average - 25.00% Buyer Security Verifications: Good Approved on: Oct 3, 2002 2:09:14 PM EDT Bidding Closes: Nov 1, 2002 3:13:40 PM EDT Viewed (by coders): 1290 times Deadline: 11/5/2002 TIME EXPIRED Phase: Cancelled Max Accepted Bid: Bidding is closed Project Type: Small Business Project: $100 (USD) + Bidding Type: Open Auction Categories: Database, Visual Basic Enter chat room for this bid request (0 active users at Jul 31, 2003 6:54:56 AM EDT) Description: 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&#8230;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 &#8226;Packing Slip for Customer Orders and a Standard Avery 5163 Shipping Label &#8226;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 Must be 100% finished and received by buyer on: Nov 5, 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. Special Conditions / Other: Beta to be complete by 10/17/02. Any post beta corrections must be addressed/made/delivered within 24 hours. Please speak good english. 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   No bidding allowed, because this bid request was cancelled. Cancelled Date: 11/11/2002 12:48:24 PM