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

Business Central/NAV General Discussions
1

Bank Account Reconciliation.docx (262 KB)

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”

pastedimage1533658505126v2.png

Modify page 379 C/AL code as shown below

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

pastedimage1533658537196v3.png

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)

pastedimage1533659738780v1.png

2

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?

3

Hi, That is very true. Your observation is very right, because in future releases of NAV by microsoft, any number below 50000 can be used by the NAV team when new fields are added to the table in an expansion move. Thanks for pointing that out.

4

Is that your only question? Or why did you share this?