Photo credit: vojtisek

Problem: The Trans. Bank Rec. to Gen. Jnl. batch job doesn’t apply template filter correctly on the request form.

Affects: Dynamics NAV 2009 Classic

When using the Bank Acc. Reconciliation we have the option to transfer bank transactions that need to be posted to a journal.

This is done via the Trans. Bank Rec. to Gen. Jnl. batch job.

On running the batch job, a destination journal is selected by completing the Gen. Journal Template and Gen. Journal Batch fields on the request form

In my example I select the CASHRCPT journal template which has the following batches setup:

On looking up to select the required batch I get the following:

Where are my batches associated with this template?

The problem is caused by the default lookup form for the General Journal Batch table, which is Form 251, the one shown when looking up for a batch.

This form contains the following code in the OnInit() trigger which promptly kills filters put in place by the batch job.

SETRANGE("Journal Template Name");

To fix the problem, modify the code in the OnInit() trigger as follows:

IF "Journal Template Name" <> '' THEN
 SETRANGE("Journal Template Name");

The correct batches for the selected journal template will now be shown:

This bug only presents itself in Dynamics NAV 2009 when running the Classic client.