Project

General

Profile

Actions

Task #19837

open

Task #19866: Sprint Planning for 12/05/2026- 26/05/2026

Air Clearing File Management (Import & Export)

Added by Redmine Admin 4 months ago. Updated 3 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Start date:
05/04/2026
Due date:
05/04/2026 (about 4 months late)
% Done:

0%

Estimated time:
0:00 h
GitLab ID:
4360
GitLab Milestone:
GitLab Ticket Number:
1494
GitLab Time Logged:
0
Lock Timeline Date:
No
gitlab project trace:
Sprint Planning for 12/05/2026- 26/05/2026

Description

Epic Goal

To design and implement a complete Air Clearing Module within MFreight that enables users to:

  • Create, manage, and process Air Clearing Files
  • Handle both Import and Export shipments
  • Maintain full operational traceability through Activity Logs

The module must support creation from:

  • Existing HAWB (House Air Waybill)
  • Existing MAWB (Master Air Waybill)
  • Existing Quotation
  • Or manual creation (from scratch)

Business Context

In air freight:

  • MAWB (Master Air Waybill) = Airline shipment (master level)
  • HAWB (House Air Waybill) = Shipment per customer (house level)
  • A single MAWB can contain multiple HAWBs
  • Clearing is the process of:
    • Declaring goods to customs
    • Paying duties/taxes
    • Getting cargo released

A Clearing File is used internally by freight forwarders to:

  • Track customs processing
  • Manage charges (cost & sales)
  • Store shipment & party information
  • Record BOE (Bill of Entry)
  • Maintain audit trail of all actions (Activity Log)

Scope of the Epic

1. Clearing File Creation

System must allow creation of a clearing file using:

  • Existing HAWB
  • Existing MAWB
  • Existing Quotation
  • Manual entry
2. Shipment Types
  • Air Import
  • Air Export
3. Core Functional Areas
A. Retrieve / Search Clearing Files
  • Search by:
    • HAWB No.
    • MAWB No.
    • Clearing Reference
    • Airline
    • Flight No.
    • BOE Reference
    • Status
    • Date Range
B. Clearing File Management
  • Create
  • View
  • Update
  • Save
  • Status tracking
C. Shipment Information

Capture and manage:

  • MAWB / HAWB details
  • Airports (Origin / Destination / Transit)
  • Flight details
  • Shipment type (Import / Export)
D. Party Information
  • Shipper
  • Consignee
  • Notify Party
  • Delivery Agent
E. BOE Management
  • One Clearing File can have multiple BOEs
  • BOE details must be captured and allow update
F. Cost & Sales Management
  • Record operational costs
  • Record customer billing (sales)
  • Support multiple charges
G. Document Management
  • Upload
  • View
H. Workflow & Status Management

Statuses include:

Draft → Confirmed → Closed

Confirmed → Draft

Cancel → Cancelled

I. Activity Log

A section/screen showing system-generated logs.

Columns:

  • Activity Date & Time
  • Activity By (User)
  • Activity Description

Key Functional Rules

1. Creation Logic
  • From HAWB → auto-populate data
  • From MAWB → allow future expansion
  • From Quotation → fetch commercial data
  • From scratch → manual entry
2. BOE Logic
  • Multiple BOEs per clearing file
  • Each BOE independent
3. Data Integrity
  • Clearing Reference must be unique
  • Required fields enforced
  • AWB format validation
4. Terminology Replacement
Ocean Air
Vessel Airline
Voyage Flight
Port Airport
BL AWB
HBL HAWB
MBL MAWB

User Roles

  • Allow permissions to view only, operations level, supervisor level for approval.

Epic-Level Acceptance Criteria

  • User can create clearing file using all 4 methods
  • Supports Air Import & Export
  • Multiple BOEs supported
  • Costs & Sales can be captured
  • Documents can be uploaded
  • Status workflow works correctly
  • Activity Log captures all system & manual actions
  • Activity Log is present and updated everytime

Dependencies

  • Air Shipment Module (HAWB / MAWB)
  • Quotation Module
  • Customer & Supplier Master—Shipper, consignee, notify, agent
  • Charges Module
  • Flight Scedule Module

Technical Considerations

  • Reuse Ocean Clearing architecture
  • Create separate Activity Log table for Air

GitLab Sync Log

[]

Actions #1

Updated by Redmine Admin 4 months ago

  • GitLab Sync Log updated (diff)
Actions #2

Updated by Redmine Admin 4 months ago

  • Parent task set to #19866
  • gitlab project trace set to Sprint Planning for 12/05/2026- 26/05/2026
Actions #3

Updated by Redmine Admin 4 months ago

  • Description updated (diff)
Actions

Also available in: Atom PDF