Solutions
Enterprise Warehouse Management System
Enterprise Resource Planning System
Components
DataBase interoperability system
Event log system
Error processing system
Multilingual System
Printing system
Authorization and Authentication System
Database Extension System
Workflow Management System
Item Master System
Data Instantiation and Propagation System
Enterprise Warehouse Management System
The warehouse management system is designed for managing small, medium and large warehouses. A flexible configuration of the system ensures efficient management of the warehouses with various specialization levels (industrial, grocery, transit ones, etc).
Systems support a simultaneous operation of multiple warehouses on one server. System warehouse management is performed by General Manager and managers via Web interface. While configuring a warehouse, Manager can set the following system parameters:
- List of items, attributes and groups for each item
- List of locations, attributes and groups for each location
- Item, location and operator's compatibility
- Rules for placing goods within the warehouse
- List of managers and operators along with the enumeration of available business operations
The system consists of the following functional modules:
- Receiving. It registers goods in accordance with the invoice
- Allocation. Defines a set of cells for storing goods in compliance with Allocation rules
- Movement. Forms requests for goods movement inside the warehouse and controls the implementation of these requests by operators
- Shipment. Re-registers goods according to the shipping list
- Replenishment. Responsible for goods replenishment within the pick-up area
- Defrag. Defrag is a process that reduces items fragmentation in the warehouse
- Inventory. Inventory process performs the stocktaking operation. There are two types of stocktaking operations:
- Cycle counting
- Physical inventory
- Reports and Statistics. It provides more than 20 types of reports
Operators perform tasks related to moving the goods using RF terminals.
Basic system specifications are as follows:
- Up to 5 warehouses on one server (the quantity depends on the hardware server performance)
- Up to 30 RFT operators for each warehouse
- Up to 3 managers for each warehouse
- Up to 20000 transactions per day for each warehouse
- Web interface localization support for all European languages
- Supported DB: DB2, Oracle
- Supported Application servers: WebShphere™, Weblogic™, Jboss™, SunOne™
- Supported OS: AIX, Linux
- XML-based API for external ERP application
Enterprise Resource Planning System
Enterprise management system has been designed for small- and medium-scale enterprises (regardless of their specialization).
ERP consists of the following functional components:
- Financial system. It provides the following services:
- Cash Management
- Order Management and Shipping Execution
- Payables
- Projects
- Purchasing
- Property Manager
- Receivables
- Release Accounting
- Sales Compensation
- Sales and Marketing
- European Localizations
- Supply Chain System. It provides the following services:
- Advanced planning
- Advanced Supply chain planning
- Demand planning
- Global order promising
- Inventory optimization
- Supply Chain exchange
- Procurement
- Sourcing
- Purchasing
- Payables
- Manufacturing
- Process manufacturing
- Flow manufacturing
- Project manufacturing
- Bills of materials
- Production management
- Cost management
- Order fulfillment
- Order management
- Configurator
- Transportation
- Warehouse management
- Mobile supply chain
- Human Resources Management system
- Asset management
DataBase Interoperability System
The given component is designed for the flexible support of various databases. It enables to re-adjust the application for each particular database without the source code recompilation. All SQL requests are gathered in external XML files. Connection to RDBMS is performed via JDBC driver or the application's DataSource.
It is adapted for WebSphere™, Weblogic™, Jboss™, SunOne™ application servers.
Event Log System
The given EJB component is designed for asynchronous message logging that is based on
Log4J. It supports a flexible setup of logging rules for each category. All settings (rules, a category list) are stored in XML file. The component uses JMS queue to log messages from several clients. It supports outputting the logging information to a file, database, and console devices.
It is adapted for WebSphere™, Weblogic™, Jboss™, SunOne™ application servers.
Error Processing System
The given EJB component is designed for incorporating exception handling. It supports the processing of four basic types of exceptions: Unexpected exception, Handled exception, Internal exception, Assertion exception. It ensures error logging as well as the reception of localized error messages. The list of exceptions to be handled can be extended.
It is adapted for WebSphere™, Weblogic™, Jboss™, SunOne™ application servers.
Multilingual System
The given EJB component is designed for localizing the applications. The component provides:
- Support for the list of keys along with their values
- Visualization of Web, GUI, RFT interfaces within a specific locale
- Web interface for operating a list of keys and their values.
The list of keys is stored in the database. The component supports all European languages (8bit). It is adapted for WebSphere™, Weblogic™ and Jboss™, SunOne™ application servers.
Printing System
The given EJB component is designed for the purpose of printing by using lpd protocol.
The component provides:
- management (add, delete) of the list of system printers and their properties
- management of a printing task queue: add, delete, reorder priority, interrupt/resume
- reviewing and storing of the task queue in PDF format
- sending the task queue via e-mail in PDF format
- receiving data for printing in XML format
- forming a document layout on the basis of the rules preset in XSL format
- suspending the printing process
- sending a task copy via e-mail.
- Web interface for printers configuration and printing task management
It is adapted for WebSphere™, Weblogic™, Jboss™, SunOne™ application servers.
Authorization and Authentication System
The given component provides the following services:
- Users administration
- User groups administration
- Administration of a list of rights for business methods implementation.
- Assigning the rights for business methods implementation to user groups
- Quick verification of the rights for business methods implementation by using the embedded algorithm for caching the list of rights
It is adapted for WebSphere™, Weblogic™, Jboss™, SunOne™ application servers.
Database Extension System
The given EJB component enables to dinamically extend statical data structures in the enterprise applications. Extending structures are stored in automatically generated horizontal tables which gives a considerable advantage in performance over standard vertical tables. The component also provides interface for searching and selecting data within the extended data structures. Extended data structures are stored in the repository whose interface provides access for external applications. This enables to set up developed applications according to the needs of the client without any additional costs.
The Database Extension System performs four overall tasks:
- Gather and store the information about generating database tables that will be used as data extensions for standard DB tables.
- Generate the DDL that will create tables in the DB
- Register the new table(s) and respective field(s) in the Repository system in order to enable searching and extracting functionality for the extended data.
- Offer a flexible and dynamic method for displaying and maintaining the new data.
It is adapted for WebSphere™, Weblogic™, Jboss™, SunOne™ application servers.
Workflow Management System
The above EJB component is a simple system that provides an easy and quick automation of business processes' flows within the applications without the need for any programming changes to the enterprise system. The APM allows concatenating different activities in one operational flow that is executed by indicated users (roles).
From the operational point of view, the APM functions are basically divided into three groups:
- Modeling (Build-time). Capability to create the workflow process definition based on concepts of Activity Node and Activity Line. Process definition is accessible to the system from a configuration file in XML format. This file may be developed manually or by means of any XML editor that belongs to a third party.
- Execution (Run-time). The main run-time functions of APM subsystem are:
- Generation of activity instances according to the rules specified in the process definition and assigning them to appropriate performers.
- Delivery of the activities to assigned performers; to-do list and to-do list items processing support;
- Generating and dispatching to Supervisors alert messages about specific events (e.g. an activity completion);
- Monitoring features: managing to-do lists and reassigning activities to different performers;
- Audit and monitoring. Includes logging and alert messaging capabilities;
- Simulation. System provides the capability to build possible paths of the process execution according to a process definition and display the result graphically.
It is adapted for WebSphere™, Weblogic™, Jboss™, SunOne™ application servers.
Item Management System
The main purpose of the project is to manage the major entity of ERP system. Four components were developed as part of this project:
- Item Basic Dataset
- Entity Configurable Code
- Packaging Unit
- Hierarchical Access to Functional Daatasets
Item Basic Dataset
This subsystem is intended for managing a major ERP system's entity: an item.
This subsystem is based on the use of the subsystems that are defined below.
Entity Configurable Code
This subsystem is intended for setting a unique code in accordance with predefined rules. The rules are specified in XML format and involve specifying the code by parts (elements).
Every code part can consist of several types. Alignment and extra checks can be used for code elements (depending on an element type).
Packaging Unit
The Item Packaging Unit component enables to avoid the need to open different Item codes which are defined for the same item managed with different packaging units. This component is responsible for managing item packaging units and its different conversion factors (which can be fixed, variable or be based on the formula/relation between different Units of Measure defined for Item).
This subsystem is responsible for Unit of Measure management, too.
Hierarchical Access to Functional Dataset
The main purpose of this subsystem is to manage Functional Dataset that represents an extra set of data that correspond to a certain Item.
This subsystem is also intended for searching Functional DataSet on a multicriterion basis. A tree of rules is used for searching. Each new rule is created during the creation of a new instance of Functional DataSet.
It is adapted for WebSphere™, Weblogic™, Jboss™, SunOne™ application servers.
Data Instantiation and Propagation System
The main purpose of the project is an automatic data propagation. Hereunder is a list of major tasks that are solved within the framework of this project:
- java object instantiation: identifying (on the basis of incoming XML) the data of objects whose instances have to be created. An arbitrary object nesting level is permissible.
- java object population: identifying (on the basis of incoming XML) the data of the values of instantiated objects' properties and their installation.
- RPC with instantiated and populated objects (as passed parameters);
- Object's reverse conversion into XML.
Project's specific characteristics:
- the use of JMS Queue for the purpose of obtaining incoming XML data;
- multilevel XSLT-conversion of XML;
- the use of the internal JMS Queue for imitating the operation of Message Driven Bean;
- Obtained data management via Web interface.
It is adapted for WebSphere™, Weblogic™, Jboss™, SunOne™ application servers.