Bank Account Reconciliation: Filter Bank Account Ledger Entries Based on Statement Date


Objects to be modified

  1. Table 273: Bank Acc. Reconciliation
  2. Page 379: Bank Acc. Reconciliation

Modify table 273 as shown below

Add a new Field Name – “Statement Date Filter”, Data Type – “Text”, Length – “30”


Modify page 379 C/AL code as shown below

On the OnValidate Trigger of field control “StatementDate” add the code as shown below


Modify page 379 Page Designer as shown below

Highlight the Part page named “ApplyBankLedgerEntries” (1)

On the SubPageLink line on the property window, press the eclipse button for the table filter page (2)

Add a new line on the table filter page as indicated below (3)

  • Hi,
    Just took a look at your document. And something caught my sight. Do you work for Microsoft? If not, then NEVER add a field with a number below 50000 into a standard table. Even if you can!!  Saw that's what you used for your Statement Date Filter field.

    But what is your question?

Reply Children