This chapter provides an overview of the resources to review Oracle's PeopleSoft General Ledger financial information and discusses how to:
View journal information.
View ledger information.
Inquire about ledger groups.
Compare data by ledger periods.
Compare across ledgers.
Review imported accounting entries.
Review entry event accounting.
Review subsystem reconciliation data.
Note. This chapter does not include Commitment Control inquiries.
See Also
Understanding PeopleSoft Commitment Control
PeopleSoft General Ledger provides a series of inquiries that enable you to review ledger summary and detail ledger information based on selected ChartField combinations. These inquiries use several successive views that take you down to journal line details. The ledger inquiry also enables you to drill down across products from account balances in General Ledger to specific transaction entries in other PeopleSoft Financials and Distribution products.
These terms are used in this chapter:
View a regular balance when you inquire on the balance of a ledger and you do not include any adjustment entries, balance forward entries, or closing entries. This balance only includes transactions posted during the specified period. |
|
View a cumulative ledger balance when you inquire on the balance of a ledger by including balance forward entries, adjustment entries and closing entries. Each balance is added to the next balance to provide a cumulative ledger balance. |
|
The transaction amount converted to the base currency indicated for the transactions business unit. |
|
The total ledger amount expressed in the base currency. |
|
The amount of the transaction entered in a currency that is different from the base currency or is the same currency as the base currency. |
|
Amounts in the transaction currency for all ledger balances including those in the base currency. |
|
Total amount of the transactions in the transaction currency for all ledger balances except those in the base currency. |
Note. Many of the following inquiry pages operate in deferred processing mode. Most fields are not updated or validated until you save the page or refresh it by clicking a button, link, or tab. This delayed processing has various implications for the field values on the page—for example, if a field contains a default value, any value you enter before the system updates the page overrides the default. Another implication is that the system updates quantity balances or totals only when you save or otherwise refresh the page.
See Also
Integrating and Transferring Information Among Applications
Editing ChartField Combinations
Convert Accounting Entries to PeopleSoft Journals
These inquiries are accessible in General Ledger:
Journal Inquiry
Enables you to review a specific journal or multiple journals within a ledger for a business unit and accounting period. You can use a document sequence number as part of your search criteria to review journal data.
Ledger Inquiry
Select a ledger to view based on selected ChartField values, including book codes, or ChartField value sets, which consist of a predefined set of selection criteria for a given ChartField. A ChartField value set can be obtained from a tree, a series of detail ChartField ranges, or a series of detail ChartField values. There are also various methods for displaying both summary and detail ledger information.
Ledger Group Inquiry
Review all the journals within a ledger group along with their journal line details. Compare the posted transaction amount, posted base amount, or posted total amount balances between ledger periods.
Ledger Comparisons
Compare one ledger by periods or compare one ledger with another within one or more ledger periods. Customize your comparison by selecting specific ChartFields or ChartField value sets. You can display comparisons for all thirteen periods or for selected periods, with or without adjustments.
Analytic Charts
Display analytic bar charts of the comparison across ledgers amounts.
Imported Accounting Entries Inquiries
Import PeopleSoft Payroll, Student Financial, Enterprise Learning Management, Contributor Relations and Global Consolidations transactions, as well as generic accounting line data into General Ledger and review this imported data before and after you run Journal Generator.
Entry Event Budget and GL Adjustment Accounting Inquiries
Drill down to the accounting line detail for Budget and GL adjustment transactions that use entry events.
Subsystem Reconciliation Inquiry
Drill back to the Payables and Receivables subsystems and review vital status fields for documents that have not been processed and posted to the general ledger.
This section discusses how to:
Enter journal criteria.
View journal header details.
Page Name |
Definition Name |
Navigation |
Usage |
INQ_JRNL_CRITERIA |
General Ledger, Review Financial Information, Journals, Journal Inquiry |
Review summary and detail journal information for a specific business unit, ledger, and period. |
|
INQ_JRNL_HDR_DTL |
After displaying the journal IDs on the Journal Inquiry page, click a Journal ID link. |
Displays the journal header, currency, and line information for the journal ID selected. |
Access the Journal Inquiry page (General Ledger, Review Financial Information, Journals, Journal Inquiry).
Enter required criteria and any additional criteria on the Journal Inquiry page and click the Search button to display Journal IDs based on your selections.
Document Sequence |
Enter a document sequence number to review journals that are tracked by document sequencing number. |
Journal ID |
Click a Journal ID link to review the journal header and line detail information. |
Note. You can use the Customize link to hide or display specific journal column data.
Access the Journal Inquiry - Journal Inquiry Details page (Click a Journal ID link from the journal results on the Journal Inquiry page).
All Lines or From/To and enter values for From Line and To Line |
Display all the journal lines for this journal, or enter a range of line numbers and click the Query Journal Lines button. |
See Also
Making General Ledger Journal Entries
This section discusses how to:
Specify ledger criteria to review summary and detail information.
View ledger summary balances.
View ledger transaction details.
View detail journal header and journal lines.
Drill down to the subsystem accounting entries.
View the ledger details.
Page Name |
Definition Name |
Navigation |
Usage |
INQUIRY_CRITERIA |
General Ledger, Review Financial Information, Ledger, Ledger Inquiry |
Specify selection criteria to view Ledger detail and summary information. |
|
INQ_SUM_BAL |
Click the Search button on the Ledger Inquiry page. |
Displays the summary balances based on selected criteria. |
|
INQ_TRANS_DETAIL |
Click the Activity link on the Ledger Inquiry - Ledger Summary page to access this page. |
Displays the summary of the ledger's journal data for your selection. For example, it displays summary of all the ledger's journal amounts for a specific account ChartField value. |
|
INQ_JRNL_HDR_DTL |
Click the Journal ID value link for one of the transactions on the Transactions Details page. |
Displays the journal transaction's header information and journal lines. |
|
XX_GL_DRILL |
|
Displays an intermediate page with links to the subsystem journal accounting entries (the XX in the object name represents the code for the particular General Ledger feeder system). |
|
XX_ACTG_ENTRIES |
|
Displays the subsystem journal accounting entries. The XX in the Accounting Entry page object name represents the code for the particular General Ledger feeder system. |
|
INQ_DETAIL_LEDGER |
Click the Detail link on the Ledger Inquiry - Ledger Summary page. |
Displays the ledger details for a selected period. Click the Activity link on this page to return to the Ledger Inquiry - Transaction Details page and drill down to the subsystem level of detail. |
Access the Ledger Inquiry page (General Ledger, Review Financial Information, Ledger, Ledger Inquiry).
Specify the ChartFields to view the summary by and also the order of the ChartFields to be viewed by the sequence that you select the Sum By check box. For example, if you click the Sum By check box for Account, and then Department, theAccountChartField has Order-By equal to 1, while Department has Order-By equal to 2. You can also specify adjustment periods to be included as part of the criteria by selecting the check box next to the Adjustment Periods.
Ledger Criteria
Enter or select at a minimum the required fields to establish ledger inquiry criteria. Select additional options to further refine your inquiry.
Unit |
Select the business unit for which you want to return ledger data. |
Ledger |
Commitment control and summary ledgers are not available for ledger inquiry. |
Show YTD Balance (show year-to-date balance) |
Select this check box and the inquiry returns year-to-date balances for specified ChartFields for a period. For example, results are summed in order by account for the periods which appears in the numerical order of the account. Do not select this check box and the inquiry returns individual balances for period and account that are displayed in order by period. This field is not available if the selected Ledger in the ledger criteria uses the Average Daily Balance ledger template. |
Show Transaction Details |
Select to see the ledger data along with the journal transactions that contributed to the balance. For example, if you select this check box and select all ChartFields in the Sum By check boxes, the inquiry returns a list of all journals that contribute to the ledger lines. |
Include Closing Adjustments |
Select this option to include closing balances (period 999) along with the current open period amounts. |
Only in Base Currency |
Select this option if you want the inquiry amounts to appear only in the base currency indicated for the selected business unit. |
Max Ledger Rows (maximum ledger rows) |
You can override the default of 100 with any number <=300 rows of data that you can display in a scroll area. Less than 300 usually contributes to better performance. |
Search |
Click to display either the Ledger Summary page or Transaction Detail page, when the Show Transaction Details check box is selected. |
Clear |
Select to clear the ledger and ChartField criteria from the page to enter different criteria. |
Delete |
Deletes the inquiry, cancels the page, and returns you to a blank Ledger Inquiry - Ledger Inquiry Criteria page. |
ChartField Criteria
You can select one or more ChartField values or one or more ChartField value sets leave the fields blank and place a check mark next to each row to review all ChartField information based on the selected criteria.
ChartField |
Select a ChartField value for one or more ChartFields to review specific data in a ledger. |
ChartField Value Set |
Select a predefined set of selection criteria for a given ChartField. |
Update/New |
Click this link to update an existing ChartField value set or create a new ChartField value set. |
Sum By |
You are required to select at least one ChartField to sum by and if you do not, you receive an error message when you click the Search button. Period is always included in the sum by and is always the first column in the inquiry results. The order in which the ChartFields appear on the inquiry results is determined by the order in which you select the Sum By check boxes for the ChartFields. If you select all ChartFields available in the ChartField Criteria for Sum By and the Show Transaction Details check box is not checked, the result is a display of each row in the ledger that meets your criteria for business unit, ledger, fiscal year, accounting period, currency, and statistics code. |
Value Required |
Select this check box to filter out ChartFields with blank values. This check box is available only when the Sum By check box is selected. It is also unavailable for selection but is automatically selected by the system if the ChartField Account has Sum By selected. |
Order By |
Determine the sort order of the ChartFields in the result page by the order in which you select Sum By for each ChartField. |
Include Adjustment Periods
Sel (select) |
Select specific adjustment periods by selecting its check box from the list of adjustment periods that are available based on the selected Ledger and Fiscal Year. Only adjustment periods that are applicable to the fiscal year are available. |
Period |
Adjustment periods are displayed based on those available for the selected ledger and fiscal year. For example, depending on the periods set up for the fiscal year, there might be 901 through 912 or if set up, 913. You can also use the common adjustment period 998. |
See Also
Defining and Using ChartField Value Sets
Access the Ledger Summary page (click the Search button on the Ledger Inquiry page).
From the Ledger Inquiry page, when clicking the Search button, you are directed to the Ledger Summary page. If you had selected the Show Transaction Details check box from the Ledger Inquiry page, you are directed to the Ledger Details page.
Ledger Detail Drill - Down Chartfield Display |
Click this link to configure the ChartFields that you intend to display for Ledger Detail, which can be accessed by clicking the Detail link on the Ledger Summary page. |
Ledger Amount by Currency |
Displays, based on type of currency, a summary of the transaction balances for each account in the ledger within the selected ledger period range. |
Activity |
Click this link to view transaction details on the Ledger Inquiry - Transaction Details page. |
Detail |
Click the link to view ledger details on the Ledger Inquiry - Ledger Details page. |
Access the Ledger Inquiry - Transaction Details page (Click the Activity link on the Ledger Inquiry - Ledger Summary page to access this page).
If the Show Transaction Details check box on the Ledger Inquiry page is selected, when you click the Search button, the Transaction Details page is displayed. Under this criteria, you see journal transactions for all ledger balances that match the criteria.
In the example on the page that is pictured, the Department ChartField value, 21100, was selected as the search criteria on the Ledger Inquiry page.
Journal ID |
Click this link to access the Journal Inquiry - Journal Inquiry Details page. |
Access the Journal Inquiry - Journal Inquiry Details page (Click the Journal ID value link for one of the transactions on the Transactions Details page).
All Lines |
Select this option and click the Query Journal Lines button to see all journal lines. |
From/To |
Select this option and then enter a line number in the From Line and in the Two Line fields to display a range of journals and with their information when you click the Query Journal Lines button. |
|
Click the drill to source button to access the source of journal lines in the general ledger feeder systems, such as PeopleSoft Receivables. This icon is not available on the page if there is no feeder system source, for example when an adjusting general ledger journal is created in General Ledger to record a miscellaneous adjustment to receivables or payables. |
Access the Drill to Source page (Click the Drill to Source icon on the Journal Inquiry Details page).
The Drill to Source page is an intermediate page that provides detail about the entry with links to drill further to the accounting lines. Some PeopleSoft applications provide a separate intermediate drill down page, such as the AR_ITEM_DRILL_PNL provided by PeopleSoft Receivables. In this case, there are several related links for the purpose of drilling to the underlying data.
GL Journal (general ledger journal) |
Click this link to access the Journal Lines page (JOURNAL_LN_FS) that contains all of the journal lines that comprise the journal. You can click on each Journal Line number on this page to access the details on the journal line. Select the Journal Header tab to view the journal header information. |
Details |
The Details group box of the Drill to Source page varies depending upon the source of the entry. Use the links to drill further to the voucher or invoice information, for example. |
Access the Accounting Entries page (Click the document links from the Details group box of the Drill to Source page or any other intermediate page).
This page name varies depending upon the subsystem. It can be Voucher Accounting Entries or Activity Accounting Entries, for example.
Access the Ledger Inquiry - Ledger Details page (click the Detail link on the Ledger Inquiry - Ledger Summary page).
Activity |
Click this link to return to Ledger Inquiry - Transaction Details page. There you can again view each of the pages listed above until you reach the subsystem entry source document. |
This section discusses how to:
Review ledger group information.
View journal lines.
Page Name |
Definition Name |
Navigation |
Usage |
INQ_JRNL_HEADER |
General Ledger, Review Financial Information, Ledger Group, Journals |
Inquire on the journals contained within the ledgers of a particular ledger group. |
|
INQ_JRNL_LINE |
Select to show all lines or a range of lines and click the Drill to Journal Line button on the Journals page. |
Displays the journal lines of each journal in the ledger group. |
Access the Journals page (General Ledger, Review Financial Information, Ledger Group, Journals).
Enter the criteria to access one or more journals in a selected ledger group.
Search |
Click this button to display the journal header detail for each journal contained within the ledger group after entering the search criteria. |
Show All |
Select to show all journal lines associated with this ledger group when you click the Drill to Journal Lines button. |
From Line and Through Line |
Enter the specific journal line numbers that you want to display when you click the Drill to Journal Lines button. |
Currency Details |
If you enabled the Separate DR/CR Amount Fields on the Ledgers for A Unit - Definition page for a detail ledger, the amounts for the currency in the primary ledger display in DR and CR fields, as well as the Net amount of the two. If Separate DR/CR is not enabled, amounts display as a negative for a credit and a positive for a debit. |
Access the Journal Lines Inquiry page (select to show all lines or a range of lines and click the Drill to Journal Line button on the Journals page).
Query Journal Line Again |
If you queried to display a specific number of journal lines to review on this page, you can enter one or more different journal line numbers and select this option to display them along with the journal lines that you displayed with your original query. |
You can select and compare ChartFields of selected ledger entries based on selected accounting periods.
This section discusses how to:
Enter search criteria.
Compare ledger by period.
Page Name |
Definition Name |
Navigation |
Usage |
INQ_LED_CMP_PNL |
General Ledger, Review Financial Information, Ledger Period Comparison, Ledger Period Comparison |
Specify the ledger data you want to compare by period. |
|
INQ_LED_CMP_DTL |
Click Search on the Ledger Period Comparison page. |
Displays a comparison of the selected ledger's detail based on the ChartFields and number of periods selected on the Ledger Period Comparison page. |
Access the Ledger Period Comparison page (General Ledger, Review Financial Information, Ledger Period Comparison, Ledger Selection Criteria - Ledger Period Comparison).
Amount Field |
Select POSTED_TRAN_AMT to display the amounts in the transaction currency for all ledger balances including those in the base currency. Select POSTED_BASE_AMT to display the total of the transaction amounts converted to the base currency of the ledger. Select the POSTED_TOTAL_AMT to display the amounts in the transaction currency for all ledger balances except those in the base currency. |
Include All Periods |
Includes periods for the ledger criteria if selected. Note. When Include All Periods is selected, a maximum of 13 periods can be used. This can include one adjustment period, but no more than one. |
Include Balance Forward |
Includes any balances carried forward from the previous period in the totals. |
Include Closing |
Includes closing adjustments for period 999 in the totals. |
ChartField and Value |
Select the ChartField values that you want to appear on the Ledger Period Comparison - Period Comparison Results page. To limit the number of ChartField values, enter a specific Value for a selected ChartField. You can also use a wildcard (%) to select a range of values. If you do not specify ChartField values, the system determines the values to use based on the selected ledger. The Alternate Account ChartField (AltAcct) appears in the ChartField Criteria group box only if you enabled the alternate account option on the Installation Options - Products page and the Ledgers for a Unit page. |
Period Selection |
Select the periods you want to use for comparison on the Ledger Period Comparison - Period Comparison Results page. To remove a period from the list, click the minus sign button to remove the row. If you want to include an adjustment period, click the plus sign button to add a row. Select the Adj check box and either manually enter an adjustment period or use the prompt to select an adjustment period. Select the adjustment periods you want to display. |
Search |
Click this button to access the Ledger Period Comparison - Period Comparison Results page. |
Access the Ledger Period Comparison - Period Comparison Results page (Click Search after selecting criteria on the Ledger Period Comparison page).
Period Bal Fwd (period balance forward) |
If you selected the Include Balance Forward option, this column appears on the first tab and displays the opening balance for the period in the Ledger Comparison grid. |
Period Close |
If you selected the Include Closing Adjustments option, this column for period 999 appears on the last tab. It displays the adjustment for year end closing in the Ledger Comparison grid. |
ChartField Criteria |
Click to display the list of ChartFields. Deselect or select a ChartField check box and when you click the Refresh button, the Ledger Period Comparison - Period Comparison Results page redisplays ChartFields based on your selections. |
Ledger Compare Criteria |
Click to display the Ledger Criteria as well as ChartField Criteria. You can modify your selections and click Search to display results based on the newly-selected criteria. |
This section discusses how to:
Enter comparison criteria for two ledgers.
Review comparison amounts between the ledgers by period.
Use a bar chart to analyze the ledger comparison data.
Page Name |
Definition Name |
Navigation |
Usage |
INQ_COMPARE_PNL |
General Ledger, Review Financial Information, Compare Across Ledgers, Compare Across Ledgers |
Specify the criteria for the ledgers that you want to compare. |
|
INQ_COMPARE_PNL |
Click Search. |
Displays the ledger comparison data. |
|
INQ_COMPARE_PNL |
Select Amount, select Display Chart on the Compare Across Ledgers Criteria page, and click Search. |
Displays a bar chart of the data. |
Access the Compare Across Ledgers page (General Ledger, Review Financial Information, Compare Across Ledgers, Compare Across Ledgers).
You can select and compare total amounts for selected ChartField criteria between two ledgers.
Ledgers |
Enter the ledgers and the criteria for the two ledgers you want to compare and save the page. The grid appears in which you can select specific ChartFields and criteria that you want to be included in your comparison. |
Percentage/Amount |
Select whether you want the variance between the ledgers to display as an amount or a percentage in the comparison information. If you select Amount, the Display Chart field becomes available. |
Display Chart |
Select to display an analytical chart. If you selected Amount in the previous field, when you click Search, you can scroll down to view a bar chart below the comparison data that shows a comparison between the amounts in Ledger 1 and Ledger 2 along with the variance between the two. |
Search |
Click to display the comparison detail information and then use the scroll bar to scroll down below the selection criteria information to see the results. |
Sum By |
This option is only applicable to ChartFields that are common to both ledgers. |
Value Required |
Select this check box to filter out ChartFields with blank values. |
Order By |
When you select the Sum By check box for a ChartField, it automatically displays a number that determines the order in which the ChartField inquiry results are retrieved and displayed. |
Click Search and scroll down to the comparison information.
Depending how you set up your criteria, the selected ledgers are compared to one another for each ledger period.
Variance |
May appear as an amount or a percentage depending on which field value you select for the Percentage/Amount field. |
Note. This page is also integrated with the CFO Portal.
Access the Compare Ledgers page and scroll down to the chart.
You can inquire about PeopleSoft Payroll, Generic, Student Financial, and Contributor Relations accounting lines that you import into General Ledger.
This section discuss how to inquire on imported accounting entries.
See Also
Integrating and Transferring Information Among Applications
Before you can use any of these inquiry options, you must import the following into General Ledger:
Payroll accounting lines.
ELM accounting lines.
Generic accounting entries.
Student financial accounting entries.
Contributor relations accounting entries.
Note. You use the same method to access the accounting entries for all of these Review Ledger/Journal options.
To access accounting entries that were imported to General Ledger:
Enter the Business Unit, Journal ID, Journal Date, GL Journal Line number, and Ledger.
The Payroll, Generic, ELM, Student Financial, or Contributor Relations accounting journal information appears at the top of the page.
Review the accounting entry data that appears in the lower portion of the page.
There are four pages of data concerning the selected Journal ID:
ChartFields
More ChartFields
Currency Details
Misc.
This section discusses how to:
Drill down to entry event budget accounting details.
Drill down to entry event GL adjustment accounting details.
Page Name |
Definition Name |
Navigation |
Usage |
EE_GLBUD_DRILL |
General Ledger, Review Financial Information, Entry Event Budget Acctg, Entry Event Budget Accounting Entries |
Drill down to budget accounting entry event transaction details. |
|
JOURNAL_HEADER_FS |
Click the GL Journal link and select the Journal header tab. |
Displays Journal Header information for the Entry Event GL Adjustment transaction. |
|
JOURNAL_LN_FS |
Select Journal Lines tab. |
Displays Journal Line detail for the Entry Event GL Adjustment transaction. |
|
EE_GLADJ_DRILL |
General Ledger, Review Financial Information, Entry Event GL Adjust Acctg, Entry Event GL Adjustment Accounting Entries |
Drill down to GL adjustment accounting entry event transaction details. |
Access the Entry Event Budget Accounting Details page (General Ledger, Review Financial Information, Entry Event Budget Acctg, Entry Event Budget Accounting Entries).
Account |
Displays the accounts generated by the Entry Event processor that are posted to the budget. |
GL Journal (go to general ledger journal) |
Click to review the Journal Header and Journal Lines page for this transaction. |
Access the Entry Event GL Adjustment Accounting Entries page (General Ledger, Review Financial Information, Entry Event GL Adjust Acctg, Entry Event GL Adjustment Accounting Entries).
Account |
Displays an entry event accounting line generated by the Entry Event Processor. |
GL Journal (general ledger journal) |
Click this link to access Journal Header and Journal Lines page for this transaction. |
Subsystem Reconciliation is a reporting and inquiry tool that provides insight into the Payables and Receivables subsystems for documents that have not been fully processed. Subsystem Reconciliation reporting allows you to report on individual documents within a subsystem and review vital status fields that may identify why a document has not been fully processed and posted to the general ledger. The inquiry is based upon data that is loaded through a process (GL_RECN) that maintains a status table, which keeps a record of the date and time of last processing by Business Unit, System source, fiscal year, and accounting period.
The load process allows you to load data for selected business units, system sources, fiscal periods and ChartFields. You can also select to increment data from the last process. Allowing this flexibility in the data load process improves performance and reduces redundant output in the reconciliation reports.
See Generating Subsystem Reconciliation Reports.
Page Name |
Definition Name |
Navigation |
Usage |
GLRCN_REQUEST |
General Ledger, General Reports, GL Subsystem Reconciliation, Load Reconciliation Data |
Load data for selected business units, fiscal periods, system sources and ChartFields. |
|
GLRCN_STATUS |
Click the View Recon Data Status link from the Load Reconciliation Data page. |
View reconciliation data load process information: date and time of processing by Business Unit, System source, fiscal year and accounting period. |
|
GLRCN_SS_DEFN |
General Ledger, General Reports, GL Subsystem Reconciliation, Subsystem Document Definition, Subsystem Defn |
Provides the delivered definitions of the source system documents that feed into accounting lines associated with the system definitions. |
|
GLRCN_SS_DEFN2 |
General Ledger, General Reports, GL Subsystem Reconciliation, Subsystem Document Definition, Page Transfers |
Provides the menu and path information that is used by the drill down from the reconciliation inquiry to the subsystem document. |
|
GLRCN_CRIT |
General Ledger, General Reports, GL Subsystem Reconciliation, GL Reconciliation Inquiry, GL Reconciliation |
Provides visibility to both the subsystem accounting lines/General Ledger inquiry, as well as the subsystem documents that have not yet been processed into accounting lines. |
|
GLRCN_INQ_OVW |
Click the Search button on the GL Reconciliation page. |
View and update subsystem data. |
|
GLRCN_SS |
General Ledger, General Reports, GL Subsystem Reconciliation, Subsystem Document |
Select source documents (defined in the Subsystem Document Definition component) to load and display those that have not yet generated accounting lines for general ledger. |
|
RUN_GLRCN_RPTS |
General Ledger, General Reports, GL Subsystem Reconciliation, Reconciliation by System Srce |
Compare GL balances to the subsystem application accounting transaction. |
|
RUN_GLRCN_RPTS |
General Ledger, General Reports, GL Subsystem Reconciliation, Reconciliation by ChartFields |
Compare GL balances to the subsystem application accounting transaction. |
Access the GL Reconciliation - Reconciliation Criteria page (General Ledger, General Reports, GL Subsystem Reconciliation, GL Reconciliation Inquiry, GL Reconciliation).
Once you have completed the subsystem reconciliation definitions setup and you run the data load process (GL_RECN) to populate the reconciliation data, search for the accounting line reconciliation data by GL business unit, ledger group, fiscal year and accounting period range for entries as of a given date.
Provide ChartField criteria for which to retrieve data by specifying ChartField value ranges or by using ChartField Value Sets.
Note. Account values are necessary. If no account values are chosen, then the inquiry will always sum to zero.
Search |
Once you supply the search criteria, click the Search button, which opens the Reconciliation Overview page with your search result details. |
Access the Reconciliation Overview page (click the Search button on the GL Reconciliation page).
Not Distributed amount |
Displays the subsystem accounting line data amount that is not distributed to the general ledger. |
Distributed amount |
Displays the subsystem accounting line data amount that is distributed to general ledger. |
Ledger Amount |
The General Ledger total amount. |
Not Distributed amount |
The General Ledger amount not distributed from subsystem amounts. |
Jrnl Amount Not Posted |
The General Ledger amount not posted from the subsystem amounts. |
Total Acctg Ln/Adjusted GL Amount |
The amount in these fields should be equal. Any difference is specified in the Difference field. |
Access the Subsystem Document page (General Ledger, General Reports, GL Subsystem Reconciliation, Subsystem Document).
Application Business Unit |
Select the Payables or Receivables business unit of the system source. |
System Source |
Select GAR or GAP. GAR represents the PeopleSoft Receivables system source and GAP represents the PeopleSoft Payables system source. |
Accounting Data From/Accounting Date To |
The accounting date range to be used for the data load and inquiry. |
Source Document |
Choose from the source documents defined in the Subsystem Document Definition component. |
Selected |
Specifies whether its source document is to be included in the current inquiry or data load/delete. |
Load Date and Time |
Displays the date and time that the data was last loaded into the inquiry table. |
Fetch |
Click to display the data specified by the Search Criteria. |
Load Data |
Click to refresh specified data. This action deletes and reloads the selected document types. |
Clear |
Click to remove selected data from the inquiry table. |
|
Transfers you to the Subsystem Document Inquiry or entry page. |
See Also
Generating Subsystem Reconciliation Reports