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:
- It categorizes Shipping & Handling costs for financial reporting.
- It ensures Standardized Naming for freight across all sales and purchase documents.
- 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
FormErrorstating: “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
TRIMsall 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:
- Sales Orders
- Invoices
- Indents
- 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.