General Ledger Correspondence
The general ledger correspondence feature enables you to:
Create a correspondence transaction periodically.
Post correspondence operations when you post general ledger transactions.
Analyze a number of reports for correspondence.
Creating a General Ledger Correspondence Entry
The following procedure shows how to periodically create general ledger correspondence entries.
In Financial Management, click General Ledger, click Correspondence, and then click Create General Ledger Correspondence.
Enter the Transaction No. field with the transaction number if general ledger correspondence is to be created only for the selected transaction. Otherwise, leave it blank.
To set up automatic general ledger correspondence
- In Financial Management, click Setup, click General Ledger Setup, and select the Automatic G/L Correspondence field.
Reports
The following reports have been added for the analysis of data from correspondence transactions:
General Ledger Correspondence General Ledger (form ID 12403; report ID 12431)
General Ledger Correspondence Analysis (form ID 12401)
General Ledger Correspondence Journal Order (report ID 12432)
General Ledger Correspondence Cross-Reference (report ID 12433)
General Ledger Correspondence Cross-Reference (A) (report ID 12434)
General Ledger Correspondence Entries Analysis (report ID 12435)
General Ledger Correspondence General Ledger Form
The General Ledger Correspondence General Ledger form shows turnovers in the chosen period in correspondence.
To access the General Ledger Correspondence General Ledger form
- In Financial Management, click General Ledger, click Correspondence, and then click General Ledger.
The header contains the following filters:
Date
Business unit
Global Dimension 1 Filter
Global Dimension 2 Filter
If you select a turnover in the left subform, the report shows the turnover in correspondence with other accounts in the right subform.
To print the form
- Click General Ledger from Print. On the G/L Account tab of the request form, the filter is set by default from the active line in the G/L Correspondence General Ledger form.
On the Options tab, you can set parameters by filling in the fields with the information listed in the following table.
Field | Description |
---|---|
Period Beginning |
Enter the starting month and year of the period, for the entries that you want to include in the report. |
Ending of period |
Enter the ending month and year of the period, for the entries that you want to include in the report. |
Without Double Entries |
Select this check box to print the report without double entries. |
Without Account Title Type |
Select this check box to print the report without account titles. |
Without Levels of Enclosure |
Select this check box to print the report without levels of enclosure. |
Interim Total |
Select this check box to print the report with interim totals. |
General Ledger Correspondence Analysis Report
The General Ledger Correspondence Analysis report shows turnover in the selected period in correspondence.
To access the report
- In Financial Management, click General Ledger, click Correspondence, and then click General Ledger Correspondence.
The header contains the following filters:
Date
Closing
Department
Project
The report shows turnover in correspondence for all accounts.
General Ledger Correspondence Journal Order Report
This report shows the debit and credit turnovers and balance on each general ledger account.
To access the report
- In Financial Management, click General Ledger, click Reports, click Correspondence, and then click Journal Order.
You can set a general ledger account filter on the G/L Account tab of the request form. The Options tab contains the same fields as the General Ledger Correspondence General Ledger report.
General Ledger Correspondence Cross-Reference Report
The General Ledger Correspondence Cross-Reference report shows all correspondence amounts.
To access the report
- In Financial Management, click General Ledger, Click Reports, click Correspondence, and then click Cross Reference.
On the Options tab of the request form, you can set parameters by filling in the fields with the information listed in the following table.
Field | Description |
---|---|
Starting Date |
Enter the starting date of the period, for the entries that you want to include in the report. |
Ending Date |
Enter the ending date of the period, for the entries that you want to include in the report. |
General Ledger Correspondence Reference (A) Report
The General Ledger Correspondence Reference report shows all correspondence amounts.
To access the report
- In Financial Management, click General Ledger, click Reports, click Correspondence, and then click Cross Reference (A). The Options tab of the request form contains the same fields as the General Ledger Cross-Reference report.
General Ledger Correspondence Entries Analysis Report
The General Ledger Correspondence Entries Analysis report shows the correspondence entries for each account. The report can be used to get an overview of general ledger account entries with correspondence and totals.
To access the report
- In Financial Management, click General Ledger, click Reports, click Correspondence, and then click Entries Analysis.
On the Options tab of the request form, you can set parameters by filling in the fields with the information listed in the following table.
Field | Description |
---|---|
Starting Date |
Enter the starting date of the period, for the entries that you want to include in the report. |
Ending Date |
Enter the ending date of the period, for the entries that you want to include in the report. |
Other parameters Without Zero Net Changes Without Zero Lines Debit Credit Separately New Page for GL Acc |
Specify the view of the report, such as whether the information for each account should be written without zero lines or net changes. |