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 - Lithuania

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

Lithuania - LITAS-ESIS 1.1
Foreign Country Payment not selected - Domestic Payments


Configuration
  1. In the Company Info setting:

    1. Ensure the Company Name and Reg. No. are correct.

    2. Enter your company's bank account number in the Bank 2 field. This will be used if the Bank A/C No. in a Payment Mode is blank.

  2. In the Contact records for each domestic Supplier:

    1. Enter the Supplier's address using the first two Invoice Address fields.

    2. Enter the Supplier's company registration number in the Reg. No. 1 field.

    3. Enter the Supplier's code for your company in the Their Customer Code field.

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

    5. If the Supplier has a Purch. Invoice To Supplier, follow steps (a)-(c) above for that Invoice To Supplier. All Supplier details in the export file except the bank account number will be taken from the Invoice To Supplier. The bank account number in the export file will be taken from the To Bank A/C field in each Payment row. This field takes its default from the Supplier, not the Invoice To Supplier, so be sure to specify the correct Bank Account in the Supplier record.

  3. 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.
Payments
  1. Ensure when entering a Payment record that it only contains payments (rows) to one Supplier. If a Payment record contains payments to more than one Supplier, it will not be exported.
Exporting
  1. Select the appropriate Pay Method option in the 'Specify Banking File' window. "1" will be exported in the fourth column in the export file (Mokejimo rusis (Prioritetas)) if Normal is selected, "2" otherwise.

  2. 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.

Lithuania - LITAS-ESIS 1.1
Foreign Country Payment selected - International Payments


Configuration
  1. In the Company Info setting, enter your company's bank account number in the Bank 2 field. This will be used if the Bank A/C No. in a Payment Mode is blank.

  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 two lines of address.

    3. Specify a Clearing Code (use the ISO format i.e. five-character country code followed by a bank identifier).

  3. In the Contact records for each international Supplier:

    1. Enter the Supplier's address using the first two Invoice Address fields.

    2. Specify the Supplier's Bank in the Account Operator field using 'Paste Special'.

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

    4. If the Supplier has a Purch. Invoice To Supplier, follow steps (a)-(b) above for that Invoice To Supplier. All Supplier details in the export file except the bank account number will be taken from the Invoice To Supplier. The bank account number in the export file will be taken from the To Bank A/C field in each Payment row. This field takes its default from the Supplier, not the Invoice To Supplier, so be sure to specify the correct Bank Account in the Supplier record.

  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.
Payments
  1. Ensure when entering a Payment record that it only contains payments (rows) to one Supplier. If a Payment record contains payments to more than one Supplier, it will not be exported.
Exporting
  1. Select the appropriate Pay Method option in the 'Specify Banking File' window. "1" will be exported in the fourth column in the export file (Mokejimo rusis (Prioritetas)) if Normal is selected, "2" if Express is selected or "3" if Extra Urgent is selected.

  2. Select the appropriate Bank Fees option in the 'Specify Banking File' window. "1" will be exported in column 31 in the export file (Uzsienio banko mokesciai) if We Pay is selected, "3" if Suppliers Pay is selected or "2" if Shared is selected. You can use the Payment Settings setting to choose which option in the specification window will be selected by default.

  3. 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.

Lithuania - SEPA


Configuration
  1. In the Company Info setting:

    1. Ensure the Company Name, Reg. No. and Country are correct. The Country should use the two-character ISO 3166 format.

    2. 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 (the export function will sometimes use the country prefix and sometimes the Country field itself for this purpose).

  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 (i.e. if you will use Currencies other than the Euro as the Bank 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 Supplier's Bank is not in your country, specify a BIC (SWIFT) in their Bank record, and enter the word "Foreign" in the Sort Key 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 ensuring that you use the first four Invoice Address fields. If you only need three lines for an address, leave the second Invoice Address field empty. 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 A of each Payment Mode using 'Paste Special' and ensure the Account (IBAN) is brought into the Bank A/C No field.
Payments
  1. Ensure the To Bank A/C on flip H of each row contains the relevant Supplier's IBAN. Usually this will have been copied from the Purchase Invoice being paid. If this field is empty, the Supplier's bank account number will be taken from the IBAN Code, Bank Account or Bank Account 2 fields in the Contact record for the Supplier If the bank account number 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 <Othr>.

  2. If there is a Bank Reference in a Payment row (flip H), it will be exported in the tag <Ref> 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. If there is no Bank Reference, the <Ref> tag will not be exported, and instead the Supp. Inv. No. of the Purchase Invoice being paid will be exported in the tag <Ustrd> (also inside <RmtInf>). If the Purchase Invoice does not have a Supp. Inv. No., the Purchase Invoice Number or, in the case of 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 7 and 9 below), the export function will check each row paying a particular Supplier for a Payment Code or Bank Reference (both on flip H, and both will have been copied from each Purchase Invoice). The first Payment Code or Bank Reference that it finds will be exported in the <Ref> tag. If no row has a Payment Code or Bank Reference, the <Ustrd> tag be exported instead. This will contain a text string constructed from the Supp. Inv. Nos. of each Purchase Invoice, in the format <Ustrd>Invoice No.: Supp. Inv. No, 1, Supp. Inv. No. 2</Ustrd>. If any Purchase Invoice does not have a Supp. Inv. No. or if a Payment row is a Prepayment or On Account Payment, the text "TRANSFER" will be exported (e.g. <Ustrd>Invoice No.: TRANSFER, Supp. Inv. No. 2</Ustrd>).

  3. Select "Per Supplier" as the Payment Format 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 as a single payment in the export file. If you select this option, all Payments will be exported on a One Payment per Supplier basis. If you do not select it, only those Payments where the Payment Format is "Per Supplier" (step 7 above) will be exported on that basis.

  3. 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 Payment in a particular Payment record. Do not select Foreign Country Payment in the 'Specify Banking File' window, because the resulting file will not contain any payments.

  4. 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.
---

Export functions in the Purchase Ledger and Integration modules:

Go back to:

Previous   Next   Top            Entire Chapter in Printable Form