How to use Route Planning worksheet in Logistics

Logistics for Drink-IT  •  Article  •  10/5/2026  • 

The Route Planning Worksheet is the central hub for planning and managing inbound and outbound logistics. It gives you an overview of all movements of goods, and lets you manage planning and warehouse activities, print and post documents, register payments, and control returns.

  • The worksheet consists of two sections and a FactBox:
    • The top section lists route planning numbers with their linked route information. A unique route planning number is created automatically when a document is released with a route and shipment or receipt date for which no route planning number exists yet. You can also create one in advance using Create New Route Planning.
    • The order section (subform) shows all sales orders and return orders, purchase orders and return orders, and transfer orders (shipment vs receipt) assigned to the selected route planning number.
    • The FactBox shows detailed information about the selected route planning number, including delivery time constraints.
  • A route planning number represents:

    • A drive for delivery routes.
    • A drive for van sales routes (multiple order routes).
    • For other types (pickup, export), it serves as an informational grouping of orders to be shipped or received on a date.
  • Select the Search icon , enter Route Planning Worksheet, and then choose the related link.

  • The Route Planning Worksheet opens with filter settings as defined in Logistic Employees.

See also Setting Up Logistic employees

Route planning line status indicator

The first column on each route planning line is the Message field. It indicates whether any action or correction is needed for one of the linked documents of that route planning number. The line is colour-coded based on the value:

  • No value (standard) — No issues detected. The route planning number and its documents are in order.
  • Warning (yellow) — Something has changed on one or more linked documents that requires attention before the next process step. For example, a shipment date was updated after the route planning number was created. Review the linked documents and resolve the situation before proceeding.
  • Error (red) — The next process step will fail because something has not been processed correctly on one or more linked documents. Correct the issue before posting or creating warehouse documents.

The Message field is read-only. It is recalculated automatically when you open or refresh the worksheet. Use it as a quick signal to identify route planning numbers that need attention before you batch-post or print.

Filters and sorting

Use the Filters group at the top of the worksheet to narrow the list of route planning numbers displayed.

  • Date Filter — Filters by shipment or receipt date. Accepts standard Business Central date filter expressions (for example, a specific date, a range, or a formula).
  • Route Filter — Filters by route code. Use the AssistEdit button to open the route list and select one or multiple routes.
  • Shipping Location Filter — Filters by the location from which goods are shipped.
  • Receipt Location Filter — Filters by the location at which goods are received.

When you open the worksheet, the date filter and route filter are set automatically from the settings on your Logistic Employee record.

Use the Sorting Method option above the filters to control how the list is ordered:

  • Route — Sorts by route code, then drive number. Use this when working route by route.
  • Shipment Date — Sorts by date, then route code and drive number. Use this to get a day overview across all routes.

Create a new Route planning No.

  • Route planning numbers are created automatically when an order is released for which no route planning number exists, always based on route and shipment or receipt date.
  • Route planning numbers can also be created in advance using Create New Route Planning.
    • The function suggests the same route and shipment date as the selected line, but you can change them.
    • When you confirm, it creates a new drive. The new drive inherits the driver, co-driver, vehicle, trailer, shipping agent, and service code from the route, but has no orders assigned yet.
    • If you select a route and date for which a route planning number already exists, a new drive is still created for that route and date.

Use the Shipment Date actions on the action bar to move between planning dates without adjusting the date filter manually:

  • Next Shipment Date — Moves the worksheet forward to the next shipment date for the selected route.
  • Previous Shipment Date — Moves the worksheet back to the previous shipment date for the selected route.

Information on weight and pallet places

  • Per route planning line, the route, drive, route name, and shipment or receipt date are displayed.
  • The total weight and number of pallet places are based on the assigned orders.
  • The Shipping Weight and Act. No. of Ship. Pallets columns show the totals for outbound goods. Add the Receiving Weight and Receiving Pallet columns to also view inbound totals.
  • The Max Weight and Max. Pallet Places columns show the vehicle capacity. When the vehicle is changed, these values are updated automatically.
  • The FactBox shows the complete details of the route planning number, including location and shipping agent.

Select drivers, vehicles and shipping agents

  • You can select a vehicle and driver directly on the route planning line. Selecting a vehicle sets the Max Weight and Max. Pallet Places on the line.
  • You can add the Co-driver and Trailer columns to select codes for them as well. The capacity of the trailer increases the Max. Weight and Max. Pallet Places.
  • You can add the Shipping Agent and Shipping Agent Service Code columns to set or change shipping agent information.
  • Default values come from the route but can always be changed on the route planning line.
  • For multiple order routes, set vehicle, driver, and shipping agent on the route planning line. On posting, the posted shipment or receipt headers inherit these values through an update on the order.

Move a route planning no.

  • You can move all orders from one route planning number to another using Move Route Planning. Use this when a complete drive needs to be reassigned — for example, to another date or to merge small routes.
  • Use Move Route Planning on the action bar:
    • Select another route, shipment date, or drive number. All orders are reassigned to the target route planning number.
    • The original route planning number is not deleted; you can continue to plan on it or remove it manually.
    • Orders appear under their new route planning number after the move.

The shipment date, route number, and drive number can be updated on the sales order and warehouse shipment without creating a new document. When you change these values using Move Route Planning, the system updates the existing sales order and any associated warehouse shipment. These values cannot be updated if an open warehouse pick exists for the warehouse shipment. License plates and registered warehouse picks are linked to the correct route planning number. When there are no open warehouse activities, the route number and shipment date are also updated directly on the Sales Order page.

Use the Print group on the action bar to print documents for all orders assigned to the selected route planning number at once.

