Short Close Order

Short Close Order Module - User Guide

1. Introduction πŸ“

The Short Close Order module is a powerful administrative utility used to bulk-manage pending Sales Orders. In many manufacturing environments, orders may remain partially unfulfilled due to small remaining quantities, customer cancellations, or order expiration. Instead of manually closing each order line, this module allows users to identify, review, and close multiple orders simultaneously using an Excel-based workflow.

ℹ️

In the overall business flow:

  1. It is a maintenance utility used to clean up the “Pending Orders” list.
  2. It changes the status of selected order lines to “EXPIRED”.
  3. It uses a unique Export-Edit-Import pattern for bulk processing.

Typically, this module is used by Sales Administrators and Production Planners.


2. Getting Started with Short Close Order πŸš€

Accessing the Module

Access the module via the Short Close Order Options menu.

Short Close Order Options

The Workflow Overview

Unlike standard modules where you fill out a web form, Short Close Order follows a 4-step process:

  1. Define Selection Criteria: Set the rules for which orders to consider.
  2. Download (Print): Export the list to Excel.
  3. Review & Mark: Decide which orders to close in the Excel file.
  4. Upload (Import): Process the closures in the system.

3. Features ✨

  • πŸ“Š Smart Selection Criteria: Filter orders based on two primary logic types:
    • By Quantity: Find items where the remaining pending quantity is negligible (e.g., < 5 units).
    • By Age: Find items that have been pending for a long time (e.g., > 90 days).
  • πŸ“ Bulk Excel Processing: Handle hundreds of orders in a single session.
  • πŸ›‘οΈ Validation Engine: Automatically checks for the existence of an “EXPIRED” status in the system before allowing any changes.
  • πŸ•΅οΈ Error-Correction Loop: After importing, the system provides a result Excel file that clearly highlights any rows that failed (e.g., due to incorrect formatting or missing IDs).
  • πŸ“œ Automated Reporting: Maintains a log of every Short Close report generated, including the search parameters used and the user who initiated it.

4. Complete Flow πŸ”„

Set Your Criteria

  • Navigate to the Short Close Order Options page.
  • Select Report Type: Choose Qty (to close based on low remaining stock) or Age (to close based on date).
  • Enter Value:
    • For Qty: Enter the maximum pending amount (e.g., 1.000).
    • For Age: Enter the minimum days pending (e.g., 180).
  • Adjust the Date Range (From/To) to narrow down your order list.

Generate & Download (Print)

  • Click “Print”.
  • Depending on date range and data volume, the system either triggers a direct download or routes the request to the background report queue (via ReportQueuedDialog sent to the user’s email if queue count < 15).
  • The downloaded file is named Short_Close_Order.xlsx.

Mark for Closure & Rename File (In Excel)

  • Open the downloaded Excel file Short_Close_Order.xlsx.

  • Locate the “Short Close” column (Column N).

  • For every row you want to close, change the value to Y.

  • For rows you want to keep open, leave it as N.

  • ⚠️
    Mandatory File Renaming Before Import:

The system strictly enforces that the uploaded file name must be ImportShortCloseOrder.xlsx. You must rename your edited file from Short_Close_Order.xlsx to ImportShortCloseOrder.xlsx before uploading, otherwise the system immediately rejects it with: β€œUploaded Excel File Name must be ImportShortCloseOrder(with extension .xlsx)”.

Import and Process


5. Validations and Error Handling ⚠️

The system performs several checks during the process:

Validation TypeWhat is checked?Error Message / Action
System Status CheckDoes an “EXPIRED” status exist in the Status Master?“In Order status master, there is no existing status as ‘EXPIRED’.”
Date RangeIf From Date > To Date or gap > 2 years.“Invalid Date Range” or “Gap… may not exceed 2 years.”
Criteria RangeQty must be 0-10; Age must be 60-730 days.“Pending qty should be between 0.001 and 10.”
Upload File NameUploaded file name must match exactly.“Uploaded Excel File Name must be ImportShortCloseOrder(with extension .xlsx)”
Import FormatColumn count and header names.“File is not in correct format.” or “Please upload correct model.”
Empty FileFile contains no data rows.“Excel File does not contain any data.”
Data IntegrityIf Order No length > 6 or Dates are invalid.Error Code (Z1, Z2, etc.) in the Result Excel.

6. Tools / Smart Features πŸ”§


7. Related Reports πŸ“Š



8. Configuration Requirements βš™οΈ


9. Best Practices / Tips πŸ’‘

ℹ️
  • Small Batches: If you have thousands of orders, try processing them in smaller date ranges (e.g., month-by-month) for easier review.
  • Comment Feature: Check the cell comments in the exported Excel (Column N) for specific instructions on allowed values.
  • Don’t Move Columns: Do not change the order of columns in the Excel file, as the importer relies on specific column positions.

10. Technical Observations πŸ”

⚠️
  • Row/Column Limits: The importer is hardcoded to expect exactly 14 columns for Orders. Any variation will result in a format error.
Sales RejectionSales Order