The report header displays the account and the reporting period. The report columns display:

• The current EntityCompany.
• The current account.
• GL account cash balance

Make the following menu selections to display this tab:

eFinancials—Setup—Reports—Report Formats

Complete the following procedure to create a new cash balance report format for use in the Format field on the Cash Balance Report tab:

1. From the Setup Report Formats tab, click Add Format.
2. On the General tab, from the Format ID field, enter a format ID (example: CashBal).
3. From the Description field, enter a description for the new report (example: Cash Balance Format).
4. The sequence number of the section in the sequence of report segments. You can also think of this number as identifying the detail line.
5. In the Sequence # field, notice the detail sequence number for the section. The Cash Balance Report requires a report format with at least one detail sequence. To change the default number, type the Sequence # you want to use for this section, and select a section Type.

Note

The Cash Balance Report reports only on accounts for which the Cash Flow Code is "Cash" (as set up on the Account Maintenance Tab). You do not need to set up a detail sequence for any other accounts, because they are not included in the report.

6. From the From Account and Through Account fields, type the from and thru accounts that will include cash accounts from any EntityCompany. Do not include Totaling or Heading accounts.
7. Click Save.

Note

A default format, BalSht, is provided for this report. For a customized report, you must have set up custom report formats.

1. From the eFinancials menu, select Reports—GL Reports—Cash Balance Report.
2. Click Select EntitiesCompanies. Select the EntitiesCompanies for which you want to print the report and click Save.
3. From the Fiscal Year field, type the year for the report (for example, 2008).
4. From the Period field, type the period for the report (for example, 2).
5. From the Report Format drop-down list, select a format.
6. If you want the report to include unapproved transactions, select the Include Unapproved Transactions check box.
7. 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.
8. 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.