Sales:

  • Sales Order Picklists — Prints a pick list for each sales order assigned to the route planning number. Also updates the logistic status of those orders to Pick list printed.
  • Sales Order Confirmations — Prints an order confirmation for each sales order. Also updates the logistic status to Order Confirmation.
  • Sales Return Order Confirmations — Prints a confirmation for each sales return order. Also updates the logistic status to Order Confirmation.

Purchase:

  • Purchase Orders — Prints a purchase order document for each purchase order assigned to the route planning number. Also updates the logistic status to Order Confirmation.
  • Purchase Return Orders — Prints a document for each purchase return order assigned to the route planning number.

Transfer:

  • Transfer Orders — Prints a transfer order document for each transfer shipment assigned to the route planning number.

Load List:

  • Print Load List — Prints the consolidated load list for the route planning number, based on the report configured in Logistics Setup.

Create/open warehouse documents

For locations configured with advanced warehouse management, create warehouse documents directly from the route planning worksheet.

  • Create/Modify Warehouse Shipment — Creates a warehouse shipment for the selected route planning number to start a pick and ship process. If a warehouse shipment already exists, this action opens it.
  • Create/Modify Warehouse Receipt — Creates a warehouse receipt for the selected route planning number to start a put-away and receive process. If a warehouse receipt already exists, this action opens it.

These actions apply to locations using the advanced warehouse configuration. For basic warehouse locations, shipments and receipts are posted directly from the order.

Return entry and control

Use Return Control on the action bar to register received returns per item and verify that the returned quantities match the quantities in the route source documents.

  • The Return Control page opens filtered to the selected route planning number.
  • The Return Control Status column on the worksheet line shows the current status of the return process for that route planning number.
  • When all returns have been registered, check Return Completed on the route planning line. This can trigger logistic status updates on the assigned orders, depending on the configuration in Logistic Statuses.
  • The Assignment Differences field specifies how differences found during the return settlement process are handled.

Set Logistic status

The route planning line has four status fields that mark the progress of a drive. Each field can trigger logistic status updates on the assigned orders, depending on the configuration in Logistic Statuses.

  • Closed — Marks the route planning number as fixed. When checked, new orders for the same route and shipment date are assigned to a new drive rather than this one.
  • Truck Arrived — Indicates that the truck has arrived. Can trigger a logistic status update on assigned orders when configured in Logistic Statuses.
  • Return Completed — Indicates that all returns on the route have been registered. Can trigger a logistic status update on assigned orders when configured in Logistic Statuses.
  • Completed — Indicates that the route is completed: all goods have been shipped and received, and lines have been registered and posted. Can trigger a logistic status update on assigned orders when configured in Logistic Statuses.

Batch post orders

Use the Posting group on the action bar to post all orders assigned to the selected route planning number at once, without having to open each order individually.

  • Post Batch Sales Orders — Posts all sales orders for the route planning number.
  • Post Batch Sales Return Orders — Posts all sales return orders for the route planning number.
  • Post Batch Purchase Orders — Posts all purchase orders for the route planning number.
  • Post Batch Purchase Return Orders — Posts all purchase return orders for the route planning number.

After posting, use the Create Periodic Invoices and Create Periodic Credit memos actions to prepare combined invoices or credit memos for orders with an invoice period configured.

Payment Journal

Use the Payment Journal group on the action bar to register cash, card, or other payments collected during the route. The journal templates used are configured in Logistics Setup.

  • Cash Receipt Journal — Opens the cash receipt journal for cash payments for the selected route planning number.
  • Card Receipt Journal — Opens the cash receipt journal for card payments for the selected route planning number.
  • Other Receipt Journal — Opens the cash receipt journal for other payment types for the selected route planning number.

Find Entries

Use Find Entries in the Home area to find all route planning entries related to the selected route planning number and date.

Vehicle Load Zone

Use Route Planning Vehicle Load Zone in the Related area to view the load zones of the vehicle linked to the selected route planning number.

Warehouse Shipment Book

Use Warehouse Shipment Book in the Navigation area to view all warehouse shipment lines linked to the selected route planning number. See Warehouse Shipment Book.

Move an order to another route or drive

  • This process starts from the order section or Route Planning Request.
  • Based on the capacity constraints of the vehicle and trailer, the route planner may need to move an order to another route planning number.
  • An order can be moved to another drive on the same route:
    • Enter the drive number or drill down to select.
    • The order no longer appears under the current route planning number; the totals reflect the shift. The order can be found under the route planning number it was moved to.
  • An order can be moved to another route:
    • Enter the route number or drill down to select.
    • The order no longer appears under the current route planning number; the totals reflect the shift. The order can be found under the route planning number it was moved to.

Information on the order

  • This information is available in the order section or Route Planning Request.
  • Delivery address information available:
    • Customer number, name, address, city, postal code
    • Customer key number
    • Delivery address constraints:
      • Delivery type
      • Delivery times
      • Require 2 drivers
      • Unload zone
    • Order total information from the Logistics FastTab in the order:
      • Total Weight, Quantity (pallets)
      • Outbound and inbound (show columns)
      • Picking type (delivery pick, combined pick)

Open the source document

  • This process starts from the order section or Route Planning Request.
  • Open the document depending on the document type:
    • Sales Order → opens the Sales Order page.
    • Sales Return Order → opens the Sales Return Order page.
    • Purchase Order → opens the Purchase Order page.
    • Purchase Return Order → opens the Purchase Return Order page.
    • Transfer Order Shipment or Transfer Order Receipt → opens the Transfer Order page.

Return entry per order

To register return entries for a specific order, open the source document from the order section and select Return Entry on the source document.

Post order

To post an individual order, open the source document from the order section and post it directly from there.