ISR in sales invoices

QR-bills replace the ISR as of June 30, 2020. However, invoices with ISR can still be generated during a transitional period.

You can generate ISR or QR sales invoices. This is defined at the company level.

In the sales process, the ISR reference number is generated when you print the invoices, and the ISR Inpayment slip is printed on the invoice form. This functionality is available in the Sales invoices (GESSIH) and A/P-A/R accounting Customer invoices (GESBIC) modules, but not for intercompany invoices.

The ISR reference line, which is printed as part of the ISR Inpayment slip, is printed with the font "OCR-B.” This font is not delivered with Sage X3. You need to install the font on the print server. The invoice forms delivered with Sage X3 are prepared for ISR printing, but you need to customize them depending on the printer.

Prerequisites

Configuring the ISR reference number structure

ISR and QR reference number are using the same configuration parameters.

The ISR reference number is always 27 or 16 digits. The length to use needs to be agreed on with the bank.

The information included in the reference number is defined by the setup configuration. Because the last character is an automatically calculated check digit, the distribution of the first 26, or 15 characters, can be configured.

The configurable part can consist of up to 4 components. The position and length are variable. For each component, there are two parameters in the LOC chapter, SWI group that each contain the start and the end position in the generated ISR reference number.

The following content can be included in the reference number.

  • ISR customer identification ([F:BAN]BVRCUSTID)
    BVRSTRIDT - From Swiss ISR/QR identifier
    BVRENDIDT - To Swiss ISR/QR identifier
  • Invoice date (F:SIH]ACCDAT)
    BVRSTRDAT - Swiss ISR/QR start date
    BVRENDDAT - Swiss ISR/QR end date
  • Customer number ([F:SIH]BPRPAY)
    BVRSTRBPC - From Swiss ISR/QR customer number
    BVRENDBPC - To Swiss ISR/QR customer number
  • Invoice number (F:SIH]NUM)
    BVRSTRINV - From Swiss ISR/QR invoice
    BVRENDINV - To Swiss ISR/QR invoice

If a certain element should not be written in the ISR reference number, both the start position and the end position must be configured with 0.

The standard settings are:

  • ISR customer identification: Position 1 to 6
  • Invoice date: Position 7 to 10
  • Customer number: Position 11 to 16
  • Invoice number: Position 17 to 26

If the content of an element is shorter than the configured length, it is filled with leading zeros.

The ISR reference number is always numeric. If a component, such as an invoice or customer number, contains letters or special characters, it is written in the reference line as a string that only contains zeros. It is therefore strongly recommended to use numeric customer and invoice numbers.

Bank determination for payments

To print the ISR Inpayment slip, the company’s bank details, to which the customer payment is made, are required. The determination of this company bank follows this hierarchy:

  1. Company information of business partner: Payment bank ISR/QR field (PAYBANBVR field in the BPEXCEPT table)
  2. Payment bank setting of the customer: Payment bank field (PAYBAN field in the BPCUSTOMER table).
  3. Payment bank of the site: Payment bank field (PAYBAN field in the FACILITY table).

Prerequisites for printing

The following information is required for printing the ISR Inpayment slip:

  • ISR/QR reference number: automatically generated from the invoice and common data while saving an invoice according to the configuration parameters for the structure of the reference number
  • Payment bank ISR/QR: automatically determined and can be overwritten depending on the transaction settings
  • ISR customer no. and ISR customer identification of the payment bank: entered in the bank management for the company bank (see Bank details for the company). In the ISR customer no. field, enter the PostFinance ISR customer no.

    If you do not handle ISR with a PostFinance account, but with another external account, your bank will tell you the ISR customer number to use and an additional ISR customer identification that needs to be used for the ISR reference number generation. Enter the ISR customer identification in the Customer ID ISR field.

  • Address of the recipient: determined by the payment bank
  • Address of the pay-by: determined by the invoice
The display of the ISR/QR reference number and the payment bank ISR/QR can be configured for each Sales invoice transaction (GESSLI) by selecting the ISR/QR reference number checkbox. The display also depends on the Swiss payment type setting in the payment method linked to the used payment term. To show the fields, the Swiss payment type needs to be set to Print.

Paper tray control for ISR forms

To print the ISR on a separate sheet in a pre-printed form, use paper tray control settings.

The table below shows a 4-page print job with a paper tray change before the last page, controlled by the Standard paper tray and ISR paper tray settings. The paper tray numbers of the printer are specified here. A paper tray change occurs when these 2 settings have different values. The ISR payment slip is always printed on a new page.

 

Paper

Paper tray

Invoice page 1

Blank paper

1

Invoice page 2

Blank paper

1

Invoice page 3

Blank paper

1

ISR

ISR form

3

The internal tray numbers are specified as numbers. These are specific for the respective printer or printer driver. If necessary, contact your system administrator.

By creating your own report codes, these settings can be preset with a default value.

Creating sales invoices

Open: Sales > Invoices > Invoices

To generate a Swiss invoice with an ISR Inpayment slip, an invoice form needs to be used that is prepared for ISR printing. When printing the invoice, select the SBONFACP form:

The ISR Inpayment slip is printed at the end of the invoice on a separate sheet. You can print the Inpayment slip from a different paper tray, see Prerequisites for printing.

The printing process uses the ISR reference number generated when saving the invoice and the determined ISR payment bank. This data remains unchanged even if the invoice is printed again.

Creating A/P-A/R accounting customer invoices

Open: A/P-A/R accounting > Invoicing > Customer BP invoices

To generate a Swiss invoice with ISR Inpayment slip, a specific invoice form has to be used that is prepared for ISR printing. When printing the invoice, select the BPCINV form.

The ISR Inpayment slip is printed at the end of the invoice on a separate sheet. You can print the Inpayment slip from a different paper tray, see Prerequisites for printing.

The ISR reference number and the payment bank ISR/QR generated when the invoice was saved are used in the printing process: