|
This Product Requisition and Purchasing System was built for a UK retailer with multiple high-street outlets. It enables end-users at various locations within the enterprise to requisition products from an online catalogue.
Requisitions are checked by a central purchasing unit whose personnel can choose to satisfy the users' requisitions from stock held internally or submit an order to an outside supplier for direct delivery. The system thus enables end-users to easily requisition supplies while ensuring that the company's relations with outside suppliers are handled centrally.
The system is fully forms-based with a rich Graphical User Interface. Built using a modern J2EE-compliant architecture and XML, it runs over an intranet or the Internet, on Linux using Oracle's 9i database.
The system can be customised to meet the additional requirements of an enterprise and to work with different databases.
There are three main parts to the system: setting up the catalogue and locations; submission of requisitions; and processing of requisitions.
Setting up the Catalogue and Locations
Authorised administrators are able to define locations, suppliers, products and end-users. Products can be grouped and ranged to locations. Suppliers can be associated with the locations they are willing to supply. Multiple suppliers can be associated with a product. Consequently, end users within a department are presented with a catalogue view tailored specifically to their needs. Super-users can be defined who can have multiple views of the catalogue.
Submission of Requisitions
End-users log onto the system and are presented with a view of the catalogue. From this catalogue they can submit requisitions for products. They can also identify products ordered on a cyclical basis as part of their favourites list together with default quantities. They can subsequently order products directly from their favourites list instead of the full catalogue.
Processing of Requisitions
At any time, authorised staff in the central purchasing unit can process outstanding requisitions, selectively by product or supplier if desired. Purchase orders are generated in XML format, and can be customised to permit EDI with suppliers. On delivery, end-users acknowledge receipt of orders, thereby facilitating reconciliation by the accounting staff.
 |
A fully web-based application with a sophisticated forms-based GUI |
|
Server-side: runs on Linux, Windows, Unix or any other server-side platform capable of running a J2EE-compliant web application server (eg. Tomcat, Websphere, Weblogic, JBOSS) |
|
Client-side: deploys to any desktop with a browser and Sun Microsystem's JRE 1.4.1 or 1.5.x. Screen mapping and data-handling is performed by a single low-footprint applet within a browser which, once loaded is cached for future use. |
|
Database: Built using Oracle 9i. Can be adapted for any JDBC compliant SQL database |
|
Native support for multi-lingual operations. |
|
