How to do Age Analysis Integrity Test on the Debtor Drilldown Report



An Age Analysis Integrity Test can be done on the Debtor Drilldown Report. If the Age amount is not equal to the amount of the Movement Summary this test will fail and when the Age Amounts balance the test will pass. 

Please Note: An Integrity Test can only be done on a Debtor Drilldown Report that is for a specific Financial Period.

  • This user manual will start on the Reports screen. 


  • Click on the +Add New button.  


  • The Report Profile screen will open. 


    • Select the Debtor option on thReport Category drop-down menu. 


    • Select the Debtor Drilldown Report on the Report Type drop-down menu.  


  • The Settings and Parameters of the Debtor Drilldown Report will open.


    • Choose the Settings and Parameters of the information that you want to have displayed on the Report.
    • Scroll to the Settings section and Tick the Integrity Test checkbox.


    • Click on the Generate Report button to create the Report.


      • A Notification will appear to advise that the Report is being generated in the background. 


      • A second Notification will appear once the Report has successfully been generated. 


  • The Report will then appear on the Report List screen.


Please Note: The Report may take a while to load. If the Report does not appear on the list immediately, Click on the Updates Results button to refresh the Report List.


  • Click on the Report that you have just generated.


    • The Report will open with an indication if the Report that has been generated has Passed the Integrity Test and if the Age has Balanced.


Please Note: If the Age does not Balance the test will Fail. An indication will show the Integrity Test has Failed.



Last modified: Tuesday, 30 April 2024, 4:10 PM