Language:


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

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 2024-03-16  

Banking File - Norway

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

All Payment File Formats except ISO20022: Foreign Country Payment not selected - Domestic Payments


Configuration
  1. In the Company Info setting:

    1. In the Bank Customer ID field, enter your company's VAT number with non-numeric characters removed. For example, if your company's VAT number is NO 987654321 MVA, enter 987654321.

    2. Enter your bank account number in the Bank 1 field.

  2. In the Bank Transfer setting:

    1. Specify a User on the 'Norway' card.

    2. Optionally, enter the division code for your bank branch in the Prod. No. field.

  3. In the Contact records for each domestic Supplier:

    1. Enter the address using the first three Address fields. The third field should contain the four-digit postal code (in "XXXX" or "N-XXXX" format) and the town, separated by a space.

    2. Enter the Supplier's bank account number in the Bank Account field.
Purchase Invoices
  1. Enter a KID Code for each Purchase Invoice in the Reference field. The code will be checked for validity.
Exporting
  1. For a Payment row to be exported, the To Bank A/C must not be blank.

  2. The Invoice No. in a Payment row must refer to a valid Purchase Invoice (i.e. Prepayments and On Account Payments will not exported).

  3. If the total amount payable to a Supplier in a single Payment record is negative, that Supplier's Payment rows will not be exported.

  4. If you specify a Currency in the specification window, only Payment rows with that Currency as Sent Currency will be exported.

  5. Specify the division code for your bank branch in the Prod. No. field in the 'Specify Banking File' window (if you entered one in the Bank Transfer setting in step 2b, it will be copied to the 'Specify Banking File' window as a default). This will be included in positions 60-70 in the first line of the export file.

  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 that have been invalidated will never be exported.

All Payment File Formats except ISO20022: Foreign Country Payment selected - International Payments


Configuration
  1. In the Company Info setting:

    1. In the Bank Customer ID field, enter your company's VAT number with non-numeric characters removed. For example, if your company's VAT number is NO 987654321 MVA, enter 987654321.

    2. Enter your bank account number in the Bank 1 field.

  2. In the Bank Transfer setting:

    1. Specify a User on the 'Norway' card.

    2. Optionally, enter the division code for your bank branch in the Prod. No. field.

  3. 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, or a Name and three lines of Address.

    3. Enter a division code (bank branch code) in the Sort Key field in each Bank record.

    4. Enter the Supplier's bank account number in the Account (IBAN) field. This means you will need a unique Bank record for each Supplier.

  4. 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 in the Account Operator field using 'Paste Special'.

    4. If you enter a Reference for a Supplier, it will be copied to each Purchase Invoice and exported from there.
Purchase Invoices
  1. Specify a Reference or a Supp. Inv. No. in each Purchase Invoice.
Exporting
  1. For a Payment row to be exported, the To Bank A/C must not be blank.

  2. The Invoice No. in a Payment row must refer to a valid Purchase Invoice (i.e. Prepayments and On Account Payments will not exported).

  3. If the total amount payable to a Supplier in a single Payment record is negative, that Supplier's Payment rows will not be exported.

  4. You must specify a Currency in the specification window. Only Payment rows with that Currency as Sent Currency will be exported.

  5. Specify the division code for your bank branch in the Prod. No. field in the 'Specify Banking File' window (if you entered one in the Bank Transfer setting in step 2b, it will be copied to the 'Specify Banking File' window as a default). This will be included in positions 60-70 in the first line of the export file.

  6. Select the appropriate Bank Fees option in the 'Specify Banking File' window. "OUR" will be exported if We Pay is selected or "BEN" otherwise. You can use the Payment Settings setting to choose which option in the specification window will be selected by default.

Norway - ISO20022 SEB, Nordea, Norway - ISO20022 Handelsbanken, Norway - ISO20022 DNB


