Seeking a reliable developer to modify existing purchase order website. The updates and enhancements will require some database updates and retrieves. The site is fully funcitonal and operational
Make sure to read detailed requirements request below before posting questions or bidding.
## Deliverables
1. Create audit trail of transactions - each time a purchase order is approved, copy data to a detailed database creating a transaction history (this is to happen at several approval levels in the work flow) e.g. staff creates p.o., supervisor approves, manager approves, cfo approves, gen manager approves.
2. Add second Item # field to purchase order database for internal use "Stores/Warehouse Item #"
3. Send email to warehouse to input item # every time a p.o. is created.
This item number should be visible on all purchase order detail screens/views.
4. Create a receiver pages for Warehouse/Stores department. i.e. Based upon each purchase order and related detail, create a view to include all purchase order line items along with the following fields:
? ? ? ? a. vendor invoice reference
? ? ? ? b. quantity received
? ? ? ? c. per unit price (per invoice)
? ? ? ? d. line total (b * c)
? ? ? ? e. insurance and freight costs
? ? ? ? f. duties/taxes
? ? ? ? g. date received
? ? ? ? h. goods received by (pull from user name)
? ? ? ? g. goods? inspected? (drop? list of approvers? or input manually)
? ? ? ? h. currency selection
This can be a modified copy? of the current purchase order view screen
5. Add p.o. reference detail to website link? in notification? emails so that approvers can click and go directly to the approval page for the? p.o. in question
6.? Change the current "delete p.o." function to "dim/hide" p.o. i.e.? rather than deleting related data from the database,? the info is dimmed on website when viewed or hidden. However, the system retains the transaction? history
7. Record? who deletes a p.o. and prompt? user deleting p.o. with a text box asking for reason. This should be recorded in database and viewable as part of p.o. comments for future reference.
8. Create an action items screen for "p.o's awaiting my approval" for all? approvers
9. Fix small bug on "received button". slight database? write error. "type mismatch" 1 line
10. User profile - update password - change current password view to show as **** rather than alpha-numeric characters
11. Add p.o. screen? currently asks the user for a job code. Job code list only shows numbers. Need to add? descriptions next to job numbers.
12.? ? The p.o. system currently? shows? (over)/under budget amounts.? If a p.o.? job is over? budget,? I would like to have the p.o. flagged on the approvers screen. i.e.? p.o.? selection should be colored red or show a warning flag somewhere on screen
13. Create? a? response screen that requires user to enter print paper? stock #? each time a p.o. is printed (i.e. the paper stock is pre-numbered. each time a p.o. is printed it? needs to be printed on unique paper stock. The number is to be tracked). Alternatively, the user can select print copy where the approval signatures will not print. A print stock # cannot be used more than once. Therefore it needs to enter database and a match query should run before accepting. Generate warning message is matched otherwise, print
14.? Currently, the system prints user names as registered on the p.o. to signify who approved the p.o.? I need to replace with signature images (real signature images? will be updated by client).? each user will have own image. therefore, need to update admin functions to include link or name of file to user signature image for each user
15.? Record last 2 levels of approval on purchase order (i.e. CFO and GM). Currently, only GM is kept in the database, but based upon item 1 above, the CFO can also be retrieved and printed on p.o.