Open Order Mark As Processed
Automatically process eligible open orders based on delivery scheduling logic and predefined timing conditions.
Overview
The RIS-SM-2029 – OpenOrderMarkAsProcessed macro automates order processing by evaluating delivery dates and processing orders only when they meet defined scheduling criteria.
It ensures that orders are processed neither too early nor too late, improving workflow timing and operational efficiency.
Ensure delivery_day extended property is correctly formatted for accurate processing.
Purpose
This macro:
- Evaluates delivery dates from order data
- Applies timing logic using configurable days
- Processes only eligible orders
👉 In short:
Process orders automatically on the correct scheduled date.
When It Runs
Used for scheduled and delayed order processing
Typically runs:
- Scheduled execution (recommended daily)
- Manually triggered
Parameters
Comma-separated list of vendor names to filter orders.
Comma-separated order identifiers used for filtering.
Number of days added to delivery date to determine processing date.
Only orders matching vendor and identifier conditions will be processed.
How It Works
Initialize Inputs
Split Vendors and Identifiers into structured lists.
Fetch Locations
Retrieve all inventory locations from the system.
Retrieve Open Orders
Fetch open orders for each location.
Filter Orders
Select orders where:
- Label or picklist is printed
- Status is Open or Parked
- Vendor and identifier match inputs
Read Delivery Date
Extract delivery_day from extended properties and validate format.
Calculate Processing Date
Add Days to delivery date and compare with current UTC date.
Identify Eligible Orders
Select orders where calculated date matches current date.
Process Orders
Process eligible orders in batch per location.
Log Execution
Record success, failures, and invalid data.
Final Result
-
Orders are processed automatically based on schedule
-
Only valid and eligible orders are processed
-
Batch processing improves performance
-
Execution logs provide full traceability
Usefulness
This macro is highly beneficial for:
- Automating scheduled order processing
- Preventing early or delayed fulfilment
- Reducing manual workload
- Improving workflow accuracy
- Enhancing operational efficiency
Important Notes
-
Depends on correct delivery_day format
-
Uses UTC date for comparison
-
Processes only matching vendor and identifier orders
-
Ignores orders without valid conditions
-
Failed orders are logged but not retried
Example Scenario
Key Insight
By aligning order processing with delivery scheduling logic, this macro ensures precise timing, reduces operational errors, and improves fulfilment efficiency.
Last updated today
Built with Documentation.AI