Page Comparison

...

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

Solution

To re-instate, then changes have to be made to the stored procedure dbo.usp_Jiwa_Debtors_StatementsAsAt and the Debtor As At Statement report.  To make these changes, follow the detailed instructions in the attached document.   View filenameDebtor Statement that shows unaged zero balanced transactions.pdfheight250 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

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 the database has

Image Added