Summary

The Journal Entries option on the Display palette is used to view a filtered list of journal entries. Once you have created a list of journal entries, you can export them to an MS Excel spreadsheet using the export feature that is available on all windows that display information in a grid.

Use the Journal Entries process (GL> Journal Entries) if you would like to create a journal entry.

Step by Step

1     Open the Journal Entry Selection window (GL> Display> Journal Entries).

2     Filter the displayed journal entries.

• Enter information into the fields in the Search Criteria section and then press ENTER or click the Refresh icon   to update the records that display in the window.
• The System drop-down menu is used to filter the journal entries that display in the window by the module that was used to create them.
• The Process drop-down menu is used to filter the journal entries that display in the window by the process within the module selected above.
• The Status drop-down menu is used to filter the journal entries that display in the window by the commit status of the journal entry.
• The Batch field is used to filter the journal entries that display in the window by the Journal Entry batch used to create them. Click the Batch field label to select a batch from a list.
• The Fiscal Year and Fiscal Period fields are used to filter the journal entries that display in the window by the fiscal period and fiscal year.
• The Journal Entry field is used to filter the journal entries that display in the window by journal entry number. Journal entries are assigned a sequential number that resets at the beginning of each fiscal period.
• Click the Refresh icon to update the journal entries that display in the window.
• Right click on the records in the window and select Export grid contents to Excel if you would like to export the information that displays in the window to an MS Excel spreadsheet.
• Highlight a journal entry and click the Display icon or press ENTER if you would like to view the journal entry line items. This will open a new window. Use the Up and Down icons to highlight a journal entry line item and press ENTER again if you would like to view the detail information associated with the selected line item.