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

 Click on "Export Details" button.

Image Removed


Ui step
A

Send Report

window

 window will pop up. The

system will

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

example Duties, the system will include only the registers per AWB having duties.

Image Removed


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 Consolidate 

select Consolidated, the report will group per AWB and invoice # the

registers

registries having Freight, Handling or Duties in a single line

.
Image Removed

. Download an example. If you

select

select Detailed, the system will display a single line for each cost component, even if they belong to the same AWB.


Image Removed
Enter

Download an example.


Ui step

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

 

Image Removed


Ui step

The report will be sent to the email provided by the user. The Excel file shows the complete column information on

the

the AWB Reconciliation

page

 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:
Image Removed

Image Added



Panel
titleRelated Articles

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


Info
titleThis report will include the following information

Image Added


 
Ui text box
sizemedium

(lightbulb) 

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


We've encountered an issue exporting this macro. Please try exporting this page again later.