Use this screen to view detail and summary general ledger information without printing. This screen contains information from summary balance tables for the account and organization, and allows you to drill down to obtain additional detail information.
The initial screen provides summary information from the general ledger based on any combination of fiscal year, account, or organization. You can select all three to narrow your search or any combination thereof. Within the table window, the columns displaying the fiscal year, account, and organization will display or will be hidden, depending on the selection criteria that you choose. Enter or use Lookup to specify the selection criteria.
Select the Execute icon to populate the table with the selection criteria. Once there is information in the table window, you can change the data in the table window by changing the fiscal year, account, or organization and tabbing out of the field.
From the initial screen, you can "drill down" to more detailed information on selected rows within the Periods, Transactions, and Labor subtasks.
The G/L Inquiry screen is made up of one block, a table window, and seven subtasks. You can use them in the following manner:
The block contains fields for fiscal year, account, and organization. It also contains a table window displaying beginning balances, summary-level period activity, and the year-to-date balance by selected fiscal year, account, and organization.
The Periods subtask allows you to drill down to display period amounts and hours along with running balances by amounts and hours.
The Postings subtask displays the posting sequence number, the source journal, and the hours and amount posted for the selected fiscal year, period, account, and organization.
The Transaction subtask displays transaction-level detail for the line you have selected.
The first Labor subtask (accessed from the main screen) displays transaction information related to labor linked to the selected fiscal year/account/organization for the line you have selected.
The first Transactions subtask (accessed from Periods subtask) displays transaction-level detail for the selected line.
The second Transactions subtask displays transaction-level detail for the selected line.
The second Labor subtask (accessed from the Periods, then the Postings subtasks) further refines the search by displaying transaction information related to employee and vendor labor for a specific period and posting journal.
Use this screen whenever you need to review general ledger summary or detail information for a given account/organization combination.
Information is available in this screen only after you have posted transactions to the various journals. Information entered but not yet posted is not available in the general ledger.
Enter the fiscal year, account, and organization (or any combination thereof) that you need to research.
Select the Execute icon to access the records you specified.
By highlighting a row in the table window, you can drill down through the Periods, Transaction, Labor or Posting subtasks to retrieve more detailed information regarding posted transactions.
|
|
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. |
If you want to narrow the rows shown in the table window to transactions posted in a specific fiscal year, select that fiscal year, or use Lookup, before executing the inquiry.
If you do not select a fiscal year, all fiscal years that have general ledger activity will display.
If you want to limit the rows shown in the table window to transactions posted to a specific account, enter that account number, or use Lookup, before executing the inquiry. If you do not select an account, all accounts with general ledger activity will display.
The account name displays in the unnamed field to the right.
If you want to limit the rows that will display in the table window to transactions posted to a specific organization, enter that organization number in this field, or use Lookup, before executing the inquiry. If you do not select an organization, all organizations with general ledger activity will display.
The organization name displays in the unnamed field to the right.
The total YTD balance for rows in the table window displays here.
This table window displays summary level period amounts, as well as year-to-date account balances.
The source for this table window is FS_SUM. Columns in the table window will display based on selection criteria.
Detailed information is available at the posting detail and the transaction detail level.
To inquire at a more detailed level, highlight the line for which you want additional information. Select the appropriate subtask link to expand the inquiry accordingly.
|
|
Note that all subtask information is related to a specific fiscal year, account, and organization from the table window. |
This non-editable field displays the fiscal year in which selected transactions were posted to the general ledger.
This field will be hidden if the value in the Fiscal Year field was part of the selection criteria.
This non-editable field displays the account to which selected transactions were posted to the general ledger.
This field will be hidden if the value in the Account field was part of the selection criteria.
This non-editable field displays the account name.
It will be hidden if the value in the Account field was part of the selection criteria.
This non-editable field displays the organization to which you posted selected transactions to the general ledger. This field will be hidden if the value in the Organization field was part of the selection criteria.
This non-editable field displays the organization name. This field will be hidden if the value in the Organization field was part of the selection criteria.
This non-editable field displays the year-to-date balance for the selected fiscal year/account/organization.
The amount in the YTD (Year To Date) Balance field is the sum of the values in the Beginning Balance and the Pd Activity Amount fields.
This balance is stated in terms of your company's functional currency.
This non-editable field displays the beginning balance for the selected fiscal year/account/organization.
The value in the Beginning Balance field is updated each time you run the Update G/L Beginning Balances process by closing the labor and non-labor expense and the income accounts into stockholder's equity and rolling that balance along with the asset and liability balances into the next fiscal year.
These non-editable fields display the summary-level general ledger activity amount for each period.
They are stated in terms of your company's functional currency.
Periods
Use this subtask link to go to the Periods subtask for the selected account and organization. From there you can "drill down" into posting, transaction, and labor information.
Transactions
Select this subtask link to go to the Transactions subtask for the selected account and organization for the selected fiscal year.
Labor
Select this subtask link to open the Labor subtask for the selected account and organization.
If labor suppression is turned on for the user in the System Administration module, the labor subtask will be available but no data will display within the subtask.
This screen accesses data stored in the FS_SUM (Financial Statement Summary), GL_POST_SUM (GL Posting Summary), and GL_DETL (GL Detail) tables.
