Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview


Excerpt

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:

Ui steps
sizesmall


Ui step

Go to "A/P" tab > Click on "AWB Reconciliation" tab > Using the filters find the information to export.


Ui step

 Click on "Export Details" button.


Ui step

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.


Ui step

The next step is to select the way how you want the report to be generated. There are two available options: Detailed and Consolidated. If you select Consolidated, the report will group per AWB and invoice # the registries having Freight, Handling or Duties in a single line. Download an example. If you select Detailed, the system will display a single line for each cost component, even if they belong to the same AWB. Download an example.


Ui step

 Enter the email address where the report should be sent. Once entered, click on Save.


Ui step

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 to generate the information on the report.

Image Modified



Panel
titleRelated Articles

Filter by label (Content by label)
showLabelsfalse
max10
showSpacefalse
sorttitle
cqllabel in ("accounting","awb-reconciliation","export-details")
labelsaccounting export-details awb-reconciliation


Info
titleThis report will include the following information


Ui text box
sizemedium

(lightbulb) Roles enabled to perform this action: Admin, Accounts Payable.