This
For more information, see The Report Properties Dialog.
Overview
Because this report concerns the service bureau’s general ledger, it has been designed to be run primarily at the system level. However, you can run the SB Ledger Activity report at the:
- System level for:
- All companies
- A company set
- Company level for:
- All companies
- A company set
- That specific company
The reports lists entries made to each ledger account for the dates you specify.
The default setting groups entries by GL1. However, you can use the Subtotals/Breaks tab of the Report Properties dialog to modify the grouping using several other fields, including:
- Company
- Bank account
- Ledger post date
- Check date
The information shown on columns one through five of the report can be edited by changing the default options on the Additional Formulas tab of the Report Properties dialog (see Additional Formulas).
Date Selection
In the Report Properties dialog, click on the Date Selection tab. The system displays the Date Selection page.
As explained in Date Selection, you can use Override Dates 
to select specific check date/process number combinations. Most Millennium® reports are based on a date or a process number.
This report is based on the ledger date.
This report uses service bureau-style default date ranges, which are:
- Today [default value]
- Yesterday
- This Week
- Last Week
- Override Dates
- Current Month
- Previous Month
- Current Quarter
- Previous Quarter
Data Selection
In the Report Properties dialog, click on the Data Selection tab. The system displays the Data Selection page.
As explained in Data Selection, you can use this page to include company filters to narrow down the selected data for this report. If you want to create a filter, design it to access the following database tables:
- CInfo
- SSbEntries
Subtotals/Breaks
In the Report Properties dialog, click on the Subtotals/Breaks tab. The system displays the Subtotals/Breaks page:
Figure 2-489: Subtotals/Breaks page
The default Sort Order is AccountDate. Available sorts include:
- Account Date
- Date
This report allows eight categories in the Groups column. If you select Custom Sort Order 
, the groups in Available Groups are available:
|
Company |
Cleared Date |
Ledger Post Date |
|
Fed EIN |
Debit/Credit |
Voided |
|
Service Bureau |
GL1 |
Check Date |
|
Bank Account |
GL2 |
Process |
|
Check Number |
GL3 |
Payroll |
|
Cleared |
Full GL |
|
This report allows four categories in the Sorts column. If you select Custom Sort Order , the sorts in Available Sorts are available:
|
Company |
Bank Account |
GL3 |
|
Fed EIN |
Check Number |
Full GL Code |
|
Service Bureau |
Cleared |
Voided |
|
Company Name |
Cleared Date |
Check Date |
|
Ledger Date |
GL1 |
Process |
|
Amount |
GL2 |
Payroll |
Additional Formulas
In the Report Properties dialog, click on the Additional Formulas tab. The system displays the Additional Formulas page:
Figure 2-490: Additional Formulas page
For more information about using additional formulas, see Additional Formulas. Each additional formula for this report is explained below:
Ledger Info 1–5
Use these drop-down lists to specify which piece of ledger detail information is displayed in the corresponding column of the report.
The valid entries are shown in Available formula values for Ledger Info entries:
|
Fed EIN |
Cleared |
Full GL Code |
|
Service Bureau |
Cleared Date |
Voided |
|
Company |
GL1 |
Check Date |
|
Bank Account |
GL2 |
Process |
|
Check Number |
GL3 |
Payroll |
Include No Co
If you put a check in this check box, the report includes records that do not have a company code.
GL1–GL3
Use these drop-down lists to specify a corresponding value.
Valid entries for GL1 are 1 through 8.
Valid entries for GL2 are 1 through 9.
Enter the appropriate text for GL3.
GL Amount Threshold
Enter a number that represents the threshold amount for credit or debit.