Language:


Banking File

Select this option when you want to export a selection of Payments from your Purchase Ledger. You can send the resulting files to your bank for use by a credit transfer system. These files will therefore take the place of printed payment orders.

The format of the export files created by this function is dependent on the Payment File Format chosen in the Bank Transfer setting. The function is not operational in every country: please refer to your local HansaWorld representative for full details.

Payment No.
Range Reporting    Numeric
Enter a Payment Number to export a single Payment, or a range of Payment Numbers separated by a colon (:).

If you choose the Unexported Only option below, only Payments in the range that have been Ordered but not marked as OK will be exported. An exception to this is when the Payment File Format is Namibia, in which case both Ordered Payments and Payments that have been marked as OK will always be exported.

If the Payment File Format is Namibia, you must specify a Payment Number or a range of Numbers: nothing will be exported if you leave this field empty.

Currency
Paste Special    Currency register, System module
Enter a Currency here if you only want to export Payment rows with a particular Currency.

You can use this field with the following Payment File Formats:
  • Czech - ABO (Only Payment rows with the specified Currency as Bank Currency will be exported.)

  • Czech - CITI bank (Only Payment rows with the specified Currency as Bank Currency will be exported.)

  • All New Zealand banks (Only Payment rows with the specified Currency as Bank Currency will be exported.)

  • All Norwegian banks except SEPA (Only Payment rows with the specified Currency as Sent Currency will be exported. If you select the Foreign Country Payment option below, you must also specify a Currency in this field. Otherwise, specifying a Currency is optional.)

Character Set
Default taken from    Local Machine setting, User Settings module (Default Export Codepage field)
Paste Special    Choices of possible entries
Specify here the character set that you want to be used in the export file.

In most cases, you should ignore this field as the character set will be determined by the Payment File Format. However, if the Payment File Format is Finland - SEPA, Germany - SEPA,
Italy - SEPA, Latvia - SEPA, Lithuania - SEPA, Norway - SEPA, Spain - SEPA or Sweden - SEPA, some banks will require files using UTF-8 and some ISO-8559-1. Specify here which one is to be used.

If you use the DOS Format option below, the character set will be CP437, irrespective of the Payment File Format and the character set chosen here.

Pay Method
Depending on the Payment File Format you are using, you will sometimes be able to insert a flag into an export file that signifies the urgency of the payments in that file. Select the appropriate option here.

You can use this option together with the following Payment File Formats when also selecting the Foreign Country Payment option:

You can use this option together with the following Payment File Formats when not selecting the Foreign Country Payment option:

If you are using the following Payment File Formats and do not select the Foreign Country Payment option, you will also be able to choose a Payment Method using the options on the 'Bank' card of an individual Payment. If you choose "Express" or "Extra Urgent" here in the specification window, all Payments will be so marked in the export file. If you choose "Normal", only those Payments that you have individually marked as "Express" or "Extra Urgent" will be so marked in the export file.

Please follow the links to the descriptions of the individual Payment File Formats for more details.

Status
Use these options to choose whether to export all Payments in the range or only those that have not been exported before. The Unexported Only option will also prevent the export of Payments that have been marked as OK.

Note that the same flag is used to keep a record of whether a particular Payment has been printed and whether it has been exported. So, printing an Ordered Payment will prevent it being exported using the Unexported Only option. Similarly, exporting an Ordered Payment will prevent it being printed by the Cheque Document and Payment Form forms using the Unprinted Only option.

These options are not used if the Payment File Format is Namibia. In this case, all Ordered Payments and Payments that have been marked as OK in the range will always be exported, and the act of exporting will not set the flag to prevent further exporting or printing.

Bank Fees
Default taken from    Payment Settings setting, Purchase Ledger
Depending on the Payment File Format you are using, you will sometimes be able to insert a flag into export files that signifies who will pay any bank fees incurred when processing payments. Select the appropriate option here.

You can use this option together with the following Payment File Formats when also selecting the Foreign Country Payment option:

You can use this option together with the following Payment File Formats when not selecting the Foreign Country Payment option:

Please follow the links to the descriptions of the individual Payment File Formats for more details.

