Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 4 Next »

 Problem

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

Solution

To re-instate, 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


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

  • No labels