Report Builder

Returns data with "AR" in any position

Returns data that begins with "AR"

Select the date by which to age the transactions. To have them considered past due on the Due Date, select the Due Date option button. Otherwise, select the Invoice Date option.

This is the date to age the encumbrances or invoices. It is the actual date of the encumbrance, or the date the invoice should be paid. The Aging Date defaults to today's date when creating a report. However, once the report is saved, the next time it is opened, the aging date does not change to the current date. It is saved as the date the report was created (or whatever date was entered), and remains as that date until it is changed.

Select a budget version in which to base the budget amounts. Budget versions are created by the Administrator using Organization>Set Up Modules>Budget>Budget Versions. If the Budget module is not installed, "Revised" is the default budget version.

Select a non-functional currency type from the drop-down list to translate the financial statement to another currency that was previously set up by the Administrator (Organization>Currency Setup). Alternatively, select None to run the report in the functional currency.

Select this option to print employer amounts on the report.

Select this option to have the EN (Encumbrance) and RV (Reserve for Encumbrance) accounts display in your format with the appropriate amounts. Whether the box is checked or not, this Encumbrance information is only available if you have set up the report format to include Encumbrance amounts. The report format setup is found at Reports>Financial Statements>Create Statement Format>Select Format tab.

Select this option to include (when the box is checked) or exclude (when the box is not checked) the encumbrances as expenditures. This option is only available if the Encumbrances module is installed.

Select this option to include (when the box is checked) or exclude (when the box is not checked) the Equity Section on the printed report. Whether the box is checked or not, this Equity information is only available if you have set up the report format to include Equity. The report format setup is found at Reports>Financial Statements>Create Statement Format>Create Outline tab.

Enter the exchange rate of the currency selected. This overrides the Rate displayed. The system multiplies this new rate times the functional amount of the financial statement to translate the statement into the selected currency.

Three different aging periods can be entered. The system uses this number and counts back from the Aging Date. The first aging period prints amounts with a date of 1 to the Aging Date. If you enter 30 here, the report includes amounts that are from 1 to 30 days from the Aging Date.

Select this option to display account codes and account totals on this report.

Clear this option to show all account types on the report (except Cash, AP, and AR); otherwise, the report displays only revenue and expense accounts.

Select this option to include opening balances (system or user opening entries) in detail. This entry type was designated during transaction entry.

The system displays the exchange rate for the selected currency based on the rate type and report Ending Balances. This was entered on the Maintain>Multicurrency>Exchange Rates form. The system multiplies the Rate times the functional amount of the financial statement to translate the statement into the selected currency.

Select an existing exchange rate type from the drop-down list. The system lists any custom types you created, along with two predefined rate types—Daily Spot Rate and Monthly Average Rate. Custom rate types were created using Maintain>Multicurrency>Exchange Rate Types.

Select this option to shows the net amount for each segment where totals have been requested. Otherwise, the report displays the total debits and total credits for each segment.

Select how to display the reporting period amounts—Monthly, Quarterly, or Yearly. This period is based on the dates selected for the Opening and Ending Balances on the Setup tab. The reporting period amounts display in the Reporting Period Amount column on the Content tab.

Select this option to round the amounts to the nearest whole number when printing the report. Select "None" to not round the amounts.

The second aging period includes amounts with a date of First Aging Period plus 1 day to Second Aging Period. If you enter 60 here, the report includes amounts that are from 31 to 60 days from the Aging Date.

Select a segment to substitute for the General Ledger segment, or leave it at the default, None. The GL Code or GL Group Code must be selected in the Report Body in order to use this option. Selecting a group code is the same as filtering by group code on the entire report.

Select this option to determine the statement level to print to. These levels (1-3) were created when the section titles were entered using the Reports>Financial Statements>Create Statement Formats>Create Outline tab.

Select this option to subtotal the detail by a calendar month. This subtotal always calculates according to calendar month end, (1-31) not the month end of the Fiscal Year. For instance, if the Fiscal Year-End is February 28, the system generates totals through the last calendar day of each month: 1-31, 2-28, 3-31, or 4-30. The system does not generate totals as of the 28th of each month: 1-28, 2-28, 3-28, or 4-28. In order for this option to work, the Show Totals check box must be selected for at least one column (on the Content tab).

Select this option to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together.

Select this option to suppress columns that have all zeros. Please note that this only applies to columns that have a zero value throughout the entire report.

For example, suppose there is a page break on the report by "Fund" and the columnar segment is "Program." The column may be zero for a Program Code on the first page, but that same column may NOT be zero for the Fund on page two. Therefore, the column will not be suppressed at all because there are values associated with it somewhere in the report that are not zero.

Select this option so that documents with zero amounts do not print. This eliminates records having zero in all amount columns. If it is not selected, every line prints, even if it has a zero value.

The third aging period includes amounts with a date of Second Aging Period plus 1 day to Third Aging Period. If you enter 90 here, the report includes amounts from 61 to 90 days from the Aging Date.

Select the start and end date you want to use to calculate and print total budget amounts. This range can exceed a 12 month interval.

Select this option to total processing group information.

Select this option to report only accounts showing unfavorable balances. For example, if the budget for an expenditure type account is $20,000 (USD) and the actual expenditures equal $21,000 (USD), there would be an unfavorable balance of $1,000 (USD). Revenue accounts are not shown.

Select this option to include unposted actual amounts. You can view how unposted transactions affect the detail balance information.

Select this option to include unposted transaction sessions. You can view how unposted transactions affect the detail balance information. When this option is selected, "Unposted Transactions Included in Report" prints in the report header.