Invoice line query
The Invoice Line data provider/query returns the order related data relevant for a invoice. For receipt related information please use the receipt data providers.
The data provider can be used for building a invoice or even single page invoice RDL based template.
Filters
Administration | Filters on Administration. Single or multiple Administrations can be selected. | YES |
Invoice | Filters on the Invoice ID. The Invoice ID can be found in the Classic screen when on Invoice page, in the browser address bar after ‘Invoiceid=’, e.g. | YES |
Data provider settings
The following ‘Data provider settings’ can be set in Reports (Administration) for the query of a report. All settings must be separated by a semi-colon ';'. If not specified the default settings apply.
ShowStringInBarcode | Boolean | TRUE | Shows the barcode number as text below the barcode. See How to add a scannable barcode to the invoice. For example: |
IncludeCheckSumDigitInBarcode | Boolean | TRUE | Includes a checksum to ensure that if the invoice number changes, the barcode shows that the invoice has been changed. See How to add a scannable barcode to the invoice. |
BarcodeWidth | Integer | 200 | The width in pixels of the barcode image. See How to add a scannable barcode to the invoice. |
BarcodeHeight | Integer | 60 | The height in pixels of the barcode image. See How to add a scannable barcode to the invoice. |
BarcodeFont | String | Courier New | The font used to display the number text below the barcode. Note: ‘ShowStringInBarcode’ needs to be set to TRUE for this setting to have any effect. See How to add a scannable barcode to the invoice. |
BarcodeFontSize | Integer | 9 | The font size used to display the number text below the barcode. Note: ‘ShowStringInBarcode’ needs to be set to TRUE for this setting to have any effect. See How to add a scannable barcode to the invoice. |
Columns
AccountsReceivableAddressLine1 | ‘Accounts receivable address line 1’ defined in Administrations (Administration), see Administration (Fields). | Thermiekstraat 24 |
AccountsReceivableAddressLine2 | ‘Accounts receivable address line 2’ defined in Administrations (Administration), see Administration (Fields). | Schiphol Airport |
AccountsReceivableCity | ‘Accounts receivable city’ defined in Administrations (Administration), see Administration (Fields). | Amsterdam |
AccountsReceivableCountry | ‘Accounts receivable country’ defined in Administrations (Administration), see Administration (Fields). | Netherlands |
AccountsReceivableName | ‘Accounts receivable name’ defined in Administrations (Administration), see Administration (Fields). | FBO One |
AccountsReceivableVatNo | ‘Accounts receivable vatno’ defined in Administrations (Administration), see Administration (Fields). | NL 1234 5678 |
AccountsReceivableZipCode | ‘AccountsReceivableZipCode’ defined in Administrations (Administration), see Administration (Fields). | 1117 BG |
Charged currency code |
| EUR |
Debtor address |
| Air Charlie 13 |
Debtor address 1 |
| 11 Boulthurst Way |
Debtor address 2 |
| HURST GREEN |
Debtor city |
|
|
Debtor contact number |
| ROA001 |
Debtor country |
| United Kingdom |
Debtor Invoice Reference Number |
|
|
Debtor state |
| Surrey |
Debtor VAT number |
| - |
Debtor zip code |
| RH8 0HT |
DebtorName |
| Air Charlie 13 |
Form of payment name on invoice |
| Direct Debit |
Form of payment short name |
| DIRECT DEBIT EUR |
Invoice date formatted |
| 29-Oct-21 |
Invoice footer |
| VAT Registration No: GB 123 4567 89. FBO One is a subsidary of Regional Airport Ltd. |
Invoice grand total decimal |
| 0 |
Invoice grand total excl VAT decimal |
| 0 |
Invoice grand total excl VAT formatted |
| 0.00 |
Invoice grand total formatted |
| 0.00 |
Invoice grand total in words |
|
|
Invoice grand total in words caption |
| Invoice amount in words: |
Invoice grand total VAT decimal |
| 0 |
Invoice grand total VAT formatted |
| 0.00 |
Invoice header |
| VAT Registration Number: GB 123 4567 89 | Business Registration Number: 12345678 |
Invoice ID | The Invoice unique ID in GUID format. | b9bfbc6c-269d-4dcb-877b-7f76f90eb138 |
Invoice number | The invoice number. | 1014966 |
Invoice remarks |
| - MAKE ALL CHEQUES PAYABLE TO: MONEY TRANSFERS TO:
|
Invoice title | ‘Invoice title’ defined in Administrations (Administration), see Administration (Fields). | SUMMARY OF ORDER *TEST* |
InvoiceAmountDueDecimal |
| 0 |
InvoiceAmountDueFormatted |
| 0.00 |
InvoiceCreatedDateTimeLt |
| 12/10/2021 3:08:17 PM |
InvoiceCreatedDateTimeUtc |
| 12/10/2021 3:08:17 PM |
InvoiceGrandTotalInBookedCurrencyDecimal |
| 0 |
InvoiceGrandTotalInBookedCurrencyFormatted |
| 0.00 |
InvoiceGrandTotalVATInBookedCurrencyDecimal |
| 0 |
InvoiceGrandTotalVATInBookedCurrencyFormatted |
| 0.00 |
InvoiceInternalRemarks |
|
|
InvoiceNumberBarcode39 | Invoice number barcode. See How to add a scannable barcode to the invoice for more information. | |
Is credit invoice | Indicates if the invoice is a credit invoice with the grand total as a negative charged amount. | FALSE |
IsSinglePageInvoice | Indicates if the invoice is a single page invoice indicated by the following:
| TRUE |
LogoImage | Shows the logo defined in FBO location. See 'Report logo' field in FBO locations (Administration). | |
OperatorAddressExclName | Debtor address formatted - excluding name (defined in Add Organization - add/edit screen) showing the following:
| 4613 Phasellus Rd. |
OperatorNameExclContactNumber | The invoices opeator’s ‘Organization name’ defined in Add Organization - add/edit screen. | Air Charlie 13 |
Order description | Shows the Order description - applicable for invoice cover pages. Format: OrderReceiptTitle RegistrationCode | HandlingStationICAOCode | Order transaction date | Operator Handling Number | Debtor Order number If fuel only order: OrderReceiptTitle RegistrationCode | HandlingStationICAOCode | Order transaction date | Operator Handling Number | Debtor Order number | Ticket: FuelTicketNumber | FuelTicketDebtorOrderNumber | RECEIPT NXNAB | EGKB | 16-Mar-20 |
Order grand total excl VAT formatted |
| 0.00 |
Order grand total incl VAT formatted |
| 0.00 |
Order grand total VAT formatted |
| 0.00 |
Order ID | The Order unique ID in GUID format. For invoices containing more than one order (batch invoices), multiple Order IDs will show on individual rows. | af710d11-6159-4b34-8caf-88b735ed31be |
Order key | The Order key contained in the invoice. For invoices containing more than one order (batch invoices), multiple Order IDs will show on individual rows. | FBO-60066 |
Payment due date | Invoice due date based upon the invoice date plus the payment (credit) term days for the debtor. | 4/6/2020 12:00:00 AM |
Payment due date formatted | Invoice due date based upon the invoice date plus the payment (credit) term days for the debtor. Outputted in text format using the 'ShortDateFormatString' application/FBO location setting. | 30-Oct-21 |
Payment term days | Payment (credit) term in days for the invoice to be paid, defined by the debtor’s contract. | 30 |
Payment term description | Payment (credit) term in days for the invoice to be paid, defined by the debtor’s contract, along with the due date formatted (using the ‘ShortDateFormatString' application/FBO location setting). Will show 'On delivery’ if debtor has 0 days of credit. | 30 days (06-Apr-20) |
QRCode |
|
|
See also
Invoice VAT subtotal line query