Understanding Reporting

Multiple reporting tools are available in most aACE modules. These reports usually focus on the found set currently displayed in the module list view.

This guide uses the Invoices module (Main Menu > Accts Receivable > Invoices) as an example. 

Viewing and Generating Reports

Click the Print () header link to access some of the most commonly used reports. You can also access additional reports by clicking Print > Open Report Selector.

The Report Selector

This selector provides a longer list of reports related to the current module, and also provides additional functionality.

1. Generate a report — Click the report name. aACE prompts you for any needed info, then displays the data.
2. Review details about a report — Click the question mark icon across from a report name (if any) to display helpful information about it. 
3. Verify your Report Pack version — Important information to convey when inquiring about support on reports.

Navigating a Report

After you generate a report, use the controls in the FileMaker report header to navigate, save, or print  the report:

1. Navigate through the report by:
   • Stepping one page at a time with the forward / back arrows
   • Jumping to a specific page by typing in a page number
   • Navigating through the pages with the slider
2. Save the report data as an editable Excel spreadsheet.
   Note: This export is handled by FileMaker. The results may range from poor quality to a perfect replication of the report. aACE does not control the appearance of the export results. 
3. Save the report data as a static PDF file.
4. Print the report.

Saving or Printing the Records Being Browsed

When you save or print a report, verify that the data to be included is set to "Records being browsed". This ensures that all the information displayed on the report is included in the saved file or the printout.

Out-of-the-Box Reports

aACE developers have used FileMaker to build a variety of reports that are included in every aACE system. Default reports are built by aACE programmers and distributed to all Maintenance subscribers in Report Packs. Each Report Pack includes all previously-released reports. 

Updates to Reports

Report Pack updates are distributed to all Maintenance subscribers during scheduled maintenance updates. These updates may include modifications to previously-released reports, plus newly developed reports.

Custom Reports

Occasionally users may find that they require a report that does not exist in the installed Report Pack. Unfortunately, the FileMaker development environment does not currently provide the ability to create custom reports instantly. 

Instead, each report in the aACE Report Pack has been developed using the following process:

1. Submit a request to your system administrator including:
   • Clear specifications for the report
   • Your current Report Pack version number (see above)
2. Your system administrator provides this information to your aACE partner.
3. Your aACE partner works with aACE developers to determine whether the requested report could be added to the Report Pack. Oftentimes this can be done free of charge. 

Some report requests will not be added to the Report Pack. Usually this is because they are not widely applicable or because they rely on fields custom to your solution. In such cases, your aACE Partner could develop and install the report. 

Most companies only generate a handful of reports on a regular basis. These reports should be printed from your aACE solution, either via a report in the Report Pack or a custom report. If your business processes require ad hoc reporting, we recommend either exporting the data from aACE as an Excel spreadsheet or else integrating with a business analytics solution like Tableau. 

Customizing Printouts Sent to Your Customers/Vendors

Certain printouts are related to a transaction you would send to a customer (e.g. sending an order, invoice, or receipt). System administrators can edit these print layouts.

Note: aACE Complete customers may find that semi-annual maintenance updates overwrite some aspect of an edited print layout. We recommend keeping precise and thorough notes about your edits to make it easy to recreate them if necessary.