Use the Recurring Journal Entry Proofing Report to create a list of journal entries posted by one or more recurring journal entry templates over a period of time. For each journal entry created by a recurring journal entry template, the report displays the following information:
Recurring ID.
Journal number.
Date of the journal entry.
Line of the journal entry window on which the account is listed.
G/L account, branch, and amount. The amount fields are totaled.
Additionally, the report lists cancelled entries, but totals only the non-cancelled entries. The recurring ID for cancelled entries displays as "XXX."
To run the Recurring Journal Entry Proofing Report:
From the G/L > Recurring Journal Entry menu, select Recurring Journal Entry Proofing Report to display the Recurring Journal Entry Postings window.
In the Branch/Territory field, enter the branch or territory for which you want to run the report. Enter Allto run the report for all branches and territories.
In the Recurring ID field, do one of the following:
To select the postings for all recurring journal entry template IDs, elect All. This is the default.
To select one recurring template ID, delete All and select from the list of recurring IDs.
To select more than one recurring template ID, click the Multiple button When you select multiple recurring template IDs, *Multiple* displays in this field. For more information about creating lists of recurring IDs, see Limiting Recurring IDs for the Recurring Journal Entry Proofing Report.
In the G/L Account field, do one of the following:
To select all the postings for each G/L account that the journal entry affected, leave this field blank. This is the default.
To select one G/L account, select an account from the list.
To select more than one G/L account, click the Multiplebutton. When you select multiple G/L accounts, *Multiple* displays in this field. For more information about how to create lists of G/L accounts, see Filtering GL Accounts for the Recurring Journal Entry Proofing Report.
In the Start Date field, enter the first date of the period to include in the report. This is an optional field.
In the End Date field, enter the last date of the period to include in the report. This is an optional field.
Note: If you do not enter a start or end date, the report runs for all dates. Also, for both the Start Date and the End Date field, you can enter an actual date or a variable date, which the system converts to an actual date based on the As of Date entered when the report runs.
In the Sort by field, select one of the following to determine how to sort the report:
Option | Description |
Recurring ID by Date | Sorts the postings first by recurring ID, then by posting date, then by G/L account. |
Recurring ID by Account | Sorts the postings first by recurring ID, then by G/L account, then by posting date. |
Account by Date | Sorts the postings first by G/L account, then by posting date, then by recurring ID. |
Account by Recurring ID | Sorts the postings first by G/L account, then by recurring ID, then by posting date. |
In the Branch Detail area, indicate whether to break out the G/L account data by branch when printing the report for more than one branch.
In the Expired area, select one of the following to determine which templates to include in the report:
Include - Lists postings from all templates that meet the other selection criteria, including those that are expired.
Exclude - Lists postings from templates that meet the other selection criteria, excluding those that are expired.
Only - Lists postings that meet the other selection criteria and are only from templates that are expired.
In the A/P Recurring area, one of the following to determine whether to include A/P entries in the report:
Include - Lists recurring A/P entries in the report.
Exclude - Does not list recurring A/P entries in the report.
See Also: