Edit / Delete / Query Journal Entries
Print
Modified on: Tue, 6 May, 2025 at 2:24 PM
What This Process Does
- This process allows the user to locate specific Journal Entry Masters in order to review, make changes, or delete 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.
Edit / Delete Journal Entries - Requirements
- If the journal entry has been Distributed (that box will be checked on the Journal Entry Master Process tab), you must undo the journal entry distribution first before any changes will process. Undo Journal Entry Distribution, then make changes to the journal entry, or delete it by checking the delete box. Run the audit trail, distribution and posting steps Journal Entry Processing Steps.
- If the journal entry has only been Source User Verified (that box will be checked on the Journal Entry Master Process tab), you must undo the journal entry audit trail first before any changes will process. Undo Journal Entry Audit Trail, then make changes to the journal entry, or delete it by checking the delete box. Run the audit trail, distribution and posting steps Journal Entry Processing Steps.
- If the journal entry has not been Source User Verified (that box will be unchecked on the journal entry Process tab), you can make changes to the journal entry, or delete it by checking the delete box. Run the audit trail, distribution and posting steps Journal Entry Processing Steps.
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.
- If you want to view an individual journal entry, highlight and click the Select button to see more information. This will pull up the Journal Entry Maintain Screen. Click on Process Tab to see if it is Source User Verified and Distributed.
- Click Cancel once you're finished viewing.
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.