Field Descriptions

Table Information

 

General Ledger Posting Summary Report

What can I do in this screen?

Use this screen to print posting summaries for selected account/organizations.

This report prints individual journal postings by journal and sequence number for the selected period. Information printed includes the journal code (A/P, C/R, P/R, etc.) posting sequence and period that the journal was posted.

When should I use this screen?

Run this report whenever you need to review the posting detail that supports the balance of a given account/org combination.

Note: You can apply org security to this function. Use this optional feature to grant or remove rights for individual users to view and/or update specific organizations.

In order to do so, you must first set up the necessary org security screens in the Maintain menu of the Administration domain. You can then activate org security through the use of the Users and System Settings screens.

For more information about org security and how to apply it, see the documentation for the Organizational Security menu in the Administration domain.

Field Descriptions

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID.  A parameter ID represents a set of screen selection parameters.  Once you have saved a parameter ID and its related parameters, you can retrieve them using Query.  

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency.  Many users save a unique set of parameters for each different way they run a report or process.  If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults.  You can change any of the associated selection defaults as necessary.

Parameter ID *

Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters.  You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”  

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections.  Once the default selections display in the screen, you can override the defaults as necessary.

Description *

Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Use the fields in this block to specify the range for which you wish to print posting summaries.

Accounts *

Option

Enter, or use the drop-down box to select, the range of accounts that you want to include on the report. The system-defined options are "All," "One," "Range," "From Beginning," and "To End."

Start

Enter the starting account for the accounts you want to include on the report. The value you enter in this field varies, depending on the Option you select.

If you select "All" accounts, this field will be inactive.

If you select "One" account, enter that account in this field.

If you have elected to print a "Range" of accounts, enter the starting account for the desired range in this field.

You can use Lookup to select values from the appropriate table.

End

Enter the ending account for the accounts you want to include on the report.

The value to be entered in this field varies, depending on the Option you select. If you select "All" accounts, this field will be inactive.

If you elect to print a "Range" of accounts, enter the ending account for the desired range in this field.

If you select "To End," enter the beginning account for the desired range in this field.

If you elect to print a range up to an ending value ("From Beginning"), enter the ending account in this field.

You can use Lookup to select values from the appropriate table.

Page Break

Select this checkbox to insert a page break after each account.

Organizations *

Option

Enter or select the range of organizations to be included on the G/L Posting Summary.  The system-defined options "All," "One," "Range," "From Beginning," and "To End."  

Start

Enter the starting organization for the organization(s) you want to include on the report. The value you enter in this field varies, depending on the Option you select.

If you select "All" organizations, this field will be inactive.

If you select "One" organization, enter that organization in this field.

If you have elected to print a "Range" of organizations, enter the starting organization for the desired range in this field.

You can use Lookup to select values from the appropriate table.

End

Enter the ending organization for the organization(s) you want to include on the report. The value you enter in this field varies, depending on the Option you select.

If you select "All" organizations, this field will be inactive.

If you elect to print a "Range" of organizations, enter the ending organization for the desired range in this field.

If you select "To End," enter the beginning organization for the desired range in this field.

If you elect to print a range up to an ending value ("From Beginning"), enter the ending organization in this field.

You can use Lookup to select values from the appropriate table.

Page Break

Select this checkbox to insert a page break after each organization.

Accounting Period

Option

This non-editable field displays a value of "One."

Fiscal Year *

Enter, or use Lookup to select, the fiscal year for which you want to print the report.

Period *

Enter, or use Lookup to select, the fiscal period for which you want to print the report.

End Date

The ending date of the period that you have selected displays in this non-editable field.

Sort By

Use this block to determine how you will sort the report.

1st Sort *

Use the drop-down box to sort this report either by "Organization" or by "Account."

Options

Use the checkboxes in this block to tailor the appearance of your report.

Print

Note: You must select at least one of the checkboxes in this group box.  You can select both checkboxes if you want to print both types of reports.

Current Period Summary

Select this checkbox to print current period posting summaries.

Year-To-Date Summary

Select this checkbox to print year-to-date posting summaries as of the ending period you selected.

Show

Account/Org Names

Select this checkbox to print account and organization names on the General Ledger Posting Summary Report.  

If you leave the checkbox unchecked, only the account and organization IDs will print.

Inactive Accounts

Select this checkbox to print inactive accounts on the General Ledger Posting Summary Report.

Unselect this checkbox to prevent inactive accounts from printing on the General Ledger Posting Summary Report.

This checkbox is selected by default.

* A red asterisk denotes a required field.

Table Information

The information on this report is stored in the G/L Posting Summary table.

Top of Page