Page Comparison

...

In Jiwa 7 we no longer include zero balanced transactions in the debtor statement report.

Solution

To re-instateinclude these transactions in the statements, changes have to be made to the stored procedure dbo.usp_Jiwa_Debtors_StatementsAsAt and the Debtor As At Statement report.  Anytime you upgrade to another Jiwa 7 version, you will need to edit and run this stored procedure again because the upgrade process will override your changes.

1. change the line --AND AgedOut = 0 by removing the two dashes before that statement

...

1. i.e. AND AgedOut = 0

Image Added

To make this change permanent you will need to

1. copy the standard stored procedure and assign a new name to the copied stored procedure 
2. change the name of the report 
3. change the stored procedure that the report addresses (in the Crystal Report)
4. import the new report into the database using Refresh from Files under Reports > Report Configuration > Reports
5. attach the new report to the various print groups Form Report Definitions for each print group in the database has