Docs
ERP Crystal
MFG
Manufacturing
Reports
Advance License Analysis Report

Advance License Analysis Report

Advance License Analysis Report - User Guide

1. Introduction 🌍

For manufacturing units involved in international trade, the Advance License (AL) is a critical financial instrument. It allows for the duty-free import of raw materials required for the production of export goods. However, this comes with strict Export Obligations (EO) and time-bound utilization rules. The Advance License Analysis Report is the dedicated compliance engine that tracks these legal obligations in real-time.

ℹī¸

Purpose of this Report:

  • Export Obligation Tracking: Ensure that your actual exports meet the mandated value and quantity defined in each license.
  • Import Quota Monitoring: Track how much duty-free material is left to be imported before the license expires.
  • Regulatory Compliance: Provide accurate data for license “Redemption” or “Closure” to the DGFT/Statutory bodies.
  • Financial Risk Management: Avoid penalties and interest by tracking license expiry dates for both imports and exports.

This report is essential for Export-Import (EXIM) Managers, Logistics Leads, and CFOs.

2. Report Modules 🚀

A. License Register

  • The Master Record: Provides a full directory of all licenses (Applied, Received, or Closed).
  • Financials: Tracks FOB (Free On Board) and CIF (Cost, Insurance, and Freight) values in both USD and INR.
  • Validity: Highlights the critical “Import Expiry” and “Export Expiry” dates.

B. Export Analysis (Duty Fulfillment)

  • Obligation vs. Performance: Compares the “License Quantity” against actual Sales Invoices.
  • Order Linking: Shows which specific Customer Orders have been “blocked” or “reserved” against the license to meet future obligations.
  • Balance Qty: Shows the remaining quantity required to be exported to “Close” the license.

C. Import Analysis (Raw Material Utilization)

  • Duty-Free Tracking: Monitors the actual receipt of raw materials (via GRNs) against the license’s import authorization.
  • Indent Linking: Tracks which Purchase Indents were raised using the “Duty-Free” quota.
  • Quota Balance: Prevents over-importing beyond the legal limit authorized by the government.

3. License Status Lifecycle 🔄

  1. Applied (A): Application submitted to the regulatory body.
  2. Received (R): License is active; duty-free imports can begin.
  3. Submitted (S): Documents sent for closure/redemption after meeting export goals.
  4. Closed (C): Export obligation met and license legally discharged.
  5. Expired (E): Validity date passed without meeting obligations (Risk of penalty).

4. Understanding Currency & Valuation 📊

Since international trade involves multiple currencies, the report tracks:

  • Export Currency Rate: The fixed exchange rate defined at the time of license issuance.
  • FOB vs. CIF: The report automatically separates the “Freight” and “Insurance” components to show the clean FOB value required for regulatory reporting.

5. Source Transactions 🔄

The reporting engine synthesizes data from:

  1. License Master: The primary legal record (AL/AA).
  2. Sales Invoices: Evidence of export fulfillment.
  3. Material Receipts (GRN): Evidence of duty-free import utilization.
  4. Purchase Indents: Future import planning linked to the license.
  5. AL Bridges: The system’s internal links (AlOrdersLink, AlIndentsLink) that “tag” specific transactions to a license.

6. Best Practices / Tips 💡

  • Expiry Alerts: Always filter by “License Status: Received” and check the Export Expiry Date. If a license is near expiry and the “Export Balance Qty” is high, prioritize production for those specific export orders.
  • Matching Orders early: Don’t wait for the final invoice. Use the Linked Orders feature in the ERP to “Tag” a license at the time of Sales Order entry. This ensures the export obligation is planned for well in advance.
  • Audit Transparency: When the government auditor visits for license redemption, download the Export Analysis (Linked Invoices) sheet. This provides a clear, row-by-row proof of which shipments were made against which license.
  • RM Costing: Remember that materials imported under AL have no duty, making them “cheaper” for costing. The Import Analysis helps the finance team accurately value the inventory for products destined for export.
MRP Report (Material Requirement Planning)Task Flow & Employee Performance Report