Aging query

Contents:

Filters:

Filter

Description

Mandatory

Filter

Description

Mandatory

Administration

Filters on Administration. Single or multiple Administrations can be selected.

NO

Debtor

Filters on an invoice’s debtor contact.

NO

Data provider settings:

There are no data provider settings for this query.

Columns:

Name

Description

Example

Name

Description

Example

AccountsReceivableName

‘Accounts receivable name’ defined in Administrations (Administration), see Administration (Fields).

Handling Office

AdministrationId

The Administration's unique ID in GUID format.

9bf6dcf7-ac35-46eb-8a5a-f60ec90ff9f3

AdministrationName

The Administration name.

Handling Office

AmountDue1To30InBookingCurrency

Total amount due for invoices overdue by 1 to 30 days (from invoice date) in booking currency for each debtor.

10000

AmountDue31To60InBookingCurrency

Total amount due for invoices overdue by 31 to 60 days (from invoice date) in booking currency for each debtor.

12000

AmountDue61To90InBookingCurrency

Total amount due for invoices overdue by 61 to 90 days (from invoice date) in booking currency for each debtor.

14000

AmountDue91PlusInBookingCurrency

Total amount due for invoices overdue by 91 days and over (from invoice date) in booking currency for each debtor.

22000

AmountNotYetDueInBookingCurrency

Total amount not yet due for invoices in booking currency for each debtor.

8000

BookingCurrency

Booking currency taken from the Administration.

EUR

DebtorAddress

Debtor address formatted (defined in Add Organization - add/edit screen) showing the following:

  • Address 1

  • Address 2

  • Zipcode City State

  • Country

EDIFICIO CRISTAL
RUA CALVET MAGALHAES 245, BLOCO B
2774-550 PACO DE ARCOS, Lisboa
Portugal

DebtorAddressFormatted

Debtor address formatted (defined in Add Organization - add/edit screen) showing the following:

  • Organization name

  • Address 1

  • Address 2

  • Zipcode City State

  • Country

NetJets Transportes Aéreos, S.A.
EDIFICIO CRISTAL
RUA CALVET MAGALHAES 245, BLOCO B
2774-550 PACO DE ARCOS, Lisboa
Portugal

DebtorCityAndCountry

Debtor’s ‘City’ and 'Country' defined in Add Organization - add/edit screen.

PACO DE ARCOS, Portugal

DebtorContactNumber

Debtor’s ‘Contact number’ defined in Add Organization - add/edit screen.

100005

DebtorEmail

Debtor’s ‘Email 2 (Back office)’ defined in Add Organization - add/edit screen.

acc@test.com;

DebtorId

The Debtor’s unique ID in GUID format.

ba2ec4b3-4469-41aa-ae85-bb4bec8a43ca

DebtorName

Debtor’s ‘Organization name’ defined in Add Organization - add/edit screen.

NetJets Transportes Aéreos, S.A.

DebtorPhoneFax

Debtor’s ‘Phone 1’ and ‘Fax’ defined in Add Organization - add/edit screen.

+351 123456789 +351 123457891

DebtorShortName

Debtor’s ‘Short name’ defined in Add Organization - add/edit screen.

Netjets EU

Footer

Displays ‘BatchInvoice-Footer’ defined in Report Settings (Settings) / FBO locations (Administration), see Email template variables for additional variables.

Copenhagen Airport | DK1234 Copenhagen | Denmark

Bank | Account 00000000 | IBAN DK0000000000 |

acc@test.com | www.handling.com | Tel. +45 1234 5678"

InvoicesCount

The count of invoices for the debtor.

25

LogoImage

‘Report logo’ image defined in FBO locations (Administration).

PeriodBeforeDate

The invoice before/end date defined by the ‘Invoice date before’ filter. If not defined then 31-Dec-99 will show.

31-Dec-99

PeriodBeforeDateFormatted

The invoice date formatted before defined by the ‘Invoice date before’ filter. If not defined then 31-Dec-99 will show.

31-Dec-99

PeriodStartDate

The invoice on or after/start date defined by the ‘Invoice date on or after’ filter. If not defined then ‘AccountStatementsCutOffDate’ date will show, defined in Administrations (Administration).

01-Jan-20

PeriodStartDateFormatted

The invoice on or after/start date defined by the ‘Invoice date on or after’ filter. If not defined then ‘AccountStatementsCutOffDate’ date will show, defined in Administrations (Administration).

01-Jan-20

TotalAmountDueInBookingCurrency

Total amount due for all invoices (unpaid amount) in booking currency for each debtor.

1100

TotalPastDueAmountInBookingCurrency

Total amount past due for all invoices in booking currency for each debtor.

1000