Query / Edit Journal Entries
Print
Modified on: Wed, 5 Jan, 2022 at 10:00 AM
What This Process Does
- This process makes it possible to locate specific journal entry masters in order to delete them, make changes to them or simply view them.
Best Practices
- Audit Trail - It is always best to review your audit trail carefully before setting flags, so that changes to journal entries are not necessary.
Requirements
- Verification - If a journal entry has not been Source User Verified (look at the Process tab for the J/E), you can make changes to the information or mark it for deletion and then rerun/set flags on your audit trail.
- To Delete or Change a Journal Entry:
- If the Journal Entry Master has been verified but not distributed, you can flag the journal entry for deletion or make a change to it after undoing the Journal Entry source user verified flag: Maintenance → Undo → Journal Entry Audit Trail
- If the Journal Entry Master has been distributed, you must undo the J/E distribution flag which will undo the source user verified flag as well: Maintenance → Undo → Journal Entry Distribution
Query Journal Entries
- Finance → Financial Management → Query → Journal Entries
- Enter Range/Select Criteria to narrow your search.
- The Range fields below are not all inclusive of the criteria available. Those listed are commonly used.
FIELDS | Opt. | Rec. | Req. | Description |
---|
Fiscal Year | — | ♦ | — | Range on the fiscal year of the entry |
Transaction Number | — | ♦ | — | The transaction number is listed on the audit trail report; if you need to make a change to a specific journal entry, ranging on the transaction number will query only the transaction which needs to be changed |
Entry Date | — | ♦ | — | Query all journal entries entered on a single date or range of dates |
Source User | — | ♦ | — | Query only entries made by source user identified |
Fiscal Month | — | ♦ | — | Range on the fiscal month of the entry or entries |
Opt. = Optional Rec. = Recommended Req. = Required |
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.