The Table Invoices

The table Invoices provides direct access to the generated invoices, as opposed to the table Invoice Cycle > Invoices, which shows the invoices for the selected invoice cycle. The only operation on invoices allowed in this table is to print them.

  • Station:*

Station to which this configuration applies; this column is only shown if you are logged in above station level.

  • Inv. Cycle ID:

Reference number of the Invoice Cycle

  • Invoice Type:

Invoice type (Invoice, Cash, Credit, Debit). This type is selected in the table Invoice Cycle for each individual invoice run.

  • State SIS:

Status of the invoice on the IATA SIS Interface; can be Initial, Transferred, Cancelled

  • State ERP:

Status of the data export to the external accounting system

  • Settlement Method:

Settlement of the invoice for IATA SIS Interface; for values please refer to paragraph IATA SIS: Settlement Method.

  • No.:

Lists the unique serial invoice number which is also automatically assigned.

  • Price:

Complete price of all services subsumed in the invoice (without VAT).

  • Price With VAT:

Complete price of all services subsumed in the invoice including any applicable VAT.

  • Inv. Template:

Different invoice templates (e.g. with/without appendices or different languages, etc.). Invoice templates are provided by topsystem.

  • Invoice Date:

Billing date which is printed on the invoice documents.

  • Booking Date:

Booking date which is to be forwarded to an external financial accounting system.

  • Currency:

Currency used in the invoicing documents.

  • Invoice Recipient:

ID of invoice recipient

  • Remark:

Freely definable comment

  • Invoice Variable:

Invoice variable to be selected from the pull-down menu

  • Print Grouping:

Pull-down menu allowing to sort the printout By Rotation or By Service

  • Print Duplicate:

Print a second bill (watermarked)

IATA SIS: Settlement Method
The read-only field Settlement Method has been introduced which describes the method of settlement of the invoice. Possible values are:

  • I = ICH

  • A = ACH

  • B = Bilateral

  • R = Adjustment due to protests

  • M = ACH Inter-clearance Billings or ACH Billings following RAM rules

It is calculated during the invoice creation process according to the following rules:

  1. If "I" the Billing Entity should be an ICH Member or a Dual Clearing House Member and the Billed Entity should be an ACH Member or a Dual Clearing House Member.

  2. If "A" the Billing Entity should be an ACH Member or a Dual Clearing House Member and the Billed Entity should be an ACH Member or a Dual Clearing House Member.

(Any exception defined in the Billing Entity's Profile for rules defined in 1 and 2 will be taken into consideration before raising a validation error.)

SIS Export

During a hotrun the SIS state of an invoice is set to To be Transferred if both – the seller and the invoice recipient – are clearing house members.

In this way the invoice is marked for the SIS export, which can be started in module Billing, Table Invoices.

The export file is created by user request with the following steps:

The invoices to be exported for the desired billing period are selected by entering the start and end dates of the billing period as Invoice Date Start and Invoice Date End into the Search panel. The billing periods are defined by IATA published as calendar to the IATA Clearing House Members. The user has to type in the correct start and closure day of the desired billing period according to the IATA Calendar and press the button Search images/download/thumbnails/286688074/2020-08-04_12_23_23-Window.png .

Then mark the invoices for export by highlighting them and start the SIS export by pressing the button SIS-Export images/download/thumbnails/286688074/2020-11-30_11_25_40-EPG_GHS___Billing___Invoice_Cycle.png .

Only the selected hotrun invoices which are not exported so far (State SIS = To be Transferred) are taken into consideration for the export.

After successful export the invoices will be tagged with the transfer flag in the database (State SIS = Transferred).

In case of error the transfer flag of all invoices of the transmission will not be set and an error file is located in the error output directory.

Please note:
The addresses of buyer and seller organisation are determined as follows:

  1. The system checks for an address entry of type Invoice in master data Contract > Customer > Address (first on station level, then on country level, finally on holding level).

  2. If there is no such entry, the system checks for an address entry of type Standard (first on station level, then on country level, finally on holding level).

  3. If there is no such entry either, the export cannot be generated and the system informs the user.