AccountStatement query

Contents:

Filters:

Filter

Description

Mandatory

Filter

Description

Mandatory

Administration

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

NO

Invoice date on or after / Invoice date before

Filter between Invoice on or after date and Invoice before date, use both on or after and before to create a date range. Note: Leaving both fields blank will show all invoices for a debtor.

NO

Debtor

Filters on an invoice’s debtor contact. Mandatory field.

YES

Due invoices only

Filters due invoices only (invoice past their due date). Default = No

NO

Data provider settings:

There are no data provider settings for this query.

Columns:

Name

Description

Example

Name

Description

Example

AccountsReceivableAddressFormatted

Accounts receivable address formatted (defined in Administrations (Administration)) showing the following:

  • AccountsReceivableName

  • AccountsReceivableAddressLine1

  • AccountsReceivableAddressLine2

  • AccountsReceivableZipCode AccountsReceivableCity

  • AccountsReceivableCountry

Handling Office
Room 212, Terminal 2
Copenhagen Airport
DK1234 Copenhagen
Denmark

AccountsReceivableAddressLine1

‘Accounts receivable address line 1’ defined in Administrations (Administration), see Administration (Fields).

Room 212, Terminal 2

AccountsReceivableAddressLine2

‘Accounts receivable address line 2’ defined in Administrations (Administration), see Administration (Fields).

Copenhagen Airport

AccountsReceivableCity

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

Copenhagen

AccountsReceivableCountry

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

Denmark

AccountsReceivableName

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

Handling Office

AccountsReceivableVatNo

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

DK1234567

AccountsReceivableZipCode

‘AccountsReceivableZipCode’ defined in Administrations (Administration), see Administration (Fields).

DK0000

AdministrationGroupName

The Administration Group used to generate the report. See Customer Account Statement Reports (Administration), and ‘Administration group’ field.

Denmark & Sweden

AdministrationId

The Administration's unique ID in GUID format.

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

AdministrationName

The Administration name.

Handling Office

Bank

Bank for the FBO location defined by ‘Bank’ field in Report Settings (Settings) / FBO locations (Administration).

Nordea Bank

BankAccountNo

Bank account number for the FBO location defined by ‘BankAccountNo’ field in Report Settings (Settings) / FBO locations (Administration).

12345678

BookingCurrency

Booking currency taken from the Administration.

EUR

DaysPastDue

Days (as of now) an invoice is past it’s due date defined by the debtor’s credit term.

0

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;

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

Email

Email for the FBO location defined by ‘Email’ field in Report Settings (Settings) / FBO locations (Administration).

ops@handling.com

EmailAc

EmailAc for the FBO location defined by ‘EmailAc’ field in Report Settings (Settings) / FBO locations (Administration).

acc@handling.com

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

FooterInformation

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

For questions regarding these invoices, please contact acc@handling.com On payment please state Invoice number

FormOfPaymentCode

Displays ‘Short name’ for the form of payment for the invoice, defined in Forms of payment (Administration).

INVOICE

Header

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

Due invoices

HeaderInformation

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

 

Iban

IBAN for the FBO location defined by ‘IBAN’ field in Report Settings (Settings) / FBO locations (Administration).

DE12345678

InvoiceAmountDue

Total amount due for an invoice (unpaid amount) in invoice currency.

1000

InvoiceAmountDueInBookingCurrency

Total amount due for an invoice (unpaid amount) in booking currency.

1100

InvoiceAmountPaid

Total amount paid for an invoice in invoice currency.

1000

InvoiceAmountPaidInBookingCurrency

Total amount paid for an invoice in booking currency.

1100

InvoiceCurrency

Currency of the invoice. See How to Invoice in a new Currency - Creating New Currencies & Forms of Payment.

EUR

InvoiceDate

'Invoice date' displayed on the invoice.

05-Jul-20

InvoiceDateFormatted

'Invoice date' displayed on the invoice formatted.

05-Jul-20

InvoiceDueDate

Invoice due date based upon the invoice date plus the credit term days of the debtor.

04-Aug-20

InvoiceDueDateFormatted

Invoice due date formatted based upon the invoice date plus the credit term days of the debtor.

04-Aug-20

InvoiceGrandTotal

Grand total amount of the invoice in invoice currency.

1000

InvoiceGrandTotalInBookingCurrency

Grand total amount of the invoice in booking currency.

1100

InvoiceId

The invoice’s unique ID in GUID format.

d34aafca-90e3-4a9e-933f-8db0347bccaa

InvoiceNumber

The invoice number. See ID Generators (Administration).

100367

InvoiceState

The current invoice workflow state. See Invoice workflows (Administration).

AWAITING PAYMENT

LogoImage

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

OrdersCount

Count of orders contained within a single invoice.

1

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

Swift

SWIFT for the FBO location defined by ‘SWIFT’ field in Report Settings (Settings) / FBO locations (Administration).

NDEAABCD