Table of Contents

Payment Reconciliation Journal Enhancements

Use this guide to configure text-to-account mapping enrichment and verify value transfer to reconciliation journal lines.

Outcome

After this guide:

  1. Mapping rules can assign posting groups and dimensions to journal lines.
  2. Optional bank-account-linked mappings are scoped correctly.
  3. Mapped values are applied and reset correctly through reconciliation actions.

Before You Start

  1. Confirm required Gen. Prod. Posting Group and VAT Prod. Posting Group values exist.
  2. Confirm required Shortcut Dimension values exist.
  3. Identify at least one real bank statement text pattern for testing.

Step 1: Configure Mapping Enrichment Fields

  1. Open Text-to-Account Mapping.
  2. Create or edit mapping rules.
  3. Set Gen. Prod. Posting Group and VAT Prod. Posting Group.
  4. Set Shortcut Dimension 1 Code and Shortcut Dimension 2 Code where needed.
  5. Save.

Pass criteria:

  1. At least one mapping includes posting group and dimension values.

Step 2: Configure Wildcard Matching

  1. For variable statement text, use wildcard asterisk in Mapping Text.
  2. Keep stable text before and after the wildcard.
  3. Save and document expected match examples.

Pass criteria:

  1. Mapping expression matches expected transaction text patterns.

Step 3: Configure Optional Bank-Linked Mapping Scope

  1. Open Bank Account Card.
  2. Enable ApplyLinkedTxtToAcc_BANK_LINC where bank-specific mappings are required.
  3. On Text-to-Account Mapping lines, set linked bank account.
  4. Save changes.

Pass criteria:

  1. Linked mappings are only evaluated for their assigned bank account.

Step 4: Validate Value Transfer to Journal Lines

  1. Open Payment Reconciliation Journal with test data.
  2. Run matching process.
  3. Confirm mapped Gen. Prod. Posting Group, VAT Prod. Posting Group, and dimension values appear on journal lines.

Pass criteria:

  1. Values copied from mapping to journal lines are correct.

Step 5: Validate Reset Behavior

  1. Remove or reverse applied payment entries in a test scenario.
  2. Confirm mapped values are reset according to process design.

Pass criteria:

  1. Reset behavior is consistent and leaves no stale values.

Completion Checklist

The setup is complete when all checks below are true:

  1. Mapping rules contain required posting groups and dimensions.
  2. Wildcard mappings are validated against real text samples.
  3. Bank-linked mapping scope works as expected.
  4. Apply and reset flows both behave correctly.