Sales Order

Sales Order Module - User Guide

ℹ️

πŸ“ˆ Business Impact

The Sales Order module is your command center for revenue tracking. Implementing this module correctly can reduce order processing time by up to 30% and eliminate shipping errors by ensuring 100% accurate data flow from sales to the shop floor.


⚑ Quick Start: 3-Minute Fast Track

For experienced users who need to create an order immediately:

  1. Header: Click Create New, pick Party, and enter PO No/Date.
  2. Items: Search for Item, enter Qty, and verify the Rate.
  3. Save & Confirm: Ensure all item statuses are OK, then click Confirm.
  4. Done: The order is now live for Production and Inventory teams.

πŸ—ΊοΈ Process Flow: CRM to Invoice

graph LR
    Enquiry[Sales Enquiry] --> Quotation[Quotation/Proforma]
    Quotation --> SO[Sales Order]
    SO --> Production[Production Plan]
    Production --> Invoice[Sales Invoice]
    Invoice --> Dispatch[Dispatch Summary]
    
    style SO fill:#f9f,stroke:#333,stroke-width:2px

βœ… Prerequisites Checklist

Before creating your first Sales Order, ensure:

  • Party Master: Customer is registered with correct GST and Address.
  • Brand Master: Relevant item brands are configured.
  • HSN Codes: All inventory items have correct HSN and GST rates.
  • Salesmen: Sales officers are assigned to the party/branch.

1. Introduction πŸ“

The Sales Order module is a core part of the ERP system designed to manage the entire lifecycle of customer orders. It captures critical data like pricing, delivery dates, and shipping requirements.

ℹ️

In the overall business flow:

  1. It usually follows a Sales Enquiry or Quotation.
  2. It serves as the base for Production Planning and Inventory Allocation.
  3. It eventually leads to Sales Invoicing and Dispatch.

Typically, this module is used by Sales Officers, Production Coordinators, and Accounts Teams to ensure orders are fulfilled on time and within credit limits.


2. Getting Started with Sales Orders πŸš€

Accessing the Module

To access the Sales Order module, navigate to the Sales Order section from the main menu.

The Index Page

Upon opening, the Index Page displays a comprehensive list of all existing Sales Orders. Here, you can:

  • Search/Filter: Filter by System Order Number, Order Date (with =, >, < operators), Unit, Customer Short Name, PO No, or Currency.
  • View Details: Click on an Order Number to view its full details.
  • Item Details View (salesorder1index/0): Click the Item Details button on the bottom bar to open an aggregate line-item data grid across all orders with item-level filters (PO No, Item ID, Amount, Order Status, and Pending Status).
  • Order Booking: When the system parameter bookingSysParameter == "Y" is active, an Order Booking button is visible, providing direct access to the pipeline booking sub-module.

Sales Order Index Page

Starting a New Order

To create a new order, click the “Create New” button. The system follows a two-step process:

  1. Header Creation: Enter general information like Party details, Order Type, and PO numbers.
  2. Item Entry: Add specific products or services to the order.

Sales Order Details/Creation Screen


3. Features ✨

