Language:


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

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.1  

Banking File - Latvia

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 various Latvian bank Payment File Formats.

Latvia - FidaVista


Configuration
  1. In the Company Info setting:

    1. Ensure the Company Name is correct.

    2. Enter the VAT Reg. No. of your company.

    3. Enter the Country (two-character ISO 3166 format i.e. "LV").

  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 Suppliers' Banks, the address in the first Address field will be exported.

  3. In the Contact records for each Supplier:

    1. The address in the first Invoice Address field will be exported.

    2. Specify a Reg. No. 1 or VAT Reg. No.

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

    4. Enter the Supplier's bank account number in the Bank Account field.

    5. 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 Reference or a Supp. Inv. No. in each Purchase
    Invoice.
Exporting
  1. Select the appropriate Pay Method option in the 'Specify Banking File' window.
    "N" will be exported in the tag <Priority> if Normal is selected, "U" if Express is selected or "X" if
    Extra Urgent is selected.

  2. Select the appropriate Bank Fees option in the 'Specify Banking File' window. "OUR"
    will be exported in the tag <Comm> if We Pay is selected, "BEN" if Suppliers Pay is selected or
    "SHA" if Shared is selected. You can use the
    Payment Settings setting to choose which option
    in the specification window will be selected by default.

Latvia - SEPA


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. Both fields must be filled in for the
      address and country to be exported.

    3. Enter your bank account number in IBAN format including two-character country prefix in the
      Bank 2 field. The bank account number will be used if the Bank A/C No in a Payment Mode is blank (step
      4 below), and the country prefix will be used as the country in which you are located.

  2. In the Banks setting:

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

    2. For your own Bank, specify a BIC (SWIFT) and enter the Account (IBAN).

    3. If you will be sending Payments to a Supplier's Bank in Currencies other than the Euro, specify an
      Exchange Rate Contract Number in that Supplier's Bank record.

    4. If a Supplier's Bank is not in your country, specify a BIC (SWIFT) in their Bank record, and enter
      the word "Foreign" in the Sort Code field.

    5. For your Suppliers' Banks, enter the country in which they are located in the Country field (in
      two-character ISO 3166 format).

  3. In the Contact records for each Supplier:

    1. Enter the address using the first two Address fields. Both fields must be filled in for
      the address and country to be exported (the country will be taken from the prefix in the Supplier's IBAN).

    2. Enter the Supplier's bank account number in IBAN format including two-character country prefix
      in the IBAN Code field.

      If the bank account number is not in IBAN format, enter it in the Bank Account or Bank Account 2
      fields, and enter the Supplier's country in the Country field (in two-character ISO 3166 format).

    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 D of each Payment Mode using 'Paste Special' and ensure the Account (IBAN) is brought into the
    Bank A/C No field on flip A.
Payments
  1. Ensure the To Bank A/C on flip H of each row contains the relevant Supplier's IBAN. If
    this field is blank or contains a bank account number that is not in the IBAN format, the tag
    <IBAN> in <CdtrAcct> will not be exported and instead the bank account number will be
    exported in the tag <Id> instead .

  2. If you add a Bank Reference to at least one Payment row (flip H), it will be exported in the tag
    <Ref> inside <CdtrRefInf>. The Bank Reference will be copied from the Reference in each
    Purchase Invoice being paid.

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

  4. Tick the Foreign Payment box on the 'Bank' card if appropriate.
Exporting
  1. 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.

  2. 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 7 above)
    will be exported on that basis.

  3. When a Payment is exported on a "Per Supplier" basis, the <Ustrd> tag will contain a long
    text string made up of references to each Purchase Invoice being paid. Usually, the Supp. Inv. No. of each
    Purchase Invoice will be exported in this tag in the format Invoice:Supp. Inv. No, 1, Supp. Inv. No. 2. If If
    any Purchase Invoice does not have a Supp. Inv. No., the text "TRANSFER" will be exported (e.g.
    Invoice:TRANSFER, Supp. Inv. No. 2).

  4. If a Payment record contains a row paying an international Supplier, the BIC (SWIFT) of the
    Supplier's bank will be exported in the tag <BIC> inside <FinInstnId> inside
    <CdtrAgt>. The payment to an international Supplier will be detected by comparing the country
    prefix in your IBAN (in the Company Info
    setting) with that in the Supplier's IBAN. If the Supplier does not have an IBAN, the country prefix in
    your IBAN will be compared with the Country in the Supplier's Bank record or in the Contact record for
    the Supplier. The Supplier's country will be exported in the tag <Ctry> inside <Dtls> inside
    <RgltryRptg>. These tags will not be exported when paying domestic Suppliers, unless you select
    Foreign Country Payment in the 'Specify Banking File' window or in a particular Payment record
    (step 8 above).
---

Export functions in the Purchase Ledger and Integration modules:

Go back to:

Previous   Next   Top            Entire Chapter in Printable Form