Convert Electronic Bank Statements (tfcmg5202m000)

Use this session to convert the electronic bank statement (EBS) file.

The conversion process uses the file containing the electronic bank statements and the record types/subjects in the EBS file, defined in these sessions:

  • Record Types for Electronic Bank Statements (tfcmg5104m000)
  • Conversion Data for Electronic Bank Statements (tfcmg5105m000)

The file must contain a bank relation.

The conversion process includes these steps:

  • Status during conversion: Conversion in Process.

    During the conversion LN converts the file to LN format.

    If a conversion is aborted, the conversion can be resumed from the point where the conversion was aborted.

  • Status after conversion: Converted.

    The converted data is stored in the Electronic Bank Statements table, and cannot be converted again.

    LN moves the converted file from the original directory to the archive directory defined per bank relation. The archives directory is specified in the Path For EBS Archive field in the Bank Relations (tfcmg0510m000) session.

Field Information

Conversion Details
Bank

The bank which sent you the EBS file.

You can convert a file only if the definition of the data to be converted is defined in:

  • Record Types for Electronic Bank Statements (tfcmg5104m000)
  • Conversion Data for Electronic Bank Statements (tfcmg5105m000)
Pathname EBS File

The path used for the electronic bank statement (EBS) file.

Default value

The path defined in the Path for EBS Files field in the Bank Relations (tfcmg0510m000) session appears by default. You must add the file name.

To add the current date to the filename, append a tilde (~) to the archive directory defined in the Path For EBS Archive field in the Bank Relations (tfcmg0510m000) session.

You can only convert a file once.

After conversion, the original EBS file is placed in the archive directory, and removed from the original directory.

Electronic Bank Statement

In case of errors, select an existing EBS file to be converted again.

Note: You can only select an EBS file if, in the CMG Parameters (tfcmg0500m000) session, on the Cash Details tab, under Electronic Bank Statements, the series was specified.
Converted Electronic Bank Statement

The ID of the converted bank statement.

Options
Handle each EBS line as new transaction

If this check box is selected, each individual EBS line is treated as a new transaction.

Validate

To validate the converted bank statement, select this check box.

Validation check

LN performs a number of checks before the converted bank statement can be processed further. Depending on the outcome of these checks, the following applies:

  • If the bank statement passes all checks, the entire bank statement line receives status Validated.
  • Otherwise, the Exception check box is selected, and the bank statement, including all its lines and details, receives status Validation Warnings.
Remove Leading Zeroes from Check Number

If this check box is selected, any zeroes preceding the check number are removed.

UTF-8 File Format

If this check box is selected, the EBS file to be converted can contain 8 bit unicode characters according the 'Unicode Transformation Format' (UTF).

Ignore Unknown Currencies

If this check box is selected, LN does not check that the currency specified with the original amount in the EBS file exists in the currency table. If this check box is cleared, and the currency is not present in the currency table, an error message is displayed and the conversion is stopped.

Note: This check box value is defaulted from the CMG Parameters (tfcmg0100s000) session.
Ignore MT940 Account Identification

If this check box is selected, LN does not check that the bank account in tag :25: of the MT940 file is equal to the bank account of the specified bank. If this check box is cleared, and the bank account from tag :25: is not equal to the bank account of the specified bank, the statement is skipped.

Note: If this check box is selected, and more than one statement is present in the MT940 file, all the statements are consolidated in one statement. If this check box is cleared, only the statement related to the specified bank is converted.
Related topics