Bank 1/Bank 2
You can use these options with the following Payment File Formats as follows:

  • Sweden - SE-Banken (When Foreign Country Payment is selected, this option changes the flag that is exported in RT3 position 74 (i.e. immediately before the Supplier's Country) (Bank 1 causes "0" to be exported, Bank 2 causes "1" to be exported)).

Our relationship with Supplier
Depending on the Payment File Format you are using, you will sometimes be able to insert a flag into export files that signifies your company's relationship with the Suppliers being paid. Select the appropriate option here.

You can use this option together with the following Payment File Formats:

Prod. No.
Default taken from    Bank Transfer setting, Purchase Ledger (Prod. No. field)
Specify here a Production Number to be included in the export file.
You can use this field together with the following Payment File Formats:

  • All Norwegian banks except SEPA (Specify the division code for your bank branch, to be included in positions 60-70 in the first line of the export file.)

  • Sweden - PlusGirot (Enter a single digit, to be exported as character 13 in the first line of the export file. "1" will be exported if you leave the field blank.)

Pay on Due Date
Default taken from    Payment Settings setting, Purchase Ledger
Use this option to control whether the exported payments are to be executed on the current date (not selected) or on the Due Dates of the Purchase Invoices being paid (selected).

You can use this option together with the Payment File Formats listed below when not selecting the Foreign Country Payment option.

Please follow the links to the descriptions of the individual Payment File Formats for more details.

DOS Format
Default taken from    Payment Settings setting, Purchase Ledger
This option ensures the character set used in the export file will be CP437.

Foreign Country Payment
You can use this option together with the Payment File Formats listed below to create files containing international payments. These files have different formats compared to those containing domestic payments.

The primary purpose of this option is to change the export format from domestic to international. Depending on the Payment File Format you are using, it usually does not act as a filter: i.e. it does not separate domestic and international Payments so that only the international ones are exported. You should therefore do this yourself by entering relevant ranges of Payment Numbers in the Payment No. field above, to ensure that domestic and international Payments aren't mixed in the same file.

If a Payment File Format is not listed below, it should be assumed that selecting this option will either not change the format of the export file or create an empty file.

  • Finland - SEPA (If Foreign Country Payment is not selected, Payment rows where the Bank Currency is not Base Currency 1 will not be exported. If Foreign Country Payment is selected, domestic and international Payments will not be separated.)

  • Latvia - SEPA (If you select this option, domestic and international Payments will not be separated. If you do not select this option, they will be included in the same file but in the domestic or international format as appropriate. This will be achieved by comparing the country prefix in your IBAN (in the Company Info setting with that in the Supplier's IBAN.)

  • Lithuania - LITAS-ESIS 1.1 (Domestic and international Payments will not be separated.)

  • All Norwegian banks except SEPA (If you specify a Currency in the field above, only Payment rows with that Currency as Sent Currency will be exported. If Foreign Country Payment is not selected, specifying a Currency is optional. If Foreign Country Payment is selected, you must specify a Currency, otherwise nothing will be exported.)

  • Spain - SEPA (If Foreign Country Payment is not selected, Payment rows where the Bank Currency is not Base Currency 1 will not be exported. If Foreign Country Payment is selected, domestic and international Payments will not be separated.)

  • Sweden - Handelsbanken (Domestic and international Payments will not be separated.)

  • Sweden - Nordea (Domestic and international Payments will not be separated.)

  • Sweden - SE-Banken (Domestic and international Payments will not be separated.)

One Payment per Supplier
If a Payment record contains more than one row paying the same Supplier, you can use this option with the Payment File Formats listed below if you would like those rows to be treated as a single payment in the export file (i.e. issuing a single payment order to the bank).

If you are using this option, note that there may not be enough space to show all the Purchase Invoice numbers being paid (depending on the length of the numbers) so it is recommended that you send this information separately to the Supplier.

If you select this option when you are using one of the Payment File Formats listed below, all Payments in the range will be exported on a One Payment per Supplier basis. If you do not select this option, only those Payments where the Payment Format (on the 'Bank' card) is "Per Supplier" will be exported on that basis.

This option has no effect when you are using the Payment File Formats listed below. However, Payments where the Payment Format is Per Supplier will be exported on that basis:

The following Payment File Formats will always export Payments as if this option has been selected:

Batch Booking
Default taken from    Payment Settings setting, Purchase Ledger
Use this option together with the Finland - SEPA, Italy - SEPA
or Spain - SEPA Payment File Formats. It causes "true" or "false" to be exported in the tag <BtchBookg>. If you do not select this option, "false" will be exported, signifying that the payment transactions will be processed separately on the bank side.
Click the [Run] button in the Button Bar to proceed. Standard ERP will open a dialogue box where you can name the export file and specify where it is to be saved. Enter a name for the file. Click [Save] or press the Enter key. The export file will be created and saved. When the export has finished, you can close the 'Export' window using the close box and then send the resulting file to your bank after checking.

You can also create a Banking File export file from an individual Payment. Simply open the Payment in a record window and choose 'Banking File Export' from the Operations menu. This function will usually behave as if the default options in the 'Specify Banking File' window are selected (i.e. as shown in the illustration above). However, depending on the Payment File Format you are using, you can override some of these defaults using the options on the 'Bank' card of the Payment window.

On the pages linked below, the various Payment File Formats are listed individually, providing some guidance about where to enter information in order for it to be included correctly in export files. Not every Payment File Format will be available in every country. Please refer to your local HansaWorld representative for more details and for advice about the suitability of a particular Payment File Format for your requirements.

Export functions in the Purchase Ledger and Integration modules:
Go back to: