The Consolidated General Ledger report displays posted general ledger transactions for a specified fiscal period range or date range for selected Consolidated EntitiesCompanies.

Note

It is expected that the EntitiesCompanies that make up the Consolidated EntityCompany use the same calendar. If they use different calendars, then when running the report, use the Date options, not the Period options on the parameter page.

The report is available as a Detail or Summary report, where the Summary format prints payment transactions in summary format only. If the check box for Print EntityCompany Percentages page is checked, the report prints a page after each Consolidated EntityCompany that shows a list of EntitiesCompanies and their percentages.

This report prints a Beginning Balance amount for all EntitiesCompaniesbased on the same account number within that Consolidated EntityCompany.

The transactions are ordered by EntityCompany ID within the same base account number. The transaction amounts are displayed as percentages of the original transaction amounts based on the detail consolidated percentages.

Period totals, provided for each account, include debit, credit, and ending balance totals. If the period totals do not reflect an entire period, due to the selected report range, the words “partial period“ appear next to the Period Totals heading.

Report Totals are based on account number transactions by Period and Account. The report also totals by Consolidated EntityCompany. If the Consolidated Percentage for an EntityCompany is not 100%, rounding may cause totaling differences. If a transaction is unapproved, an asterisk (*) appears next to the account description.

1. From the eFinancials menu, select Reports—GL Reports—Consolidated General Ledger. Or, from the ePO menu, select Reports—Consolidated General Ledger.
2. Click Select EntitiesCompanies. Select the entitiescompanies for which you want to print the report and click Save.
3. Select the From and Thru Prd/Fiscal Year option button and enter a period and fiscal year range for the report. Or, select the From Date option button and enter a date range for the report.
4. From the Account From and Account To fields, click the Lookup icon to display the Select GL Account Tab and select a range of general ledger account numbers for the report.

Note

If the From / To Account Fields are left blank, the report includes all accounts for all selected entitiescompanies.

5. Select the Include Unapproved Transactions check box to include unapproved transactions on the report. If the check box is not checked, only approved transactions will be on the report.
6. To print a summary report, select the Summary Format check box. If the check box is not selected, a detail report prints.
7. To print a page after each Consolidated EntityCompany that shows a list of EntitiesCompanies and their percentages, check the Print EntityCompany Percentages page check box. If the check box is not checked, the additional page will not print.
8. Select one of the following report printing options:
• PDF Format: Print the report in PDF format for use in a PDF viewer, such as Acrobat.
• Create Spreadsheet: Prints the report in an Excel spreadsheet.
9. Click Print. If you selected Create Spreadsheet, you are prompted to open or save the report Excel file. Otherwise, the report opens in PDF format.

 

Copyright © 2018 Infor. All rights reserved. www.infor.com