Further development of a logistics application for imports
Project duration: 1 year
Brief description
The aim of the project is to further develop software for processing logistics and ordering at a commercial enterprise that is active throughout Europe. The application replaces an Excel-based process and enables integration in the existing system landscape and the automation of manual processes.
Supplement
The software communicates with higher-level and assisting systems via XML interfaces within the Oracle database and the .NET application. Only PL/SQL is used on the database side. The database procedures implement access security at the logical level by checking statuses for each access. The application dialogs implement a complex business logic for entering and visualizing the order quantities and the check results in control elements structured programmatically and dynamically. The user interface is based on Windows Forms, supported by customer-specific, database-oriented libraries based on SandDock and ComponentOne components. The system is also internationalized via the customer’s database-supported libraries.
Subject description
The application primarily supports ordering, in addition to master data management. The purchase orders themselves are generated from freely editable templates. The templates define order and delivery times, as well as the allocation of suppliers and items. Additional restrictions can be defined at all levels and compliance with these restrictions is monitored. All parameters from the template can be modified in the purchase order that is generated. Historical sale data and stocks are imported from an external system during runtime. This data is displayed to the scheduler during the order process to support the scheduler and it is used to automatically propose order quantities. The proposed quantities are determined from the stocks and the desired range, taking account of restrictions from the various levels of the purchase order. Order quantities are transferred to the higher-level and operational systems for triggering purchase orders or for warehouse management.