GeneralLedgerCS > General Ledger > Reporting menu > GL Audit Trail window > GL Audit Trail window: Report Options tab
GL Audit Trail window: Report Options tab
Use the options on this tab to define your report criteria.
Fund Number (Fund product only) 
Enter a fund number to show only accounts in that fund on the report.
Print All Funds (Fund product only) 
This drop-down is only active if the Fund Number field is blank. If you want to print one report that displays all the included funds, select Combined from the drop-down. If you want to print a separate report for each fund, select Separated.
Starting GL Account / Ending GL Account 
Use these boxes to set the range of accounts you want to include. The default settings for these boxes include all the accounts in your Chart of Accounts.
(Fund product only) If you selected a source fund, the Lookup will be filtered by the selected fund and the fund number will appear in the appropriate segment.
Report Type 
Choose the Report Type according to the type of information you want to see and the way you want it organized.
Detailed: Prints a complete, detailed listing of the transactions that have taken place in each account for a specified time period. It includes the date and the module from which the transaction was posted, the user ID, and batch number information for each transaction.
Detailed Landscape: Prints the same information from the detailed report in landscape format and includes posting reference and running balance information.
Single Line Landscape: Prints the detailed landscape report, but doesn’t include a second line for each transaction.
Drilldown: Prints a report that allows you to drill down to view individual transactions. Choose any line on the report for which you want more information and double-click. A new report page will open showing transaction information specific to the line you selected. You can only print this report to screen.
Use 
Use this drop-down list to select whether you want to run this report by period or date. Depending on your selection here, the labels for the Starting and Ending boxes below will either read Starting Period / Ending Period or Starting Date / Ending Date. The default for this option is Period.
Skip No Activity 
Select this check box to exclude accounts with no activity within the date range. If you choose to skip accounts with no activity, your report totals might appear out of balance.
Skip Zero Balance 
Select this check box to exclude accounts that have a zero balance for the specified time period on the report. If the accounts have a balance, but not in the time period shown on the report, they will not appear on the report. If you choose to skip accounts with zero balance, your report totals might appear out of balance.
Print Subtotals 
Select this check box to include subtotals by month for the included GL Accounts on the report. To run the report without subtotals, deselect the check box. The default for this check box is checked.
Starting Period / Ending Period 
Enter the starting and ending period number(s) that you want to include in the report. You can choose any period(s) in your fiscal calendar, from 1 to 60. If you want to include only one period in the report, enter the same number in both the Starting Period and Ending Period boxes. The defaults for these boxes are the Present Period as shown in your fiscal calendar.
When you enter the period number, the first date of the starting period and the last date of the ending period will appear to the right of the corresponding boxes so you can verify that these are the periods you want to include in the report.
(Fund product only) If the Allow multiple fiscal calendars check box is selected in Module Preferences and the fund calendar is different than the organization calendar, the fund’s organization calendar will be used for these dates.
Starting Date / Ending Date 
If you select to use Date in the Use box, specify the posting date range of the transactions you want included in the report. To specify a posting from a single date, enter the same date in both boxes. The defaults for these boxes is the system date.
Date Range 
This option is only enabled if you select Date in the Use field on this tab. From the drop-down, select a predefined period to run the report for.  
Print Prior Year 
If you chose Period in the Use box above, you can specify which year to include in the report by selecting this check box, and then entering the number of years back to print in the Years Back To Print box at the right, which will become activated once the Print Prior Year check box is selected. If you chose Date in the Use box above, this check box is unnecessary and becomes inactive since you will instead specify the year by the date you enter. The default for this check box is unchecked.
Years Back To Print 
If you selected Period in the Use box, and selected the Print Prior Year check box, enter the number of years back that corresponds to the period you want included in the report. For example, if you want to see Periods 1 through 3 of last year, you would enter 1 in the Starting Period box, 3 in the Ending Period box, select the Print Prior Year check box, and enter 1 in the Years Back To Print box.
Include Inactive Accounts 
Select this check box if you want to include inactive accounts on the report. You can mark accounts inactive in the GL Accounts window. If you have a balance in your inactive accounts and you don’t include them on the report, your report might be out of balance.
Use Account Filter 
Select this radio button and enter a filter to use to print a customized report which includes only those accounts that meet the filter criteria.
Sort by Fund (Fund product only) 
This check box is only active if you select Combined from the Print All Funds drop-down. Select this check box if you want to sort the included accounts by fund number.
Account Filter 
If you selected the Use Account Filter check box, enter a filter to use to specify which accounts to include. Only accounts that match the specified filter criteria will appear on the report. Use wildcards (* and ?) to establish the filter parameters. Substitute a (?) for any single character in the account number, or an (*) for any number of characters. For example, to include all four-digit accounts beginning with a 1, enter 1??? in the Account Filter box. To include all accounts that end in 02, enter *02.
Use a custom report 
This check box is only available if you defined a custom report for this window in Controller. Select this check box if you want to run a custom report instead of the default report. The drop-down is enabled after you select the check box and you can choose the custom report you want to run. 
 
 
Published date: 03/18/2020