Logistics and Freight Management System
- Haytham A. Mahmoud
- Freight & Logistics Management System
- Web Application Development
This system is a comprehensive tool for managing international and local freight operations, whether by sea, air, or land. It is designed to assist logistics and transportation teams in tracking and organizing job files, managing quotations, recording documents, and monitoring financial performance.
1. Contracts Management
Register and organize shipping contracts with clients and suppliers.
• Create new contracts (sales or purchase).
• Define contract type, start date, and end date.
• Link contracts to clients, business activities, and responsible departments.
• Track contract status (active, expired, canceled).
• Support demurrage pricing by currency and unit.
2. Quotations & Offers
Prepare and submit price quotations to customers.
• Create quotations including services, prices, and terms.
• Set quotation validity period.
• Link quotations to clients, shipping type (INCOTERMS), and payment method.
• Attach supporting documents or notes.
3. Job Files / Operations Management
Track every shipment from origin to delivery.
• Open a job file for each shipment (goods from origin to destination).
• Record shipment details: commodity, quantity, weight, volume (CBM), number of containers.
• Specify transport mode (sea, air, road) and carrier (shipping line / airline).
• Record key dates:
• Estimated Time of Departure (ETD), Estimated Time of Arrival (ETA).
• Actual Time of Departure (ATD), Actual Time of Arrival (ATA).
• Link the job file to driver, truck, and customs documents.
4. Documents Management
Organize receivable and payable documents (invoices, credit notes, etc.).
• Record documents by type (Invoice, Credit Note, Debit Note).
• Link documents to the shipment file, client, and provided service.
• Support linking of customs documents (declaration number, date).
• Track due dates for payment monitoring.
5. Contacts & Commodities Management
Build a database of clients and the types of goods they ship.
• Register client details (name, address, contact person).
• Link each client to the types of commodities they ship (e.g., furniture, food, chemicals).
• Classify clients by activity or department.
6. Transport & Locations Management
Categorize transportation modes and logistics facilities.
• Manage airlines and shipping lines.
• Manage airports, seaports, cities, and countries.
• Classify container types (FCL/LCL) and truck types (FTL/LTL).
• Record packaging details (Packing Type) and loading method.
7. Tracking & Status Monitoring
Monitor shipment status in real time.
• Update shipment status (loading, in transit, arrived, delivered).
• Record delivery details (who received, when, delivery number).
• Monitor demurrage at origin or destination.
• Add notes for each stage of the shipment process.
8. Reporting & Analytics
Evaluate financial and operational performance.
• Track number of job files, number of clients, and total profits.
• Calculate chargeable weight, number of containers (TEUs), and total shipment value.
• Analyze gross profit by department or business activity.
9. User & Permissions Management
Control who can enter or modify data.
• Register system users.
• Track who created or updated each record (Insert User, Update User, timestamps).
Summary: What Will Users Do in the System?
Role Main Tasks
Operations Coordinator Open shipment files, enter dates, track status, upload documents.
Sales Officer Prepare quotations, link them to clients and contracts.
Accountant Record invoices, follow up on receivables, verify documents.
Logistics Supervisor Monitor shipments, verify delivery, track delays.
Manager View reports, analyze profits, review performance.
Additional System Features
• Support for multiple currencies and exchange rates.
• Consolidation management (grouping shipments).
• Ability to link job files (e.g., linking main and subshipments).
• Option to enter data for unregistered clients.