Language:


HansaManuals Home   >> Standard ERP   >> Purchase Ledger   >> Exports  

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.5  

Banking File - Spain - SEPA

This page contains some guidance about where to enter information in order for it to be included correctly in Banking File export files when they are produced using the Spain - SEPA Payment File Format.

Foreign Country Payment not selected - Domestic Payments


Configuration
  1. In the Company Info setting:

    1. Ensure the Company Name is correct.

    2. Enter your company's address in the first two Address fields (street in the first field, post code and town in the second field) and the Country field. The Country must use the two-character ISO 3166 format (i.e. "ES"). All three fields must be filled in for the address to be exported.

    3. Optionally enter a Bank Customer ID. This will be used if the Bank ID Code in a Bank record is blank (point 2c below).

  2. In the Banks setting:

    1. Enter a separate record for each Bank used by your Suppliers, and one for your own Bank.

    2. Specify a BIC (SWIFT) in each Bank record.

    3. For your own Bank, enter the Account (IBAN), BIC (SWIFT) and Bank ID Code (i.e. business ID or customer number at the bank)
      If you will be sending Payments to a Supplier's Bank in Currencies other than the Euro (i.e. if you will use Currencies other than the Euro as the Sent Currency in Payment rows to the Supplier), you may need to specify an Exchange Rate Contract Number in that Supplier's Bank record. This will be exported in the <CtrctId> tag inside <XchgRateInf>.

    4. If a Bank is outside the EU, specify a Clearing Code (use the ISO format i.e. five-character country code followed by a bank identifier), up to four lines of address and a Country (two-character ISO 3166 format).

  3. In the Contact records for each domestic Supplier:

    1. Enter the address using the second and third Invoice Address fields (street in the second field, post code and town in the third field) and the Country field (Country must use the two-character ISO 3166 format). All three fields must be filled in for the address to be exported.

    2. Enter the Supplier's bank account number in the IBAN Code field or, if it is not in IBAN format, in the Bank Account or Bank Account 2 fields.

    3. Enter the Supplier's Bank in the Account Operator field using 'Paste Special'.

  4. In the Payment Modes setting, enter your Bank on flip A of each Payment Mode using 'Paste Special'.
Payments
  1. If there is a Bank Reference on flip H in a Payment row, it will be exported in the tag <CdtrRef> inside <RmtInf>. By default, the Bank Reference will have been copied from the Reference in each Purchase Invoice being paid but you can add one or edit the default. It is the comment that will be visible to the Supplier. If a Payment row does not have a Bank Reference, the <CdtrRef> tag will not be exported, and instead the Reference Number (from flip G) will be exported in the tag <Ustrd> (also inside <RmtInf>). If that is blank, the Supp. Inv. No. or, if a payment row is a Prepayment or On Account Payment, the word "TRANSFER" will be exported in <Ustrd>.

    If you export a Payment on a "Per Supplier" basis (points 6 and 11 below), a text string constructed from the Bank References in each Payment row paying a particular supplier will be exported in <Ustrd> inside <RmtInf>. In effect this text string will list the Bank References of the Purchase Invoices being paid, using the format <Ustrd>RFS//Bank Reference 1/Bank Reference 2</Ustrd>. If a Payment row does not have a Bank Reference, the word "TRANSFER" will be exported in its place. The individual Bank References (or the word "TRANSFER") will also be exported in <CdtrRef> tags, also inside <RmtInf>. If there is no Bank Reference and you are using the Export Supplier Invoice Number option in the Bank Transfer setting, the Supp. Inv. No. of the Purchase Invoice being paid will be exported instead (e.g. RFS//Supp. Inv. No. 1/Bank Reference 2), with the word "TRANSFER" being used if there is no Supp. Inv. No.

  2. Select "Per Supplier" as the Payment Format on the 'Bank' card if appropriate.

  3. Select "Express" or "Extra Urgent" as the Payment Method if appropriate.
Exporting
  1. Select "Express" or "Extra Urgent" as the Pay Method in the 'Specify Banking File' window if appropriate. This will cause "URGP" to be exported in the tag <Prtry> in <SvcLvl>. If selected, all Payments will be exported as "URGP". If not selected, only those Payments marked "Express" or "Extra Urgent" in step 7 above will be exported as "URGP".

  2. Select "Shared" as the Bank Fees option in the 'Specify Banking File' window if appropriate. This will cause "SLEV" to be exported in the tag <ChrgBr>. You can use the Payment Settings setting to choose which option in the specification window will be selected by default.

  3. Select Pay on Due Date if appropriate. If you select this option, the later of the Payment Date from the Payment and the current date will be exported in the tag <ReqdExctnDt>. Otherwise, the current date will be exported.

  4. If a Payment record contains more than one row with the same Supplier, you can select One Payment per Supplier in the 'Specify Banking File' window if you want those rows to be grouped together in the export file. If selected, all Payments will be exported on a One Payment per Supplier basis. If not selected, only those Payments where the Payment Format is "Per Supplier" (step 6 above) will be exported on that basis.

  5. Deselect Batch Booking if the payment transactions will be processed separately on the bank side. This option causes "true" or "false" to be exported in the tag <BtchBookg<.

  6. If you select the Unexported Only option in the 'Specify Banking File' window, Payments in the range that have not been marked as Ordered and those that have been marked as Ordered will be exported. Payments that have been marked as OK will not be exported. After the export process, any unordered Payments in the range will be marked as Ordered automatically. If you need to export a Payment that has been marked as OK, select the All option in the 'Specify Banking File' window but be careful when specifying the range of Payments to be exported as any Payments in the range that have previously been exported will be exported again. Payments and individual Payment rows that have been invalidated will never be exported.

Foreign Country Payment selected - International Payments


Configuration
  1. In the Company Info setting, ensure the Reg. No. is correct.

  2. In the Banks setting:

    1. Enter a separate record for each Bank used by your Suppliers.

    2. Specify a BIC (SWIFT) in each Bank record, and up to three lines of address.

  3. In the Contact records for each international Supplier:

    1. Enter the address using the first three Address fields.

    2. Enter the country where the Supplier is located in the Country field (two-character ISO 3166 format).

    3. Enter the Supplier's bank account number in the IBAN Code field or, if it is not in IBAN format, in the Bank Account or Bank Account 2 fields.

    4. Enter the Supplier's Bank in the Account Operator field using 'Paste Special'.

  4. In the Payment Modes setting, enter your bank account number in the Bank A/C No. field in each Payment Mode.
Purchase Invoices
  1. Specify a Supp. Inv. No. in each Purchase Invoice.
Exporting
  1. Select the appropriate Pay Method option in the 'Specify Banking File' window. "M" will be exported if Normal is selected or "P" otherwise.
---

Export functions in the Purchase Ledger and Integration modules:

Go back to:

Previous   Next   Top            Entire Chapter in Printable Form