Follow

Create a Stacked Report

The Stacked Report is a custom report generator. It is the most powerful report in Agrimaster as it allows you to quickly report on any number of management areas. 

Unlike other reports that have mostly fixed parameters, the Stacked Report Generator gives you flexibility because it can quickly produce a variety of reports using criteria selected by you. Transaction data can then be displayed for up to four levels, based on your selections such as code, enterprise, allocation, description (saved), year, quarter, month, bank and name. 

To produce a Stacked Report: 

  1. At the Home Page, click Cash Book image001.jpg
  2. Click Report image002.jpg 
  3. Click Stacked Report image003.jpg
  4. The Stacked Report Generator will be displayed. You have up to four levels of selection categories to filter the data for reporting within a selected date range 

    image004.jpg

  5. Use the drop-down arrow (picklist button) in the Level 1: field to select the first search category, for example Code 

    image005.jpg

  6. A list of Codes will appear below the first level from which you must select the search criteria. In this example, we are using Repairs-Plant / Mach code 

    image006.jpg

  7. Select the First Month and the Last Month from the drop-down boxes. In this example, we are using July 2015 to September 2016
  8. In the Report Type section, you can choose Totals or Details. In this example, we are using Details which will display all transactions within the chosen date range
  9. In the Sort By: section, you can sort the filtered transactions by Date, Record or Reference. In this example, we will sort by report by Date
  10. In the Date to use section, you can filter transactions
    • by the date in the transaction
    • by the date of the transaction if it has been reconciled (bank statement) or
    • date of the transaction if it is an invoice. In this example, we will use Transaction
  11. Select any optional information you wish to display from the Options and Include: sections
  12. The report may also be given a title
  13. Click the green tick to display your report on the screen  

    image008.jpg

  14. Click the printer icon  to print the report (or create a PDF copy to save or email)
  15. Click the black X after printing the report 

You can choose to create a Stacked Report using the other levels to filter the data for reporting purposes. For example: a report can be generated by Code (Level 1) and then within that code it can be filtered by Allocation (Level 2) and then finally filtered by Bank (Level 3). Each transaction displayed on the report will meet the conditions in Level 1, Level 2 and Level 3.

image011.jpg

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments