4 Working With Localizations for Switzerland

This chapter contains the following topics:

4.1 Understanding ESR Payment Slips for Switzerland

Einzahlungsschein (ESR) are preformatted payment slips that accompany the invoices that you send to customers. ESR payment slips contain a unique reference number that the PostFinance Bank uses when customers make electronic payments through that bank. PostFinance uses the reference number to refer to the payment transaction when it sends information to the payor and payee about the transfer of funds to satisfy the payment requirements. When PostFinance returns payment information to you, you use the ESR reference number to match receipts to invoices.

The ESR reference number consists of the document number (DOC), document company (KCO), and the document type (DCT) of the invoice, as well as the bank transit number (TNST) and a check digit that the system creates using an algorithm. The system concatenates these values to form one string. The document type is written in its ASCII code representation because the ESR reference number must be numerical characters.

The system formats the ESR reference number only when the company customizes either the Print Invoices program (R42565) or the Invoice Print program (R03B505) to call the Maintain ESR Reference Number business function (B03B0220), and you use the customized program to print invoices with attached ESR payment slips. The Maintain ESR Reference Number business function creates the ESR reference number.

When PostFinance sends you electronic media in XML format that confirms the payments that have been credited to you, you use the Upload ESR Payments XML Format program (R74C301) to upload the ESR payment information to the Electronic Receipts Input table (F03B13Z1). You can use the R74C301 program to unformat the ESR reference number. When PostFinance sends you electronic media in a text file, you use the Text File Processor program (P007101) to process the electronic media. The Text File Processor program calls the Upload ESR Payments program (R03B803) to unformat the ESR reference number. You can use the Upload ESR Payments program to unformat the ESR reference number only if the Maintain ESR Reference Number business function was used to format the ESR reference line on the printed ESR payment slips.

When you run the R74C301 program, the system unformats the ESR reference number in the XML file and parses it into the Document Number (DOC), Document Company (KCO), and Document Type (DCT fields) in the F03B13Z1 table.

When you run the R03B803 program, the system unformats the ESR reference number in the Text Processor Header table (F007101) and the Text Processor Detail Table (F007111), and parses it into the Document Number, Document Company, and Document Type fields in the F03B13Z1 table.

The ESR payment slip process includes these events:

  1. You run the customized print invoices program to print invoices with ESR payment slips.

  2. You send the invoices with ESR payment slips to customers using the postal service.

  3. Customers forward the ESR payment slips to PostFinance Bank.

  4. PostFinance withdraws the appropriate amount from the customer's account and deposits it into the company's account.

  5. PostFinance creates electronic media that contains the payment information and sends it to you.

  6. For XML file, you upload the ESR payments information into the Electronic Receipts Input table (F03B13Z1) by using the Upload ESR Payment XML Format program (R74C301).

    For text file, you run the Upload ESR Payments program from the Text File Processor program to upload payment information from the F007101 and F007111 tables to the F03B13Z1 table.

  7. For XML file and text file, you review and revise as necessary the information in the F03B13Z1 table by using the Work With Electronic Receipts Input program (P03B121).

  8. You use the Known Invoice Match with Amount program (R03B50D) or the Known Invoice Match Without Amount program (R03B50E) to process accounts receivables.

    You must use one of these programs because the outbound ESR process creates one payment slip per invoice and you must use a program that applies one receipt to one invoice.

4.2 Understanding Automatic Payments for Switzerland

To conform to standard business practices in Switzerland, set these processing options on the Create Payment Control Groups program (R04570) as indicated:

  • On the Process By tab, set the Payee processing option to 1.

  • On the Summarize tab, set the Summarized Pay Item processing option to 1.

  • On the Summarize tab, set the Summary Description processing option to 1.

To retrieve sender information from the DTA file format, you must enter your address book number in the Company Address Number field on the Company Setup form.

4.3 Understanding VAT for Switzerland

Value-added tax (VAT) is a noncumulative tax that is imposed at each stage of the production and distribution cycle.

