ERM Weighing application

ERM Weighing Application

ERM Weighing Application is a custom-developed industrial weighing and truck management system designed for Ezz Steel Rolling Mills to automate and control the complete weighing process from truck entry to final transaction completion.

The application integrates the weighbridge, ERP/Oracle database, industrial cameras, QR/Delivery Note workflow, local transaction storage, and printing system into a single centralized software solution.

Key Features

- Automated Weighbridge Management

Handles both inbound and outbound truck weighing operations, including Gross, Tare, and Net weight calculation.

- ERP / Oracle Integration

Directly communicates with the existing ERP database to retrieve and register delivery-note and weighing transaction data.

- QR / Delivery Note Management

Generates and manages unique transaction identifiers and Delivery Notes, allowing the operator to quickly retrieve pending weighing transactions during the second weighing stage.

- Truck Identification & Photo Capture

Integrated with industrial network cameras to automatically capture truck images during the weighing process for traceability and transaction verification.

- Offline Transaction Handling

Uses a local SQLite database to temporarily store pending transactions, ensuring that the weighing process can continue safely in case of temporary database/network interruptions.

- Automatic Net Weight Calculation

Calculates the absolute difference between the two weighing stages while applying configured operational limits and validation rules.

- Transaction Validation

Includes weight-limit checks, transaction-state validation, duplicate prevention, and operational safeguards to reduce human errors.

- Integrated Printing

Automatically generates and prints weighing documents and transaction information after successful completion.

- Configuration-Based Architecture

Scale IDs, camera addresses, database connections, storage paths, and other operational parameters can be managed through configuration files without modifying the application source code.

- Industrial User Interface

Designed specifically for weighbridge operators, providing a simple and controlled workflow suitable for continuous industrial operation.

System Architecture

The application acts as an integration layer between multiple systems:

Weighbridge → RM Weighing Application → Oracle / ERP

with additional integration to:

Industrial Cameras → Photo Archive

SQLite → Pending Transactions

Printer → Weighing Documents

Operational Workflow

1. Create or retrieve the Delivery Note.

2. Perform the first weighing operation.

3. Record the Gross/Tare weight according to the transaction type.

4. Capture truck images.

5. Store the transaction locally when required.

6. Perform the second weighing operation.

7. Retrieve and validate the pending transaction.

8. Calculate the final Net Weight.

9. Commit the completed transaction to the ERP/Oracle system.

10. Print the final weighing document.

11. Archive the associated truck images for traceability.

Development

The system was designed and developed in-house using C# and .NET Windows Forms, with Oracle database integration, SQLite local storage, industrial camera integration, and dedicated printing functionality.

Developed and coded by: Eng. Mohamed Tarek Bakr

Company: Ezz Steel Rolling Mills