The Sales Order module is packed with features to handle various business scenarios:

  • 🏷️ Multiple Order Types: Create Direct Orders, Proforma Invoices, or Quotations.
  • 🏒 Ad-hoc / Dummy Party Support: For Quotations and Proforma Invoices, create orders for prospect parties with ad-hoc names and addresses before they are formally registered in the Party Master.
  • πŸ”„ Ad-hoc Order Confirmation Mapping (SalesOrderConfirmAdhoc): When converting an Ad-hoc Quotation/Proforma to a Confirmed Order, the system guides you through a dedicated mapping screen to link dummy parties and ad-hoc items to actual master records.
  • πŸ“‹ Line Item Management: Add, modify, or delete specific items. The system automatically fetches HSN codes, GST rates, and lead times.
  • πŸ”„ Line Pricing Utilities:
    • Re-update Rate From Price Mst: Re-sync rate and MRP from Price Master for non-manual items.
    • Convert To Manual Rate: Easily override system price-list rates on specific line items.
  • πŸ“ Bulk Excel Import: Import lines in bulk using ImportSalesOrder.xlsx. Available when an order currently has zero line items.
  • 🚚 Freight Management: Specify if freight is mandatory (IsFreightRequired = Y). Prompts the user to add a dedicated freight item (requiring an item with inventory class “Freight/Packing”).
  • πŸ“ Ship-To Address Management: Dedicated interface to configure distinct delivery GSTIN, location, and address details.
  • πŸ’³ Credit Limit Control & Special Auth: Real-time checking of the customer’s outstanding balance against their allowed limit, with Special Authorization override.
  • πŸ“‚ Document Management: Upload and download scanned customer Purchase Orders (PDF) up to 1 MB.
  • πŸ“§ Communication: Directly Print PDF versions (Confirmation, Proforma, Quotation) or Email the order confirmation to registered customer contacts.

4. Complete Flow πŸ”„

The lifecycle of a Sales Order typically follows these steps:

Create Header

  • Select the Order Date and Order Type (Direct, Proforma Invoice, Quotation).
  • For Quotations/Proformas, you can check “Want to create order with Ad-hoc Party Name & Address?” to enter prospect customer details without a Master Party.
  • Pick a Party (Customer), their specific Branch, and Unit.
  • Enter Customer PO Number and PO Date. (If a duplicate PO is detected, the “Bypass Duplicate Po number?” checkbox is available).
  • Specify Currency, Salesmen Name, Order Category, and Is Freight Mandatory.
  • Optionally select an End Customer party and branch if different from the billing party.

Add Line Items

  • Search for Items and select the appropriate Brand.
  • If bookingSysParameter == "Y", enter the mandatory 6-digit Booking No.
  • Enter Quantity and choose whether to use master pricing or check Is Manual Rate?. (If manual rate and non-INR currency, specify the Factor).
  • Set the Required By Date, Compute Aging From Date (EffectiveDate), and Planned Date.
  • Optionally record PR No / Tracking No and Non-Standard Item Name for custom-engineered items.

Manage Shipping Info

  • Click Create/Modify Ship To Info (salesorderupdateshiptoinfo) to define custom delivery details:
    • Ship To GSTIN (enter URP if unregistered).
    • Ship To Party Name, Address, Location, Pin Code, and State Code.

Attach Documents

  • From Order Details, click Upload Customer PO (salesorderuploadpono):
    • Select the customer’s PO file (must be .pdf, max 1 MB).
    • Download or re-upload whenever needed. (Link is automatically disabled for orders older than 1 year).

Upload PO Feature

Confirm Order

  • For standard Quotations/Proformas: Click “Convert To Confirmed Order”. Once confirmed, order details and lines are locked from further editing.
  • For Ad-hoc Party Orders: Converting redirects to Confirm Ad-hoc Sales Order (salesorderconfirmadhoc):
    1. Select the Actual Master Party & Branch.
    2. Map each dummy line item to its corresponding Actual Master Item.
    3. Submit to finalize the conversion into a production-ready Confirmed Order.

Post-Save Actions

  • The confirmed order is immediately available for Production Planning and Sales Invoicing.

5. Non-Obvious Validations and Business Rules ⚠️

