DB GL Reconciliation Report can give variance between Current Year Open + Current Year Movement and Next Year Open - 702.00 and 7.02.01

Problem

Running the DB GL Reconciliation report for Current Year 1 to 12 and Next Year period 1 to 12 can give a different closing Current Year figure to the Next Year open figure.

Solution

The underlying stored procedure usp_JIWA_Debtors_DebtorsAndGeneralLedgerReconciliation was calculating opening balance date to the minute instead of to the second, which meant some transactions slipped through unaccounted for.

Download and apply the attached stored procedure to correct the report

Open

Related articles