K2 logo

Integration between Ongoing Warehouse and K2

K2 is a transportation administration system made by Fleet101 that allows you to streamline the management of your freight assignments.

Features

Make transport bookings directly from Ongoing

You can create an order in K2 either from an order or a shipment in Ongoing. You find information about how the orders/shipments are mapped below.

Make tracking information visible in Ongoing

When the order in K2 has been created Ongoing will receive a response from K2. Depending on the transporter and your K2 settings the response might contain one or both the following information:

Create an order in K2 based on an invoice in Ongoing

An invoice in Ongoing can be transferred as an order in K2 to get the charges in Ongoing to K2. This is not part of the default set up. Please ask your contact person at Ongoing for more information.

Default settings and considerations

The integration provides default settings which are suitable in most cases. However, there are some possibilities for customization.

  1. Should the order in K2 be created based on orders or shipments in Ongoing?
    Default: Orders.
  2. When should the order/shipment be sent to K2?
    Default: when the send-button is pressed in Ongoing.
  3. Should you be able to create a K2 order based on an invoice in Ongoing?
    Default: No.

Preparations

Ongoing needs the following API keys from K2:

  1. URL
  2. User Name
  3. Password

Mapping (using order)

None* = those fields are not in the default set up, but it is easy to set them to any field in Ongoing.

Mapping K2 order - Ongoing Order

K2 Ongoing
Extra Id1 None*
Freight Bill Number Waybill
Project Number Reference Number
Senders Reference Order ID
Receivers Reference None*
Message Order Comment
Senders Instruction Order Comment
Customer Project None*
Transporter Date Delivery Date
Pricing Weight Sum of weight of freight row or items on order
Weight Sum of weight of freight row or items on order
Area Sum of freight row area
Load Meter Freight row load meter
Volume Sum of freight row volume
Package Count Sum of number of packages on freight rows
Agreement Code Invoicing/Article Code (on transporter agreement)
Customer Reference Reference Number

Mapping K2 packages from Ongoing freight rows. Each freight row in Ongoing will generate a package in K2.

K2 Ongoing
Height Height
Width Width
Length Length
Depth Depth
Weight Weight
Volume Volume
Quantity Number of Packages
Load Meters Load Meters
Package ID Goods Item Label ID
Package Type Package Type Code
Goods Type Goods Comment
Text None*

Mapping of the pick-up address in K2 - the data is taken from the consignor in Ongoing (warehouse address)

K2 Ongoing
CityCity
NameGoods Owner Name c/o Consignor Name
Phone NumberTelephone + mobile phone
Street AddressAddress
CompanyAddress 2
ZIP CodeZIP code
Customer CodeNone*
InfoNone*

Mapping of the delivery address in K2 - the data is taken from the consignee delivery address in Ongoing

K2 Ongoing
CityCity
NameName
Phone NumberTelephone + mobile phone. The numbers are only added if notify by SMS or notify by telephone is set in Ongoing
Street AddressAddress
CompanyAddress 2
ZIP CodeZIP code
InfoNone*

Mapping (using shipment)

None* = those fields are not in the default set up, but it is easy to set them to any field in Ongoing.

Mapping K2 order - Ongoing Shipment

K2 Ongoing
Freight Bill Number Waybill
Senders Reference "S" + Shipment ID
Message Order Comment
Senders Instruction None*
Weight Sum of weight of freight row
Pricing Weight Sum of weight of freight row
Load Meter Freight row load meter
Volume Sum of freight row volume
Package Count Sum of number of packages on freight rows
Transport Date Delivery Date or today if delivery date is missing

Mapping K2 packages from Ongoing freight rows. Each freight row on the shipment in Ongoing will generate a package in K2.

K2 Ongoing
Height Height
Width Width
Length Length
Depth Depth
Weight Weight
Volume Volume
Quantity Number of Packages
Load Meters Load Meters
Package ID Goods Item Label ID
Package Type Package Type Code
Goods Type Goods Mark
Text None*

Mapping of the delivery address in K2 - the data is taken from the consignee delivery address in Ongoing

K2 Ongoing
CityCity
NameConsignee Name
Phone NumberTelephone + mobile phone
Street AddressAddress
CompanyAddress 2
ZIP CodeZIP code