Validation TypeWhat is checked?Rule / System Action
Ad-hoc Confirmation LockAd-hoc party orders converting to confirmed status.System redirects to salesorderconfirmadhoc. Conversion is blocked until actual Party, Branch, and Master Items are mapped.
Credit Limit & Special AuthParty outstanding balance exceeds credit limit.Requires approval code verification via the Special Auth dialog.
Duplicate PO BypassExisting PO number for same customer.Error alert displays previous order number. User must explicitly tick Bypass Duplicate Po number?.
Outside India INR CheckSupply State Code > 90 (outside India) with Currency = INR.Mandatory checkbox: “Bypass INR for Supply State Outside India?” must be selected.
Excel Import Line LimitAttempting Excel Import when lines exist.Import is only permitted when line count is 0. The button is hidden once items exist.
Excel File NamingUploading line items in bulk.Uploaded file MUST be named ImportSalesOrder.xlsx.
PO Upload ConstraintsCustomer PO document upload.Must be in PDF format (.pdf), maximum size 1 MB. Upload is blocked for records older than 1 year.
Freight Item Dependency“Is Freight Mandatory” = Yes.An item with inventory class “Freight/Packing” must exist in the database, and a freight line item must be added before order confirmation.
Deletion Reason & Connected DocsDeleting a Sales Order.Requires a mandatory reason between 10 and 250 characters. Deletion is permanently blocked if connected documents (Invoices, GRNs) exist.
Status OK for ConfirmationItems pending confirmation.Every line item status must be set to “OK” prior to order confirmation.

6. Tools / Smart Features πŸ”§

  • πŸ” Cross-Order Line Item Explorer (salesorder1index/0): Inspect and filter line items across all customer orders simultaneously by order number, PO number, item, amount, and pending flag.
  • πŸ”„ Re-Update Rate/MRP from Price Master: If market rates change before an order is confirmed, re-sync pricing with one click rather than re-entering lines.
  • πŸ”˜ Manual Rate Conversion: Seamlessly convert system-priced items to manual pricing.
  • πŸ”— Connected Documents Explorer: Track linked downstream documents (Invoices, Production Jobs, Shipments) at both the Order Header level and individual Line Item (Order1) level.
  • πŸ“¦ Order Booking Synchronization: Seamless connection between advance pipeline commitments and formal sales order lines via Booking Numbers.

7. Reports Related to Sales Order πŸ“Š

  1. πŸ“„ Sales Order Confirmation (PDF): Formatted customer document with company header/footer.
  2. πŸ“‹ Sales Order Register: Detailed audit list of all orders within a date range.
  3. ⏳ Pending Order Report: Tracks unfulfilled items with lead-time aging colors.
  4. πŸ“ˆ Delivery Performance: Measures PO delivery timelines against actual billing.
  5. πŸ“’ Marketing Activities: Tracks customer interactions linked to order creation.
  6. 🚚 Dispatch Summary: Summary of shipments against active sales orders.
  7. πŸ“‰ Short Close Report: Lists orders prematurely closed with reasons.
  8. πŸ“‘ Order Booking Report: Audits advance booking commitments vs. confirmed orders.

8. Pre-settings / Configurations βš™οΈ

  • πŸ—οΈ Party/Branch Master: Customers registered with valid GST and Address.
  • πŸ“¦ Inventory Master: Items with valid HSN codes, brands, GST rates, and Freight/Packing class.
  • πŸ‘€ Salesmen Master: Active sales officers assigned for responsibility.
  • πŸ› οΈ System Parameters:
    • bookingSysParameter: Set to “Y” to enable Order Booking integration and 6-digit booking numbers.
    • Credit Limit Check: Set to “Y” to enforce credit limit validation.
  • πŸ’³ Payment Terms: Standard payment terms configured in master tables.

9. Best Practices / Tips πŸ’‘

  • Pre-validate Ad-hoc Items: Before converting an ad-hoc quotation into a confirmed order, verify that any new inventory items have already been created in the Item Master so they can be mapped quickly.
  • Use Excel Import on Fresh Orders: Remember that the Excel Import button is only available on newly created orders before any manual line item is added.
  • Keep Customer PO Copies Under 1 MB: Optimize customer PDF scans before uploading to ensure quick cloud storage and retrieval.
  • Audit Connected Docs Before Deletion: If an order cannot be deleted or modified, check the Connected Documents link to find which invoice or fulfillment record is locking it.