Businesses in Switzerland are required to submit an official quarterly tax declaration, along with the payment for taxes due, within 60 days of the end of each quarter. In addition to this tax declaration, businesses are required to submit reports that list transactions involving VAT.

See Using Additional Reports for Switzerland.

4.4 Uploading ESR Payment Information for Switzerland to the F03B13Z1 Table

This section provides an overview of the Upload ESR Payment XML Format program, Upload ESR Payments program, lists their prerequisites, and discusses how to set their processing options.

4.4.1 Uploading ESR Payments Information from XML File

After you import the XML file that PostFinance bank sends to you, you can run the Upload ESR Payments XML Format report (R74C301) to upload the ESR payment information to the Electronic Receipts Input table (F03B13Z1). When you run the R74C301 program, the system unformats the ESR reference number in the XML file and parses it into the Document Number (DOC), Document Company (KCO), and Document Type (DCT) fields in the F03B13Z1 table. You can use the Work With Electronic Receipts Input program (P03B121) to review and revise the information in the F03B13Z1 table.You can use the R74C301 report to review the payment details in the XML file that are successfully processed.

4.4.1.1 Prerequisite

Set up processing options for the Upload ESR Payment XML Format program (R74C301).

4.4.1.2 Generating the Upload ESR Payments XML Format Report

To generate the Upload ESR Payments XML Format Report, from the Swiss localization (G74C) menu, select Upload ESR Payments XML Format (R74C301).

4.4.2 Uploading ESR Payments Information from Text File

After you import the text file that Post finance Bank sends to you to confirm ESR payments into the Text File Processor program (P007101), you can run the Upload ESR Payments program (R03B803) to upload the ESR payment information to the F03B13Z1 table. When you run the Upload ESR Payments program, the system unformats the ESR reference number in the Text Processor Header table (F007101) and the Text Processor Detail table (F007111); and parses it into the Document Number (DOC), Document Company (KCO), and Document Type (DCT fields) in the F03B13Z1 table. You can then use the Work With Electronic Receipts Input program (P03B121) to review and revise the information in the F03B13Z1 table.


Note:

The Version field is for display only. Version ZJDE001 is the only version of the Upload ESR Payments program that uploads text files.

4.4.2.1 Prerequisites

Before you complete the tasks in this section:

4.4.2.2 Setting Processing Options for Upload ESR Payments (R03B803)

Processing options enable you to specify the default processing for programs and reports.

Defaults

1. Receipt Currency Code

Specify the transaction currency code for the Upload ESR Payments program (R03B803). The system stores currency codes in the Currency Codes table (F0013). If you leave this processing option blank, the system uses the default value CHF.

2. G/L Bank Account

Specify the G/L bank account for the electronic receipts.

3. G/L Date

Specify the G/L date for each electronic receipt.

4. Override G/L Date

Specify the G/L date for the electronic receipts. The system uses the date that you specify here only if the G/L Date processing option is blank. If you leave this processing option blank as well, the system uses the current date.

5. Receipt Date

Specify the receipt date for the electronic receipts. If you leave this processing option blank, the system uses the current date.

6. Receipt Remark

Use this processing option to enter a receipt remark that appears on the electronic receipts that are created by the Upload ESR Payments program (R03B803). You can enter up to 30 characters.

4.5 Working With Automatic Debits for Switzerland

This section provides an overview of automatic debits for Switzerland and discusses how to set processing options for Create Swiss Bank Diskette Format (R03B575SD).

4.5.1 Understanding Automatic Debits for Switzerland

The JD Edwards EnterpriseOne system provides these Swiss automatic debit formats:

  • R03B575SD (Create Swiss Bank Diskette Format).

    This program saves information to the F03B57OW table.

  • R03B575SD1 (Swiss Bank Cover Sheet).

    This program generates a bank table that adheres to the banking standards for automatic debits (LSV) in Switzerland.


    Note:

    The Create Swiss Bank Diskette program automatically calls the Swiss Bank Cover Sheet program.

4.5.2 Setting Processing Options for Create Swiss Bank Diskette Format (R03B575SD)

