MNT50001 - General Ledger account report does not report Next Year Open for Balance Sheet accounts but does for P&L accounts

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
1 min read

Problem

Running the General ledger Account Report from the General Ledger Maintenance screen does not include the Next Year Open figure for Balance Sheet reports but incorrectly includes Next Year Open values for P&L accounts. 



Solution

https://jiwa.atlassian.net/browse/DEV-3918 MNT50001 - General Ledger account report does not report Next Year Open for Balance Sheet accounts but does for P&L accounts



SQL skills are required

A working knowledge of SQL Management Studio is required to complete this task

Run the attached SQL script over the database and the report will give the expected result - compatible for all versions of Jiwa 7.00.175 and earlier.

5 an