Reporting Field Maintenance

Menu Path: General Ledger $Images\bluerarw.gif$ Accounts $Images\bluerarw.gif$ Setup $Images\bluerarw.gif$ Reporting Field Maintenance

Purpose

Create new reporting fields and update existing fields.

Overview

Use Reporting Field Maintenance to customize your reports through the use of reporting fields. A reporting field is a user-defined field that may contain any type of useful data pertaining to an individual account. Each reporting field adds a new column to the general ledger chart of accounts, and can be used to group specific accounts together. They may also be used to create numerous types of useful reports.

For example, you can create a reporting field named Tax Line with a column of the same name, which contains a tax form name and line number. The Tax Line column will be added to your general ledger chart of accounts, and you can select accounts that appear as a line on a tax form. You can then, for example, generate a customized report for each form that prints the account balances for each account that has the Tax Line reporting field.

Creating and Editing Reporting Fields

Before attaching a reporting field to an account, you must first define and customize your reporting fields.

To create a reporting field:

If your company uses consolidation ledgers, verify the ledger ID for which you want to create a reporting field is entered in the Ledger ID field.
Click the New button in the ribbon.
Enter a name for the field in the Reporting Field field.
Enter a short description of the reporting field in the Description field.
Enter a sort order number in the Sort Order field to select the order in which the reporting fields appear in generated reports. If you want, for example, to have a specific reporting field appear before all others, assign it a sort order of 1 and assign the other reporting fields a higher sort order number. This does not have any bearing, however, on how the reporting field column is displayed in the general ledger chart of accounts.
Enter a detailed description of the field in the Detail Description field.
Click the OK button in the ribbon. The reporting field is created. You can now assign a general ledger account and data to the field in Reporting Field Data Maintenance.

To update an existing reporting field, select a field, and click the Update button in the ribbon. Make any necessary changes and click the OK button in the ribbon to save the updated definition.

Ribbon Home Tab Buttons

Button	Description
Exit	Click this button to close the Reporting Field Maintenance window.
New	Click this button to create a new reporting field.
Update	Click this button to update the selected reporting field.
Delete	Click this button to delete the selected reporting field. If data is associated with the reporting field, the Confirm Delete dialog box appears, and asks you to confirm whether you want to delete the reporting field. If you want to proceed, click the Yes button.
First	Click this button to display the first reporting field.
Prev	Click this button to display the previous reporting field.
Next	Click this button to display the next reporting field.
Last	Click this button to display the last reporting field.
OK	Click this button to accept an action. This button is only available after you click the New, Update, or Delete button in the ribbon.
Cancel	Click this button to cancel an action. This button is only available after you click the New, Update, or Delete button in the ribbon.

Fields and Buttons

Field or Button

Description

Reporting Field

Enter a reporting field name, or click the Lookup button to select a reporting field.

Ledger ID

Enter a ledger ID for the reporting field, or click the Lookup button to select a ledger ID.

Note This field is only available if at least one consolidation ledger is set up.

Main Tab Fields and Buttons

Field or Button	Description
Description	Enter a short description of the reporting field.
Sort Order	Enter a number that controls the order of reporting fields on generated reports. Lower numbers appear first in reports.
Detail Description	Enter a detailed description of the reporting field. This is informational only, and is not typically used in inquiries and reports.