Processing options enable you to specify the default processing for programs and reports.

4.5.2.1 Statement Print

1. Statement Print

Specify whether the system prints customer statements for automatic debits. Values are:

Blank: Print customer statements only when the number of invoice detail lines exceeds the maximum number of lines that can be included on the format.

1: Print customer statements for automatic debits.

2. Tape Density

Specify the tape density.

4.5.2.2 Identification

3. Bank Identification Information

Specify the LSV sender and subscriber identification information.

4.6 Using Additional Reports for Switzerland

In addition to the reports specified as part of a process in other sections of this implementation guide, these reports exist for Switzerland.

Report ID and Report Name Description Navigation
R740380

Account Receivable VAT Report

Use this program to a list of the accounts receivable transactions that include VAT in a format that complies with the standards set by the Swiss government. Swiss Localization menu (G74C), Account Receivable VAT Report.
R740480

Accounts Payable VAT Detail Report

Use this program to a list of the accounts payable transactions that include VAT in a format that complies with the standards set by the Swiss government. Swiss Localization menu (G74C), Accounts Payable VAT Detail Report.

4.6.1 R740380 - Account Receivable VAT Report

You print the Account Receivable VAT Report to create a list of transactions that include VAT in a format that complies with the standards set by the Swiss government.

A running total must be printed after every 100 lines or every page, whichever comes first. You can specify page totaling in the processing options.

You can use the processing options to:

  • Process transactions based on the specified country. (Release 9.1 Update)

  • Limit the transactions included in the reports by specifying a from and through date.

  • Select reporting based on the invoice date or the GL date.

4.6.2 Processing Options for Account Receivable VAT Report (R740380)

Processing options enable you to specify the default processing for programs and reports.

4.6.2.1 Process (Release 9.1 Update)

Report by Country
Country for Tax Rate/Area processing

Enter a value from UDC table 00/EC to specify the country for which you want to run the report. The system applies an additional filter excluding the tax rate/areas which were not identified for that country in the Alternate Tax Rate/Area by Country program (P40082).

Leave this field blank to prevent tax rate/areas additional filtering.

4.6.2.2 Date Selection

Date

Enter 1 to select record by invoice date, 2 to select by Service tax date, and leave blank to select by GL date.

4.6.2.3 Date Range

Enter the date range for selection

Enter Date From or Date Through

4.6.2.4 Summarize Repo

Tax Rate Code

Enter 1 to summarize report by Tax Rate Code, leave blank for detail.

Document Number

Enter 1 to print report summarized by document number.

Total

Enter 1 to print a total line at the end of each page.

4.6.3 R740480 - Accounts Payable VAT Detail Report

You print the Accounts Payable VAT Detail Report to create a list of transactions that include VAT in a format that complies with the standards set by the Swiss government.

A running total must be printed after every 100 lines or every page, whichever comes first. You can specify page totaling in the processing options.

You can use the processing options to:

  • Process transactions based on the specified country. (release 9.1 Update)

  • Limit the transactions included in the reports by specifying a from and through date.

  • Select reporting based on the invoice date or the GL date.

4.6.4 Processing Options for Accounts Payable VAT Detail Report (R740480)

Processing options enable you to specify the default processing for programs and reports.

4.6.4.1 Process (Release 9.1 Update)

Report by Country
Country for Tax Rate/Area processing

Enter a value from UDC table 00/EC to specify the country for which you want to run the report. The system applies an additional filter excluding the tax rate/areas which were not identified for that country in the Alternate Tax Rate/Area by Country program (P40082).

Leave this field blank to prevent tax rate/areas additional filtering.

4.6.4.2 Date Range

Beginning Date and Through Date

Enter Beginning Date or Through Date for Data Selection.

4.6.4.3 Date Type

Date

Enter 1 to use the Invoice Date. Leave blank to use the GL date.

Document Number

Enter 1 to print detail report summarize by document number

4.6.4.4 Total Line

Total

Enter 1 to print a total line at the bottom of each page of the report.

Tax Rate Area

Enter 1 to print summarized by Tax Rate Area.