📘 Demurrage Audit Report (DEM003_REP) – User Manual
Version: V.1.0.32
Prepared by: M. Karthikeyan
Date: 04/11/2025

📁 Table of Contents

1. Introduction

2. System Requirements

3. Logging In

4. Main Features and Functions
    4.1 Accessing the Report
    4.2 Report Filters
    4.3 Report Data Logic
    4.4 Output and Export Options

5. Troubleshooting Common Issues

6. FAQs

7. Support

🔹 1. Introduction
The Demurrage Audit Report (DEM003_REP) provides detailed visibility into container movements and related rental activities.
It consolidates data from multiple sources to help audit demurrage-related transactions efficiently and ensure accurate revenue recognition.

🔸 2. System Requirements
Browser: Chrome 90+ / Firefox 85+
User Role: Admin / Users with access to the Reports module

🔐 3. Logging In

1. Navigate to the application login page.

2. Enter your authorized credentials.

3. From the main dashboard, go to Overview → Reports → Demurrage Audit Report (DEM003_REP).
   
   

⚙️ 4. Main Features and Functions

🧾 4.1 Accessing the Report

• Navigate to Reports → Demurrage Audit Report (DEM003_REP).

• The report can be generated based on user-specified filters such as From Date / To Date, Company, and Container Type.

• Click Generate Report to view results.

🎯 4.2 Report Filters
Use the available filters to refine the report results:

📊 4.3 Report Data Logic
The report retrieves container movement records from the INVENTORY_TRACKING table and joins them with CONTAINER_RENTAL_DETAILS only when:

• A corresponding rental record exists.

• The Charge Type is marked as REVENUE.

• The rental record is not deleted.

Only active records are included in the final output.

Movement types considered in this report include:

• PLOTIN

• DSTUFF

• OFFHIRE

• PORTIN

• EMPTY GATE IN

• OFFHIRE DAMAGE

• OFFHIRE IN

📤 4.4 Output and Export Options

• Once generated, the report displays container-wise movement and rental details.

• Use the Export option to download data in Excel or PDF format for review or submission.

• Users can also apply on-screen filters for quick data comparison.

🛠️ 5. Troubleshooting Common Issues

❓ 6. FAQs

Q: Can I generate this report without selecting filters?
A: Yes. The system will display all active container movement records based on available rental details by default.

Q: Why are some containers missing rental data?
A: Rental details appear only if a valid rental record exists and meets the inclusion criteria.

Q: Can I customize the date format or columns in the export?
A: The export follows the system’s standard format; customization is not supported in this version.

🏠 7. Support
For further assistance, contact:
📧 helpdesk@aggrandizeventure.zohodesk.in