Freight Master

Freight Master (FreightMst) - User Guide

1. Introduction πŸ“

The Freight Master (FreightMst) is a foundational setup module used to define different types of freight and shipping charges applicable to the business. It provides a standardized list of freight categories that can be selected during the creation of Sales Orders, Invoices, Indents, and Purchase Bills.

ℹ️

In the overall business flow:

  1. It categorizes Shipping & Handling costs for financial reporting.
  2. It ensures Standardized Naming for freight across all sales and purchase documents.
  3. It supports Auditability by linking specific charges to master records.

Typically, this module is managed by Logistics Managers or Finance Administrators.


2. Getting Started with Freight Master πŸš€

Accessing the Module

Navigate to the Freight Master Index via the Supply Chain or Finance setup menu.

Modes of Management

  • Create New: Define a new freight type. The system automatically handles the unique code generation.
  • Modify: Update the name of an existing freight category.
  • Details: View the configuration and ownership of a freight record.

3. Features ✨

🧾 Automated Coding

  • Next-DocNo Logic: The system automatically generates the next available FreightCode (e.g., ‘01’, ‘02’) using a specialized document numbering helper, reducing manual entry errors.

πŸ›‘ Scalability Guardrails

  • Record Limit: The master is designed for high efficiency and maintains a limit of 99 active records to keep picklists manageable and performant.

πŸ›‘οΈ Deletion Protection

  • Referential Integrity: The system performs a deep scan across the ERP (Invoices, Orders, Bills) before allowing a deletion. If a freight code is “in use,” deletion is strictly prohibited to prevent data corruption.

4. Complete Flow πŸ”„

Initialize Freight Category

  • Provide a descriptive Freight Name (e.g., “Courier Charges”, “By Road Transport”, “Air Freight”).
  • The system validates that this name doesn’t already exist.

System Configuration

  • The system assigns a unique Freight Code.
  • The Owner field is assigned to indicate system-level master data.

Consumption by Modules

  • Sales Order / Invoice: Selected in the logistics/header section to label freight amounts.
  • Indent / Purchase Bill: Used to track incoming transport costs against specific procurement cycles.
  • Common Components: Populates dropdowns across the ERP for consistent user selection.

5. Validations and Logic ⚠️

Creation Validations

  • Duplicate Name Check: Prevents two freight categories from sharing the same name to avoid confusion in financial reports.
  • Character Limits:
    • Freight Name: Maximum 100 characters.
  • Capacity Limit: If the auto-generated code exceeds ‘99’, the system triggers a FormError stating: “This table can hold a maximum of 99 records only. System is unable to save.”

Formatting Logic

  • Case Sensitivity: Freight names are automatically converted to UPPERCASE upon saving to ensure visual consistency in drop-down menus and printouts.
  • Whitespace Cleanup: The system TRIMs all leading and trailing spaces from names before committing to the database.

6. Referential Integrity & Safeguards πŸ›‘οΈ

The “Delete Info” Scan

Before a freight record is deleted system checks for the freightcode in all tables linked to this master:

  1. Sales Orders
  2. Invoices
  3. Indents
  4. Purchase Bills

If any records are found, the delete button is either disabled or the action is rejected with a count of linked documents.


7. Related Modules πŸ“Š

Freight Master data is visible in:

  • πŸ“¦ Sales Lifecycle: Appears as a lookup in Sales Order and Invoice headers.
  • πŸ›’ Procurement: Used in Indents and Purchase Bills for cost tracking.
  • πŸ› οΈ Common Components: Centralized service that provides the freight list to all Razor pages.

8. Best Practices / Tips πŸ’‘

  • Standardize Names: Use broad, clear categories (e.g., “Logistics - Road”) rather than specific transporters, as transporter names are managed in the Transporter Master.
  • Monitor Limits: Since there is a 99-record limit, periodic auditing of unused freight types is recommended.
  • Check Usage First: If you cannot delete a freight type, use the “Connected Docs” or “Delete Count” feature to identify where it is currently linked.