Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article shows how to use the outbound load planning workbench to create a load for a sales order. As a prerequisite we'll create the sales order first. This procedure is part of the daily work for the transportation coordinator. The demo data company used to create this procedure is USMF.
Create a sales order
- Go to the Accounts receivable > Orders > All sales orders.
- Select New.
- In the Customer account field, select the drop-down button to open the lookup.
- Select account US-004.
- Select OK.
- In the Item number field, select the drop-down button to open the lookup.
- Select item A0001. A0001 is enabled for transportation management.
- In the Site field, select the drop-down button to open the lookup, then select an item.
- In the Quantity field, enter a number.
- In the Warehouse field, type 24 for this example. This warehouse is enabled for transportation management and warehouse management processes (WMS).
- Select Save.
- Close the page.
Create a new load
- Go to the Transportation management > Planning > Outbound load planning workbench.
- Select the Sales lines tab. Now you'll build the load for the sales order that you just created. Loads can be built based on supply and demand from purchase orders, transfer orders, and sales orders.
- On the Action Pane, select Supply and demand.
- Select To new load.
- In the Load template ID field, select the drop-down button to open the lookup. The Load template defines maximum measurements for weight and volume of the entire load. For example, the load template might represent the size of a container or truck. Select an item.
- Select OK.
Rate and route the load
- Select Rating and routing.
- Select Rate route workbench.
- Select Rate shop.
- In the list, find and select the desired record.
- Select Assign.
- Close the page.
Load planning filters
You can set up custom filters to control which types of lines to show in the Outbound load planning workbench. For example, you can choose to only show fully reserved transfer order lines. Follow these steps to set up one or more load planning workbench filters.
Go to Warehouse management > Loads > Outbound load planning workbench. (You can also open the workbench from the Sales orders, Transfer orders, and Outbound shipment orders pages.)
On the Action Pane, open the Filters tab and select Load planning filters.
On the Action Pane, select New to add a new load planning filter to the grid. Then make the following settings for the new line:
- Load planning filter code – Enter a unique name for the filter.
- Description – Enter a short description of the filter.
- Load planning filter type – Choose the type of lines the filter should apply to (Load, Sales order, Transfer order, Shipment, or Outbound shipment orders). For example, if you want to set up a filter that only shows fully reserved transfer order lines, select Transfer order.
On the Action Pane, select Save.
With the new filter selected in the grid, select Edit query on the Action Pane. A standard query editor opens, where you can define the filter criteria that you want to apply. Here's an example of how to set up a filter to show only fully reserved transfer order lines:
Open the Joins tab. Select the Transfer order lines node and then select Add table join from the toolbar. Find and select the row with a Relation of Relationship between the inventory transfer order line and the inventory transactions originator of the shipment transactions (Line number) (with Join mode 1:n). Then select Select on the toolbar.
Select the new Relationship between the inventory transfer order line and the inventory transactions originator of the shipment transactions node and then select Add table join from the toolbar. Find and select the row with a Relation of Inventory transactions originator (Inventory transactions originator). Then select Select on the toolbar.
Select the new Inventory transactions originator node and then select Add table join from the toolbar. Make sure that Show details is set to Yes. Find and select the row with a Relation of Inventory transactions (NotExist Record-ID) and a Relation source of InventTrans : InventTransOrigin. Then select Select on the toolbar. Your Joins tab should now resemble the following screenshot.
Open the Range tab. Add a new row to the grid with the following settings:
- Table – Select Inventory transactions (NotExist).
- Field – Select Issue status.
- Criteria – Enter !Reserved physical, which means "not Reserved physical."
These settings result in a filter that only includes transfer order lines with an inventory transactions status of Reserved Physical, which are the fully reserved lines. Your Range tab should now resemble the following screenshot.
Select OK to save the query.
Select the Back button to go back to the Outbound load planning workbench page.
Open the tab you created your filter for (for example, the Transfer lines tab). Then set Supply and demand filter to the filter you just created. The page is now filtered according to the criteria you defined for the selected filter.
If you'd like to apply the new filter by default when you open the workbench, then on the Action Pane, open the Filters tab and select Set as default.