Balance Sheet Inquiry

Ad Hoc reporting allows you to author system and personal G/L reports by using the Ad Hoc report writing interface without having to leave the Financials application. The report-writing interface allows you to custom design G/L financial statements with instructions used to determine the type of information that should appear on the report. Accounting information from multiple offices can be consolidated into a set of financial statements. You can show budgets, comparatives and variances on the financial statements and round amounts to the nearest dollar. The financial statements can be printed at any time and for any accounting period. Functionality allows you to easily filter data on selected formats, apply mathematical calculations, as well as apply conditional formatting. You may also export your data to Microsoft® Excel® or Adobe® Acrobat®.

See Balance Sheet Fields for a list of data fields that are available and an explanation of each.

Select General Ledger|Ad-Hocs|Balance Sheet Inquiry.
The Balance Sheet Inquiry – Authorized window displays based on authorization to create system reports and grant authority to users or revoke authority from users. If you do not have authorization to create system report, you will not see this window. Instead, you will advance to the Balance Sheet Inquiry Prompt where you can create personal reports or if authority is restricted, view/print reports. Refer to the Authorized Window Security section for detailed information.
Click the Next icon to advance to the Balance Sheet Inquiry Prompt Window.

From the Views Filter drop-down list, select the type of report to limit the number of reports that display in the View drop-down list. Reports are color coded so that they can be easily identified when displayed on the various Tabs. For example: If you select Personal, only Personal reports will be available for selection and will be highlighted in turquoise throughout the filtering process.

All. Lists all reports in the View drop-down list.
Personal. Lists all Personal reports in the View drop-down list.
Corporate. Lists all Corporate reports in the View drop-down list.
Company. Lists all Company reports in the View drop-down list.
Office. Lists all Office reports in the View drop-down list.

The View drop-down list contains a list of preexisting reports as well as the Default Standard Report. From the Views drop down list, select the applicable report.
From the Printing Scheme drop-down list, select the Printing Scheme (optional) code to display only those accounts attached to the scheme. Print Code Schemes are set up in Financials|Data Base Maintenance|G/L Print Code Schemes and are used for arranging your General Ledger accounts. If you want all accounts displayed, do not key a Printing Scheme.

Important: Print Code Schemes must be set up in the Data Base before you can effectively use ad hoc reports.

Note: If you key a Printing Scheme but your formatting requires all accounts, error messages display informing you that the template requires accounts and lists the accounts that are missing from the scheme.

Accept the Fiscal Month/Year or key the date applicable to your report you are creating or editing. If necessary, this month/year can be changed within the report template. Note: Your signon Month/Year will not affect data that is reported.
Key the identification code of the office budget in the Budget #1 field (Optional) to compare general ledger balances to budgeted amounts and display variances for the specified period.
Key the identification code of the office budget in the Budget #2 field (Optional) to compare general ledger balances to budgeted amounts between two different budgets and display variances for the specified period.
Click in the Consolidate box to report activity for all offices together.
Click in the Print as Final box (Optional) to run the final version of your report and to print the word FINAL in the report header. This action does not close your General Ledger. If the offices to which you are authorized are not closed for the specified accounting month, an error messages displays along with a list of all the offices that are not closed.
The Exports All Detail checkbox allows you to populate all line items on the export with detail. Detail repeats company/office codes, company name, office name, etc for each line item on the export. Click in the checkbox to populate all line items on the export with detail after you click the <Export to Excel> or <Export to CVS> icon. Leave the checkbox blank to only show the first line of detail and leave detail off subsequent line items.
Key the Maximum amount of rows you want to display on the report in the Max Rows field. If necessary, the maximum amount can be adjusted within the report template.
To limit the collection of information, click any of the Selection buttons and make selections from the displayed lists. Information is collected for only the items you selected.
Click the Next icon to load information and display data in the View Tab.