Move Order to Location Schedule Macro
Identifies open orders by supplier and automatically moves them to the correct warehouse/location for fulfillment.
Overview
The RIS-SM-2135 – Move Order to Location Schedule Macro automates warehouse allocation based on supplier, ensuring orders are moved to the correct location without manual intervention.
In simple terms:
It checks the supplier of an order and moves it to the right warehouse automatically.
Purpose
This macro:
-
Identifies open orders based on supplier
-
Moves eligible orders to the target warehouse/location
-
Marks orders as processed to avoid duplicates
-
Optimizes execution using direct queries for faster processing
When It Runs
Typically executed:
-
On scheduled intervals (hourly/daily)
-
During warehouse allocation and fulfillment routing
-
Before picking and packing stage
-
To handle supplier-specific order movement
Parameters
Target warehouse or location name where orders should be moved.
Supplier name used to filter which orders should be processed.
These parameters define which supplier orders to process and the warehouse they should be moved to.
Simple Explanation
The macro identifies open orders, checks their supplier, and moves matching orders to a specified warehouse automatically while marking them as processed.
Step-by-Step Process
Fetch Open Orders
Pull all currently open orders in the system.
Filter Processed Orders
Ignore any orders that have already been marked with a processing identifier to prevent duplicate actions.
Assign Identifier
Stamp active orders with a tracking identifier to log that they are being handled.
Check Supplier
Stamp active orders with a tracking identifier to log that they are being handled.
Collect Orders
Store matching orders for movement to the target warehouse.
Fetch Locations
Look up the physical warehouse database ID corresponding to the requested location name.
Move Orders
Automatically move the matching orders directly to the targeted warehouse queue.
Optimized Execution
New version uses direct SQL query to fetch order and supplier data in a single step for faster processing.
Final Result
The macro automatically moves eligible orders to the correct warehouse:
-
Orders filtered by supplier
-
Orders moved to the target location
-
Orders marked as processed
Usefulness
-
Automation – Eliminates manual order movement
-
Accuracy – Ensures correct warehouse allocation
-
Efficiency – Saves time in order processing
-
Scalability – Handles bulk orders easily
Example Scenario
Key Insight
This macro ensures the correct mapping between supplier and warehouse, enabling smooth and automated fulfillment while preventing errors like wrong warehouse picking, shipping delays, and manual intervention mistakes.
Last updated today
Built with Documentation.AI