Issue

In WRD Borgers' all payroll payments in the Bank Ledger Entry table are posted with only the Summary Amount and the Statement Status=closed, however the cheques in the Check Ledger Entry table maintain a  Statement Status=Open until cleared through the Bank Reconciliation process. ISSUE: After the upgrade, when using Suggest Lines, some of the open cheques were not being brought into the Bank Reconciliation - Check tab for the Payroll Bank Account. Bank Reconciliation Differences Between Attain 3.6 and NAV5.0 SP1 In NAV360 the bank reconciliation code process is: 1. Filter the Bank Ledger Entries by Bank Account (No filter on Statement Status) 2. Checks the corresponding check ledger entry. . If the check ledger entry."Statement Status" is Open, Bank Entry Applied or Check Entry Applied, then the system inserts a Cheque line in the Bank Reconciliation. . If the Bank ledger entry."Statement status" is Open and the Check Ledger Entry."Statement Status" is equal to Closed, then the system inserts a deposit/transfer line in the Bank Reconciliation. In NAV50SP1 Bank Rec. report 10406 simplified the Bank Rec. process as follows: 1. Check the Bank Ledger Entries for the bank account to get all records where the "statement Status"=Open 2. Checks the corresponding check ledger entry records' "Statement status". . If the Check Ledger Entry."Statement Status"=Open, then the system inserts a Cheque line in the Bank Reconciliation. . If the Check Ledger Entry."Statement Status"=Closed, then the system inserts a deposit/transfer line in the Bank Reconciliation.

Solution

Modify the code in NAV 50SP1 to function as it did in NAV360 (Attain 3.6)