Initiate Automatic Validation of a Bank Statement and Correct Any Errors

Outcome

The bank statement is validated. Examples of checks made are that:

• All dates have the correct format and exist in M3
• Opening balances equal the 'To balance' on the bank account in M3.
• Exchange rate is specified
• The bank statement number does not already exist in M3.

If a workflow option (next manual step) was used during validation, other steps in the processing of the statement, such as allocation and update of general ledger, may have been carried out automatically.

You proceed with the next step in the processing of bank statements. Refer to Automatic Processing of Bank Statements.

Before you start

• A bank statement, received as bank file or entered manually, exists in 'Bank Statement. Open' (ABS100) in status 2 = 'Ready for validation.'

Follow these steps

1. Select one of these alternatives:

   • To initiate the automatic validation, go to step 2.
   • To review the validation and correct any errors, go to step 4.

   Initiate Automatic Validation

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

3. Select one of these alternatives:

   • Select option 21 for the bank statement that you want to validate.
   • If you do not only want to initiate the validation, but also want the automatic allocation to be done, select workflow (next manual step) 3 and then select option 21 for the statement.
   • If you do not only want to initiate the validation, but also want the automatic allocation to be done and general ledger to be updated, select workflow (next manual step) 4 and then select option 21 for the statement.
   • If you only want to validate a single bank statement line, select option 11 for the bank statement to start 'Bank Statement. Open Line' (ABS101/B). Select F14 for the line you want to validate.

   Review the Validation and Correct Any Errors

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

5. Review the status of the bank statement that has been validated. If the status is:

   • Greater than 4 = 'Errors in validation,' that means that the statement passed the validation and that you can continue processing the statement.
   • Equals 4 = 'Errors in validation,' that means that the validation of the statement failed. If so, proceed with next step.

   Review and Correct Errors

6. Start 'Bank Statement Display Error' (ABS103/B), by selecting option 12 for the bank statement in (ABS100/B) or option 12 for a bank statement line in (ABS101/B).

7. On the B panel, determine which validation errors to display:

   • To display all validation errors, select sorting order 1.
   • To display all validation errors, select sorting order 1.

8. Review the text that is connected to an error.

   There exists numerous amounts of possible errors, therefore every single error is not listed in this document. Attached to each error is an error text that describes the error. Reading this error text should give you enough information to be able to correct it. Examples of errors are:

   • • 002 - 'Debit and credit amounts does not match total line amount.'
     • 010 - 'Currency does not exist. Check the currency table in (CRS055).'
     • 020 - 'Bank account identifier is missing. Check (ABS900).'
     • 030 - 'Bank statement number already exists for the bank account identity and bank statement date.'
     • 050 - ’Error in bank account string. Check accounting string on (ABS100/E).'

9. Correct the errors.

10. Return to step 2 to initiate a new validation.

    Note that if next validation succeeds, all earlier errors for the statement are deleted.