Docs
ERP Crystal
MFG
Sales
Reports
Order Booking Report

Order Booking Report

Order Booking Report - User Guide

1. Introduction 📈

The Order Booking Report is the starting point of the manufacturing and sales lifecycle. In many business models, a “Booking” represents an initial commitment or reservation by a customer before a formal sales order is drafted or production is scheduled. This module allows sales teams and management to monitor the sales pipeline and ensure that every booking is successfully converted into a formal order.

ℹ️

Purpose of this Report:

  • Pipeline Monitoring: Track initial customer interest and booking volumes.
  • Conversion Auditing: See exactly how many “Bookings” have successfully become “Sales Orders.”
  • Gap Analysis: Identify “Pending Bookings” that haven’t been followed up on.
  • Traceability: Provide a clear link from the initial Booking to the final Sales Invoice.

This report is essential for Sales Managers, Production Planners, and Relationship Managers.

2. Report Modes 🚀

A. Pending Order Booking

  • The Follow-up List: Specifically filters and shows only those bookings where the full quantity has not yet been converted into a Sales Order.
  • Focus: Essential for sales teams to identify “slippage” or orders that are stuck in the pre-production stage.

B. Order Booking Details (Conversion Audit)

  • The Full Trace: A comprehensive report that tracks the lifecycle of a booking:
    • Level 1: Initial Booking Details (Date, Qty, Rate).
    • Level 2: Matched Sales Orders (Order No, Date, Qty).
    • Level 3: Matched Shipments (Invoice No, Date).
  • Use Case: Audit the entire journey of a customer’s requirement from day one to the day of delivery.

3. Key Analysis Features 🛠️

  • Conversion Math: The report calculates Booking Qty - Ordered Qty = Pending Qty. This is the primary metric for measuring sales execution.
  • Party & Branch Tracking: In large enterprises, bookings may come from a head office but be delivered to a specific branch. The report maintains this hierarchy for accurate relationship management.
  • Reference Linking: Automatically pulls in internal reference numbers and customer notes to provide context for high-priority bookings.

4. Understanding Data Columns 📊

  • Booking No: The unique lead identifier.
  • Booking Date: When the customer’s requirement was first recorded.
  • Ref No: The customer’s internal inquiry or purchase reference.
  • Pending Qty: The quantity still remaining to be fulfilled.
  • Order/Invoice Trace: Shows the physical document numbers once the booking progresses through the system.

5. Source Transactions 🔄

The reporting engine synthesizes data from:

  1. Order Booking Master: The initial entry of customer requirements.
  2. Sales Order (Orders/Orders1): The formal commitment stage.
  3. Sales Invoice (Invoice/Invoice1): The final fulfillment stage.
  4. Masters: Party, Branch, and Inventory definitions.

6. Best Practices / Tips 💡

  • The Weekly Pipeline Scan: Sales Managers should run the Pending Order Booking report every Monday morning to identify high-value bookings that haven’t moved to the production stage.
  • Rate Variance Check: Use the “Details” report to compare the Booking Rate against the Final Invoice Rate. Large discrepancies can highlight where sales margins are being diluted.
  • Clean-Up Operations: If a booking is no longer valid (e.g., the customer withdrew interest), use the “Short Close” feature in the Orders module to clear the “Pending Qty” from this report.
  • Audit Trail: Statutory auditors often look for the “Order-to-Cash” cycle. This report provides the most complete evidence of that cycle starting from the initial booking.
GST Compliance Reports