Initiate Automatic Allocation of a Bank Statement

This document explains how you initiate automatic allocation for a bank statement that has been validated.

It also explains how to initiate automatic allocation for a single statement line. This can be useful if you have already partly allocated the statement, and where you only have to allocate single statement lines in order for the statement to be fully allocated.

Outcome

Automatic allocation of a bank statement is initiated and carried through. The affected invoices are blocked, and general ledger transactions may have been created as well. If the statement is not fully allocated, you have analyzed why.

If a workflow (next manual step) option was used and the statement is fully allocated, then general ledger is updated with one or several created vouchers. If so, the open invoices allocated to the line are closed.

Refer to Review a Partly or Fully Allocated Bank Statement for information about how to proceed.

These files may have been updated, depending on the extent of the automatic work that has been performed:

  • Bank statement header (FABHED)
  • Bank statement lines (FABLIN)
  • Bank statement lines, details, (FABDET)
  • Bank statement lines, additional information (FABLIX)
  • Remittance header (FAPREH)
  • Remittance details - invoices (FAPRED)
Note:  The remittance details table (FAPRED) and the remittance header table (FAPREH) are updated only in the situation where the bank statement contains supplier payments set up for electronic bank confirmation in 'Supplier Payment. Report Electronic Bank Confirmation' (APS187) and 'Electronic Bank Confirmation. Open Details' (APS188). This setup is made on the payment method defined in 'AP Payment Method. Open' (CRS071) by setting the parameter 'Bank Confirmation' to 3='Yes, electronic by ABS'.

Before you start

  • Ensure that the starting conditions listed in Automatic Processing of Bank Statements are met.
  • Ensure that a bank statement has been received as a bank file or entered manually and validated. This means that the statement is in status 4='Ready for allocation', or 5='Partly allocated.'

Follow these steps

  1. Start 'Bank Statement. Open' (ABS100/B).

  2. Select one of these alternatives:

    • Select option 22 for the bank statement you want to initiate an automatic allocation for.
    • Select workflow (next manual step) 3 and then select option 22 for the bank statement you want to initiate an automatic allocation for.
    • Select workflow (next manual step) 4 and then select option 22 for the bank statement you want to initiate an automatic allocation for, and where you ALSO want to update general ledger automatically, if the allocation is successful.
    • Select option 11 to start (ABS101). Select option 22 for the single statement line that you want to initiate an automatic allocation for.