Go to “Inquiry >> Financial >> Analytical Accounting >> Distribution Query” and select “Query Maintenance”.
Click next and fill the ID and the name of the query:
Click next and select the needed columns:
Click Next and filter your data as needed, you could select any column to filter except the date which will be filtered later.
Click next and insert the order of the data sorting if you have a special sort order:
Now you are ready to filter your data based on the date or period and generate the report, just make sure you checked “Execute Query” and your report will be generated:
Next time you need to run this report, just select “Execute Existing Query” option from the first screen: