Special Features: Containers Report Category

Here you can view all the data on the containers in use or returned by your company.

To view the Containers report category

1. Click Business Intelligence>Reports.
2. Select Containers report category.

Figure 1

Before generating a report, make sure that

1. You’re using the right Company account.
   (For more details, please see Business Intelligence: Reports Section article.)
   
2. You have checked the Data for multiple companies: section and have selected all the companies for which you are looking to get the data .
   (For more details, please see Common Features: Data for Multiple Companies article.)
3. Filters and Additional Filters are set.
   (To set the Filters and Additional Filters follow the steps described in Filter by and Additional Filters.)

Once 

Once all filters are set, generate a report and use report table features to view and analyze the report online or use the provided options to download or save it to preferred file formats.
(For more details on report table features, please see Common Features: Report Table article.)

Figure 2

Create Schedule

This feature allows you to automate your reporting process, saving time and effort. With the Report Scheduler, you can schedule the generation and delivery of reports at the preferred intervals (even multiple schedules per day) and the preferred format (CSV or Excel) having the required information at hand.  You can find he details on the creation of the schedule in Create Schedule, in Special Features: Shipments Report Category. 

Filter by

To filter the data according to the Event type

1. From the Event Date drop-down menu select the Event type according to which you want to filter the data.
   In the generated report only those containers will be reflected, in which the selected Event is present, i.e., those with no record of the selected Event will be excluded. 
2. Choose the date range from the provided options, or select Custom and use the calendars to select From and To dates.
   The report will show all the data where the selected Event type (Step 1) matches the selected date range.
3. To filter the data per Carrier, Country of Origin, or Destination Country, use the drop-down menus of the respective fields.
   By default, all carriers are selected. If you want to get the data per specific carrier(s) use the drop-down menu to unselect all and select the one(s) you need.
4. Type in the Location Names or the UN Codes (UN/LOCODE) for the Origin and the Destination if you want to get the data filtered accordingly.

 

Figure 3

Figure 4

---

Additional Filters

Additional Filters allow you to filter the data by

• Your role in the shipment 
• Companies
• Business Partners

as well as add the following fields to the report: 

• Parties (Business Partners)
• Container Parties (checkbox) - parties that deal with containers and are mentioned in the Shipment, e.g., Destination Handling Agents, Delivery Location, etc.
• Custom Fields (checkbox)
• Linked Order Party Refs (checkbox)
• Shipment TP Legs (checkbox)
• Stuffing Items (checkbox)
• Emissions 

---

Select Your Role in Shipment

1. Select Additional Filters.
2. Select one of the three filter options:
   • My Shipments — Shipments created by you or by companies selected in Data for Multiple Companies.
   • Observer — Shipments where you or the companies selected in Data for Multiple Companies are added as Further Parties.
   • All — This option includes the above-mentioned two filter options and is selected by default.
3. Click Apply.

Figure 5

Select Companies

1. Select Additional Filters.
2. Under Companies, select all required ones from the searchable drop down (current company is selected by default).
3. Click Apply.

Figure 6

Select Business Partners

In Additional Filters you will notice Business Partners Field. Here when you select certain companies from the drop-down, the report will display only the shipments/containers that have at least 1 party from the list of selected companies. 

The list contains BPs of the selected Company or multiple companies (from the “Data for multiple companies” dropdown list) and companies selected from “Companies” additional filter. 

1. Select Additional Filters.
2. Under Business Partners, select all required ones from the searchable drop down (all BPs are selected by default).  
3. Click Apply.

Figure 7 

Show in Report: Parties

Under Show in Report you will notice a drop-down list for Parties (Business Partners). 

By default, the below-mentioned 7 (seven) Parties (Business Partners) are selected and will be reflected in the report only if there is any information about them.

• Buyer
• Supplier
• Shipper
• Consignee
• Booking Agent;
• Origin Handling Agent 
• Destination Handling Agent

To modify the default selection or to add more Parties

1. Select Additional Filters.
2. Open the Parties drop-down menu and select more Parties or deselect the default selected options.
3. Click Apply.

Figure 8

Container Parties

• Select the Container Parties checkbox, if you want the report to reflect the relevant information (see Figure 9).

The field(s) will be added per Party only if there is any data about the Container Parties.

Custom Fields 

Linked Orders Party Refs 

Stuffing Items

• Select the Stuffing Items checkbox, if you want the report to reflect the following information on stuffing items:

1. item article code
2. item article description
3. item order reference
4. item commodity
5. item package count
6. item gross weight 
7. item net weight 
8. item volume
9. item description
10. custom stuffing attributes
11. status
12. container seal number 
13. container tracker number 

Every stuffing item is displayed in a separate row. 

Item components data are concatenated on an item level, while the rest of container data is just duplicated.

The field(s) will be added only if there is any data about the container stuffing

Emissions 

• Select the Emissions checkbox, if you want the report to reflect the following information on CO₂ emissions (see Figure 9)

1. Data Provider (currently ECOTRANSIT and CLEAN CARGO) (data from the provider is displayed only if at least one container has respective data)
2. Travelled distance (km) and the amount of emissions (tons) for each shipping stage (sum of all legs of the stage) 

Shipment TP Legs 

• Select the Shipment TP Legs checkbox, if you want the report to reflect the relevant information.
• The field(s) will be added only if there is any data about the Shipment TP Legs.

Figure 9

To download the print version of this article, click the PDF icon: