Troubleshoot report query

Introduction

The customer complained that the report returns error or having different amount.

Steps:

1. Check the server log while generating the same report.
   
   

   Open

   

   
   Identify the query for the report
   
   

2. Rearrange the query for easier checking. You can use https://sqlformat.org/ to rearrange the query.
   
   

   Open

   

    

3. As shown in the example, this report (SR-01) pull the data from table cust_invoice_index for date in 2021-07-06 and for branch 32, 33, 42, 36, and 37.
   
   

4. You can troubleshoot the report from the query, either error in the report or compare the reports to find out which part causes the report to not tally.