Configuration
  1. In the Company Info setting:

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

    2. After entering a record for your bank in the Banks setting (point 3 below), enter its Code in the Bank Code field. This Bank will be used to supply the Bank ID Code if there is no Bank in a Payment Mode (this will usually be the case if you have a single bank account).

    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 (point 5 below) and the Account (IBAN) in the Bank record for your Bank (point 3c below) are both blank, 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 Payment Codes setting, enter Payment Codes as listed at https://www.skatteetaten.no.

  3. 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 (optional in the case of the Banks used by your Suppliers, see point 4d below).

    3. For your own Bank, enter the Account (IBAN) and Bank ID Code (your Contract/Customer/Organisation ID at the bank). This will be exported in the <Id> tag (inside <InitgPty> and subsequently inside <Dbtr<). If your bank is Norway - ISO20022 DNB, enter the Sort Key (Customer Service ID) as well (this is optional).

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

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

    6. If you will pay a Supplier using the "Foreign" Payment Channel (point 4e below), specify a Clearing Code in that Supplier's Bank. Use the ISO format i.e. five-character country code followed by a bank identifier/clearing number.

  4. In the Contact records for each Supplier:

    1. Enter the Country in which the Supplier is located (in two-character ISO 3166 format). This will be exported in the <PstlAdr> tag inside <Cdtr>. If you do not specify a Country, "NO" will be exported in this tag.

    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. Optionally, enter the BIC (SWIFT) of the Supplier's bank account in the BIC (SWIFT) field. If you do not specify a BIC (SWIFT) in the Contact record for a Supplier, it will be taken from the relevant record in the Banks setting (points 4c and 3b above). For all Payment Channels (point 4e below) a BIC (SWIFT) here or in the Bank record is required if the bank account number is in IBAN format.

    5. Choose a Payment Channel on the 'Accounts' card in the Contact records for each Supplier. The available options are "Domestic", "SEPA" (i.e. foreign, within the Euro zone) and "Foreign". The Payment Channel will be copied to each Purchase Invoice and from there to each Payment row (flip K, point 9 below).

    6. If the Payment Channel in point 4e above is "Domestic", enter the Sort Code of the Supplier's Bank on the 'Accounts' card of their Contact record. This will be copied to each Purchase Invoice and from there to each Payment row (flip H).

    7. If the Payment Channel is "SEPA" or "Foreign", enter a Payment Code for the Supplier if necessary (i.e. if there will be high-value transactions). This will be copied to each Purchase Invoice and from there to each Payment row (flip H).

    8. If the Payment Channel is "Foreign" and the Payment File Format is Norway - ISO20022 DNB, ensure the Supplier's Address is correct. The Address will be copied to Purchase Invoices from where it exported in the tag <AdrLine>.

  5. 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. This step is optional if you have a single bank account.
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 the Purchase Invoice being paid has an OCR/KID Code or if there is a Bank Reference in a Payment row (flip H), the OCR/KID Code or, if blank, the Bank Reference 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 OCR/KID Code or 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 <Nb> (inside <RfrdDocInf> that in turn is inside <RmtInf>). If the Purchase Invoice does not have a Supp. Inv. No. or a payment row is a Prepayment or On Account Payment, the Text from the Payment row will be exported in <Ustrd> inside <RmtInf>.

    If you export a Payment on a "Per Supplier" basis (points 8 and 13 below), the <Ustrd> tag will be exported inside . This will contain a text string constructed from the Bank References from each Payment row or, if a Payment row does not have a Bank Reference, from the Supp. Inv. No. of the Purchase Invoice being paid, in the format <Ustrd>Bank Reference 1,Supp. Inv. No. 2,Bank reference 3</Ustrd>. If any Payment row does not have a Bank Reference and the Purchase Invoice does not have a Supp. Inv. No. or if a Payment row is a Prepayment or On Account Payment, the first 50 characters from the Text in the Payment row will be exported (e.g. <Ustrd>Bank Reference 1,Payment Row Text 2,Supp. Inv. No. 3</Ustrd>).

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

  4. Specify a Payment Channel, Urgency and Bank Fee on flip K of each row in a Payment, using 'Paste Special' in each case. By default, the Payment Channel will be copied from the Purchase Invoice being paid, and in turn the Payment Channel in the Purchase Invoice will be copied from the Contact record for the Supplier (point 4e above).

    If the Urgency is "Normal" and if the Payment Channel is "Domestic" or "Foreign", "NURG" will be exported in the tag <Cd> in <SvcLvl>. If the Urgency is "Express", "URGP" will be exported in the tag <Cd> in <SvcLvl>. If the Payment Channel is "SEPA" with any Urgency, "SEPA" will be exported in <Cd> in <SvcLvl>.

    If the Urgency is "Normal" and the Payment File Format is ISO20022 SEB, Nordea or ISO20022 Handelsbanken, the <SvcLvl> tag mentioned in the previous paragraph will be followed by "SUPP" inside <CtgyPurp>.

    If the Payment Channel is "Domestic" or "Foreign", Bank Fees of "Shared", "Supplier pays" and "We pay" will cause "SHAR", "CRED" and "DEBT" respectively to be exported in the tag <ChrgBr>.

    If the Payment Channel is "SEPA" or "Foreign", any Payment Code specified on flip H together with its Description from the Payment Codes setting will be exported in the tag <Dtls> inside <RgltryRptg>.

Exporting
  1. If you specify a Currency in the specification window, only Payment rows with that Currency as Bank Currency will be exported.

  2. 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. You can use the Payment Settings setting to choose whether the Pay on Due Date option in the specification window will be selected by default.

  3. If a Payment record contains more than one row with the same Supplier, you can select One Payment per Supplier or Batch Booking 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 either of these options, all Payments will be exported on a One Payment per Supplier basis. If you do not select either of them, only those Payments where the Payment Format is "Per Supplier" (point 8 above) will be exported on that basis.

  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