The Receipt Line data provider/query returns the order lines and order related data relevant for a receipt or a single page invoice.
The data provider can be used for building a receipt/invoice or even single page invoice RDL based template.
|Table of Contents|
This query can return each receipt line for multiple orders. For a single order, filter by Order with OrderID.
Filters on Administration. Single or multiple Administrations can be selected.
Filters on FBO location. Single or multiple FBO locations can be selected.
Filter by Handling station.
ReceiptAudience(string, default = "OperatorsCopy", possible values = "OperatorsCopy", "InvoiceAttachedReceipt")
This setting prepares the audience type of the receipt.
Take Comms One Services
Filter to show Comms One services.
Filter by date and time in UTC or LT of an order’s arrival or departure, use both on or after and before to create a data range. Note: ‘Arrival or departure date time’ UTC and LT filters cannot be used together.
Transaction date LT on or after / Transaction date LT before
Filter between order transaction on or after date and order transaction before date (last calculated date), use both on or after and before to create a data range.
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 data range.
Filter between Supplier invoice on or after date and before date, use both on or after and before to create a data range.
Filter between Supplier invoice on or after creation date and before creation date, use both on or after and before to create a data range.
Debtor or operator
Filter by contact present on an order’s debtor or operator field.
Filters on an order’s debtor contact.
Filters on an order’s Operator contact.
Debtor's order number
Filter on an order’s ‘Debtor’s order number’.
Filter by an order’s aircraft type.
Filter by orderline supplier.
Filter by an order’s aircraft registration.
Filter by product code.
Filters on entry periods. See Entry periods (Back office).
Filters on the Order ID. The Order ID can be found in the Classic screens when on Order page, in the browser address bar after ‘Orderid=’, e.g.
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.
Filters on the Entry ID. The Entry ID can be found in the Classic screen when on entry page, in the browser address bar after ‘Entryid=’, e.g.
Filter by supplier invoice number.
Indicates if the report should show rows that are collapsed to the customer.
Indicates the receipt audience.
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.
Indicates the receipt audience. Possible values
This setting allows to display detailed child order line services and prices.
The following settings defined for the Orders Query are also available here:
Recalculates all open orders that match the filter. This will make sure that any orders that are not yet invoiced are up to date. Each order is normally recalculated and stored when viewed in the order screen. An order may be out of date since it was last viewed, for example if a price agreement has been changed since.
If Cancelled orders should be included in the report.
This allows to add some days to the 'before' parameter. Note: Extra days are added to the following filters only: Arrival or departure date time, Transaction Date and Invoice date. Useful for daily reports that should span more than the default single day.
When set to true, it allows to add OTC orders which do not have flight legs into a order report based on the arrival/departure filter. The Arrival/Departure date filter will match on OTC order start time fields.
When set to true, it allows to add OTC orders which do not have flight legs into a order report based on the arrival/departure filter. The Arrival/Departure date filter will match on OTC order end time fields.
Whether or not orders in a particular stage should be included in the report. If not specified, orders being in front or in back office stage will be included. Possible values: Quote, FrontOffice, BackOffice, FrontAndBackOffice
When setting this to false, the query will return only a set of orders that are not in a workflow end state. A typical workflow end state is the order invoiced state. For example you can use this setting when you need to report on all orders that haven’t been yet invoiced.
NL 1234 5678
Cessna Citation XLS - C56X (CITATION XLS)
AOC expiry date
AOC number and expiry date
Arrival datetime LT
Arrival datetime UTC
Arrival Or Departure
Charged currency code
Oscar Avia 13
Debtor address 1
67a Victoria Road
Debtor address 2
Debtor contact number
Oscar Avia 13
Debtor order number
Debtor VAT number
Debtor zip code
Oscar Avia 13
Departure datetime LT
Departure datetime UTC
Form of payment for amount due
Form of payment for amount due caption
Form of payment for balance due
Grand total decimal
Grand total excl VAT decimal
Grand total excl VAT formatted
Grand total formatted
Grand total in words
Grand total in words caption
Order amount in words:
Grand total VAT decimal
Grand total VAT formatted
EGKB/BQH (Biggin Hill)
Handling office name
FBO One Airport
Has unit and quantity
Inbound flight leg description
Arrival from GMMX on 1-Jan-18 16:00 (UTC), 2 (? transit) pax
The Invoice unique ID in GUID format.
The invoice number.
Invoice number and date
Line item description
HANDLING FEES GROUP | Handling Fees
Net quantity formatted
Oscar Avia 13 (RCA012)
67a Victoria Road
Oscar Avia 13
The Order unique ID in GUID format.
The Order key contained in the invoice.
Order line ID
Outbound flight leg description
Departure to - on -, 0 pax
Payment term days
Payment term description
30 days (31-Jan-18)
Payment term due date
HANDLING FEES GROUP
VAT Registration No: GB 123 4567 89. FBO One is a subsidary of Regional Airports Ltd.
VAT Registration Number: GB 123 4567 89 | Business Registration Number: 12345678
Please direct enquiries to: Handling@fbo.one or Accounts@fbo.one
MONEY TRANSFERS TO:
Registration code and type name
DAWXL | Cessna Citation XLS - C56X (CITATION XLS)
Service date formatted
Service datetime LT
Show as headline
Show price to audience
Unit price decimal
Unit price formatted
VAT amount decimal
VAT amount formatted
VAT code percentage formatted