Reset a Bank Statement

This document explains how you reset a bank statement that was involved in a job that ended abnormally.

Tables

During processing of bank statements in 'Bank Statement. Open' (ABS100), four main tables are updated:

The statuses, block codes, and amounts in these four tables indicate how far the bank statement has been processed. When a job has finished, the values in these four tables should reconcile. Even if a job is interrupted, before it has finished completely, the values in these four tables will continue to reconcile, and it will be possible to restart the job.

Block codes

Three main steps are taken during processing of a bank statement in (ABS100):

  1. Validation
  2. Allocation (automatic, or manual, or both)
  3. Update to general ledger (GL)

During processing of a bank statement, block codes are set for the header, or for the line, depending on where the job is started. If the job is started in (ABS100), the block code is set for the header in FABHED. If the job is started in (ABS101), the block code is set for the line in FABLIN. The purpose of the block codes is to prevent other users from processing the same bank statement, or line, at the same time.

If the job ends normally, the block code is automatically removed, but if the job is interrupted, the block code will remain on the header, or on the line. Block codes for both the header and the lines can be removed by using correction ID 'AB01' in 'Program Problem. Solve' (CRS418). When the block code has been removed, the job can be restarted in (ABS100), or (ABS101).

By using F11='Blocked transactions' in (ABS100), only bank statements that have a block code in FABHED or FABLIN will be listed. Similarly, if F11 is used in (ABS101), only bank statement lines that have a block code in FABLIN will be listed. If F11 is pressed a second time, all information will be displayed.
Note: Because bank statements with an active job also have a block code, the block code itself does not necessarily indicate an interrupted job. The block code for a bank statement with an active job must not be manually removed using (CRS418), as this could result in duplicate and incorrect updates, if the job was restarted.

Validation

During validation, bank transactions are created in FCR040 table. Either, one bank transaction is created for the entire bank statement, or one bank transaction is created for each bank statement line. If a validation job is interrupted, all transactions in FCR040 might not have been created yet. After having removed the block code in (CRS418), the validation can be restarted in (ABS100).

Automatic allocation

During allocation, allocation records are created in FABDET and in FCR040, and allocation information is updated in FABLIN and in FABHED. If an automatic allocation job is interrupted, all allocations may not yet have been made, but the allocation information in FABLIN and FABHED should continue to reconcile with the total of the allocation records created in FABDET and FCR040. If the interrupted allocation job was started in (ABS100), a block code would be found for the header in FABHED. If the interrupted allocation job was started in (ABS101), a block code would be found for the line in FABLIN. After having removed the block code in (CRS418), the allocation should first be released, and then restarted, in (ABS100) or (ABS101).

Update of the general ledger

During update of GL, the transactions in FCR040 are updated in the general ledger, as well as in accounts receivable and accounts payable, if applicable. The records in FCR040 are processed differently, depending on whether the voucher is created for the entire bank statement, or for each bank statement line.

If one voucher is created for each bank statement line, the transactions in FCR040 are handled for one batch number (= one bank statement line) at a time. A voucher number is retrieved for the batch, and the status is changed from 1 to 0 for all transactions included in that batch in FCR040, allowing GLS040 to update the voucher in the general ledger and other tables. When one bank statement line has been processed, the voucher number is updated for that line, and the status is set to 9 in FABLIN, and the next batch number is processed in FCR040. If such an update job is interrupted, some bank statement lines could have been updated to status 9 already, whereas others might not have been processed yet. As long as all bank statement lines have not been updated to status 9, the header remains in status 6 in FABHED. After having removed the block code in (CRS418), the update of the remaining lines can be restarted in (ABS100). If a GLS040 job remains in 'Trans Work File. Restart Interrupted Jobs' (GLS047), it can be restarted from there.

If one voucher is created for the entire bank statement, a voucher number is retrieved and updated for the bank statement header in FABHED. The status is changed from 1 to 0 for all transactions in FCR040 for the job number, allowing GLS040 to update the voucher in the general ledger and other tables. After that, the status of all the bank statement lines is set to 9 in FABLIN, and finally the status of the bank statement header is set to 9 in FABHED. If such an update job is interrupted, the job would be found in (GLS047), where it should be restarted. The status of all the bank statement lines might not have been raised to 9 yet, but in this situation, the status of the header will still be set to 9, to avoid further updates by the user. If the user attempts to perform changes in (ABS100), (ABS101), or (ABS102), this error message is received: ‘Option &1 is not allowed. Check (GLS047) for an interrupted job.’

If a voucher created during update of a bank statement to the general ledger would be deleted from 'Voucher. Open Erroneous' (GLS038), or reversed in 'Voucher. Reverse' (GLS900), the bank statement tables (FABHED, FABLIN, and FABDET) would not be updated. The bank statement (line) would remain in status 9.

Outcome

The bank statement is reset, meaning that the block code is removed for the bank statement header, or line, allowing you to resume the processing of the bank statement.

These tables are updated when (CRS418) is used to remove the block code:

Before you start

Follow these steps

Release block of bank statement and lines

  1. Start (CRS418).
  2. On the B panel, select the correction ID 'AB01'.
  3. On the E panel, release the block by:
    • Specifying the unique identity of the bank statement, that is, the job number/date/time. Confirm by pressing Enter.
    • Browse the 'Job number' field and select the bank statement from the list. You can position on a bank statement number in the list, where job number, status, block code, and user ID is also displayed. Confirm by pressing Enter.

    Continue processing the bank statement in (ABS100) or (ABS101)

  4. Resume the processing of the bank statement:
    • For validation: Continue with step 5.
    • For automatic allocation: Continue with step 6.
    • For update of the general ledger: Continue with step 7 or 8.
  5. If the interrupted job concerned a validation of the bank statement, restart the validation in (ABS100).
  6. If the interrupted job concerned an automatic allocation of the bank statement, release the allocation in (ABS100) or (ABS101), and then restart the automatic allocation in (ABS100) or (ABS101).
  7. If the interrupted job concerned an update of the general ledger for a bank statement, for which one voucher number is created for each bank statement line, restart the update in (ABS100) or (ABS101).
  8. If the interrupted job concerned an update of the general ledger for a bank statement, for which one voucher number is created for the entire bank statement, restart the update in (GLS047).
Related topics