To run the Recurring Journal Entry Proofing Report: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 screen 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 screen.
In the Br/Tr/All field, enter the branch or territory for which you want to run the report. Enter All to run the report for all branches and territories.
In the Branch Detail field, when printing the report for more than one branch, indicate whether to break out the G/L account data by branch. Y is the default.
In the Recurring ID field, do one of the following:
To select the postings for all recurring journal entry template IDs, press Enter to select All. This is the default.
To select one recurring template ID, press the Spacebar to delete All, press F10 and select from a list of recurring IDs, and then press Enter.
To select more than one recurring template ID, use the Recurring IDs hot key. When you select multiple recurring template IDs, *Multi* display 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, press Enter to leave this field blank. This is the default.
To select one G/L account, press F10, select a G/L account, and press Enter.
To select more than one G/L account, use the G/L Accounts hot key. When you select multiple G/L accounts, *Multi* 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, then 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, press F10 and select one of the following to determine how to sort the report:
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 Expired field, press F10 and 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 field, press F10 and select from 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: