Skip to content


Consolidations

Sequoia v1.189 onwards

In Sequoia, a Consolidation is used to group one or more Shipments which are being transported together.

Creating a Consolidation

There are a number of ways to create a consolidation.

By clicking the Consolidation button on the toolbar normally located at the top of Sequoia:

Toolbar Option

by right clicking in the Consolidation list within the Export module:

Context Menu Option

or from the File menu:

File Menu Option

The New Consolidation dialog will be displayed.

New Consolidation Dialog

Click the relevant icon to select the type of Consolidation you wish to create. A reference can be added - this could be your own internal reference and is shown in the list for identification purposes.

Click OK and the relevant Consolidation editor will be displayed.

Ocean

Sea freight Consolidation Editor)

Label Information required
Category Choose from Co-load or Master Bill of Lading.
Internal Ref This is your optional reference provided when creating the consolidation record.
Master B/L Master Bill of Lading number.
House B/L House Bill of Lading number.
Carrier The vessel operator. This is driven from standing data within Sequoia. The full list can be viewed from the Data menu (choose Ocean Carriers from the list).
Vessel The name of the vessel.
Voyage The voyage number.
Date The shipping date.
Consignor Enter the details of the shipper if required (or appropriate).
Consignee Enter the details of the importer if required (or appropriate).
Origin The UN/LOCODE of the port of Origin.
Destination The UN/LOCODE of the port of Destination.
Maximum Gross weight allowed This can be used to indicate if too many shipments have been linked with this consolidation.
Close-out Date/Time The date this consolidation is to be closed off.
MUCR The Master UCR to associate all DUCRs with. This should be in the format of GB/{EORI}-{Unique Reference}. Refer to the section on Finalisation a Consolidation.
MUCR Close Date/Time The time that the MUCR was closed on CHIEF.
Notes A place where you can enter any notes about this consolidation.

Air

Airfreight Consolidation Editor)

Label Information required
Category Choose from Co-load or Master Air Waybill.
Internal Ref This is your optional reference provided when creating the consolidation record.
Master AWB Master Air Waybill number.
House AWB House Air Waybill number.
Carrier The air carrier. This is driven from standing data within Sequoia. The full list can be viewed from the Data menu (choose Air Carriers from the list).
Flight The flight number.
Date The flight date.
Consignor Enter the details of the shipper if required (or appropriate).
Consignee Enter the details of the importer if required (or appropriate).
Origin The IATA code for the airport of Origin.
Destination The IATA code for the airport of Destination.
Maximum Gross weight allowed This can be used to indicate if too many shipments have been linked with this consolidation.
Close-out Date/Time The date this consolidation is to be closed off.
MUCR The Master UCR to associate all DUCRs with. This must be in the format of A:{AWB Prefix}{AWB Master}. Refer to the section on Finalisation a Consolidation.
MUCR Close Date/Time The time that the MUCR was closed on CHIEF.
Notes A place where you can enter any notes about this consolidation.

Road

Road freight Consolidation Editor)

Label Information required
Category Select Master from the drop-down.
Internal Ref This is your optional reference provided when creating the consolidation record.
Master This should be a unique reference number identifying this consolidation.
Vehicle Reg The vehicle registration number.
Trailer No. The trailer number if appropriate.
Date The shipping date.
Consignor Enter the details of the shipper if required (or appropriate).
Consignee Enter the details of the importer if required (or appropriate).
Origin The UN/LOCODE of the place of Origin.
Destination The UN/LOCODE of the place of Destination.
Maximum Gross weight allowed This can be used to indicate if too many shipments have been linked with this consolidation.
Close-out Date/Time The date this consolidation is to be closed off.
MUCR The Master UCR to associate all DUCRs with. This should be in the format of GB/{EORI}-{Unique Reference}. Refer to the section on Finalisation a Consolidation.
MUCR Close Date/Time The time that the MUCR was closed on CHIEF.
Notes A place where you can enter any notes about this consolidation.

Associating Shipments

Any number of shipments can be linked with the consolidation record.

To add an existing shipment, click the Add button on the Shipments toolbar.

Add Existing Shipment

This will display a list of shipments which are compatible with the consolidation and are available to be linked.

Existing Shipments

Optionally, you can create a new shipment record from the consolidation. Click the New button on the Shipments toolbar.

Create New Shipment

A new shipment editor will be displayed with details inherited from the consolidation.

Finalising a Consolidation

Currently, finalising a consolidation involves sending messages to HMRC's CHIEF system to associate all of the DUCRs (linked to the shipments) with the MUCR set on the consolidation record. The MUCR is therefore mandatory for this process.

A consolidation must be in a Finalised state before it can be linked with an NCTS transit movement - refer to NCTS - Create a movement and link consignments

Click the Finalise button on the toolbar to begin. The Finalising a Consolidation dialog will be displayed.

Finalise Consolidation

Add the date as indicated and click the Finalise button.

The consolidation status will update through [Finalisation in Progress] to [Consolidation Finalised] once all of the messages have been sent and acknowledged.

For the Ocean and Road environment, the requirement to associate the DUCRs to the MUCR is not generally required. Therefore a future release of Sequoia will remove this requirement - instead, on clicking the Finalise button on the toolbar (when the MUCR field is blank), the status of the consolidation will automatically be set to [Consolidation Finalised]. Associated shipments will also be finalised.