Using The Generic Auto-Waver

The generic auto-waver is driven by the AutoWaves.Rules system parameter. It has a JSON value that dictates the rules on the auto-waver. It also uses REPs that dictate which orders are candidates for the wave stream.

The report needs to find the JobIDs for the candidate orders. An optional field Slice can be used. The slice breaks down the orders in the auto-wave streams based on the slice value.

An example report that gets all orders for a specific tenant that have an ordered quantity of 1 that is sliced on the carrier name:

Copy 
SELECT PCK.JobID, CAR.CarrierName as Slice

FROM PCK
INNER JOIN CAR1 ON CAR1.CarrierServiceID = PCK.CarrierServiceID
INNER JOIN CAR ON CAR.CarrierID = CAR1.CarrierID
INNER JOIN PCK1 ON PCK.JobID = PCK1.JobID

WHERE PCK.InstanceID = :InstanceID 
AND PCK.TenantID = 2113 
AND JobStatus = 'Ready' 
AND PCK.WarehouseID = 40

GROUP BY PCK.JobID HAVING SUM(PCK1.Quantity) = 1
ORDER BY PCK.JobID

Field

Description

RunTimes

A JSON object that has the times the auto-waver will run.

ReportID

This is the generic report from the REP table where the orders are selected as potential candidates for the auto-waver.

WarehouseID

The warehouse ID in which the auto-waver will run.

Field

Description

Default

ATPType

Dictates if the auto-waver checks if there is enough stock available to fulfil the order.

It must be one of the following:

  • None

  • All Stock

  • Partial Stock

  • Pick Face Stock

None

Comment

A free text field that includes a comment on created waves.

"Auto Wave"

MaxCubic

The maximum cubic for a wave.

Infinity

MaxCustom

An arbitrary custom value that can be used to limit waves.

Infinity

MaxOrders

The maximum number of orders on a wave.

Infinity

MaxUnits

The maximum number of units for a wave.

Infinity

MaxWeight

The maximum weight for a wave.

Infinity

MinOrders

The minimum number of orders required for a wave.

1

PrinterCode

The printer where the wave label is printed.

Null

RunDays

Determines the days that the auto-waver will run:

  • Weekday - runs on weekdays Monday, Tuesday, Wednesday, Thursday, Friday

  • Weekend - runs on Saturday, Sunday

  • Array of days in 3 letter representation to specify the days to run. For example, "Mon", "Wed", "Fri"

"Weekday"

TenantID

Determines if the wave can only have orders for one specific tenant.

Null

WaveCreateMethod

The internal wave create method field in the database.

It is for internal use only to help identify wave streams.

"GENERIC_AUTOWAVE"

WavePickMethod

The wave method for the auto-waver.

It must be one of the following:

  • Bulk (Bulk to Manual)

  • Bulk To AutoConsign

  • Bulk Then Array Sort

  • Pick To Carton

  • Pick To Order

  • Pick To Tote

Bulk

WavePreferredPickZone

The preferred pick zones for the wave.

Null

WavePriority

The wave priority.

1
Copy 
{
  "BROKEN": [],
  "SYD-WHS-NO-TNT": {
    "WarehouseID": "11",
    "ReportID": "16",
    "RunDays": "",
    "WavePickMethod": "Bulk",
    "ATPType": "None",
    "RunTimes": ""
  },
  "SYD-WHS-NORMAL-TNT": {
    "WarehouseID": "11",
    "TenantID": "11",
    "ReportID": "16",
    "RunDays": [
      "Mon"
    ],
    "WavePickMethod": "Pick To Order",
    "ATPType": "None",
    "MinOrders": "1",
    "Comment": "Auto Wave",
    "WaveCreateMethod": "PACKING_AUTOWAVE_MANAGE",
    "WavePriority": "1",
    "MaxOrders": "2",
    "MaxWeight": "3",
    "MaxCubic": "4",
    "MaxUnits": "5",
    "MaxCustom": "6",
    "WavePreferredPickZones": [
      "1"
    ],
    "RunTimes": []
  },
  "SYD-WHS-WEIRD-TNT": {
    "WarehouseID": "11",
    "TenantID": "12",
    "ReportID": "16",
    "RunTimes": [
      "0000",
      "0000"
    ],
    "RunDays": "Weekend",
    "WavePickMethod": "Bulk Then Array Sort",
    "ATPType": "None",
    "MinOrders": "1",
    "Comment": "Auto Wave",
    "WaveCreateMethod": "PACKING_AUTOWAVE_MANAGE",
    "WavePriority": "1"
  },
  "SYD-WHS-BIZARRE-TNT": {
    "WarehouseID": "11",
    "TenantID": "13",
    "ReportID": "16",
    "RunTimes": [
      "0205"
    ],
    "RunDays": [],
    "WavePickMethod": "Pick To Carton",
    "ATPType": "None",
    "Comment": " ",
    "WaveCreateMethod": " ",
    "WavePriority": "1",
    "MinOrders": "1",
    "WavePreferredPickZones": [
      "asd",
      "blah",
      "123"
    ]
  },
  "CAN-WHS-NO-TNT": {
    "WarehouseID": "21",
    "ReportID": "16"
  },
  "CAN-WHS-NORMAL-TNT": {
    "WarehouseID": "21",
    "TenantID": "11",
    "ReportID": "16",
    "RunTimes": [
      "1111",
      "2359"
    ],
    "RunDays": [
      "Mon"
    ],
    "WavePickMethod": "Pick To Tote"
  },
  "CAN-WHS-WEIRD-TNT": {
    "WarehouseID": "21",
    "TenantID": "12",
    "ReportID": "16",
    "RunTimes": [
      "1111",
      "2359"
    ],
    "RunDays": "Weekend",
    "WavePickMethod": "Pick To Order"
  },
  "CAN-WHS-BIZARRE-TNT": {
    "WarehouseID": "21",
    "TenantID": "13",
    "ReportID": "16",
    "RunTimes": [
      "1111",
      "2359"
    ],
    "RunDays": [
      "Mon",
      "Tue",
      "Wed"
    ],
    "WavePickMethod": "Bulk Then Array Sort"
  },
  "NZ-WHS-NO-TNT": {
    "WarehouseID": "31",
    "ReportID": "16"
  },
  "NZ-WHS-NORMAL-TNT": {
    "WarehouseID": "31",
    "TenantID": "11",
    "ReportID": "16",
    "RunTimes": [
      "2222",
      "2359"
    ],
    "RunDays": [
      "Mon"
    ],
    "WavePickMethod": "Pick To Carton"
  },
  "NZ-WHS-WEIRD-TNT": {
    "WarehouseID": "31",
    "TenantID": "12",
    "ReportID": "16",
    "RunTimes": [
      "2222",
      "2359"
    ],
    "RunDays": "Weekend",
    "WavePickMethod": "Pick To Tote"
  },
  "NZ-WHS-BIZARRE-TNT": {
    "WarehouseID": "31",
    "TenantID": "13",
    "ReportID": "16",
    "RunTimes": [
      "2222",
      "2359"
    ],
    "RunDays": [
      "Mon",
      "Tue",
      "Wed"
    ],
    "WavePickMethod": "Pick To Order"
  }
}