Overview

The system allows users to export an Excel file with the information on the AWB Reconciliation tab. This report can be generated in two different ways in order to include only relevant information for your company. 

Instructions:

To export the report follow the steps below:

1. Go to "A/P" tab > Click on "AWB Reconciliation" tab > Using the filters find the information to export.
2. Click on "Export Details" button.
   
   
   
   
3. A Send Report window will pop up. The system will ask you about cost components to be included in the report. There are four options available: All, Freight, Handling, and Duties. Keep in mind that these options work as filters, so if you select for example Duties, the system will include only the registers per AWB having duties.
   
4. The system will also ask you how do you want the report to be generated. There are two available options: Detailed and Consolidated. If you select Consolidate the report will group per AWB and invoice # the registers having Freight, Handling or Duties in a single line.
   
   
   
   If you select Detailed, the system will separate in different lines the registers with Freight, Handling, and Duties, even if they belong to the same AWB.
   
   
   
5. Enter the email address where the report should be sent. Once entered, click on Save. 
   
   
   
   
6. The report will be sent to the email provided by the user. The Excel file shows the complete column information on the AWB Reconciliation page. The system takes into account the search filters used by the user to generate the information on the report.
   The report will include the following information: