Journal Entry History Inq

Description: The Journal Entries inquiry displays a list view of all New, Approved, Ready to Post, and Posted journal entries. From the inquiry, the corresponding journal entry record view can be opened. In addition, the inquiry selection can be refined using the Inquiry Criteria. 

Header Toolbar

Toolbar Icons

Description
Excel

Export the contents of the list view to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view only the filtered contents will be exported. 

Grid Layout

Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

Inquiry Criteria

Opens Inquiry Criteria window where users can define the following criteria: 

  • GL Period
  • GL Year
  • Date From
  • Date To
  • Status
More Actions

Opens a drop-down menu for the user to select Reverse/Correct, which opens the Reverse/Correct page and allows the user to either Reverse or Correct a journal entry.

Notes

Opens the Notes dialog, allowing the user to enter a note that can be applied to all selected or filtered journal entries. 

Print

Opens the Print dialog window, where transaction and/or analysis reports can be downloaded, printed and/or emailed. 

RefreshRefreshes the inquiry.
Show Net Affect

Opens GL Net Affect Inquiry, which displays the summarized net affect of selected journal entries. 

(lightbulb) One or more journal entries must be selected to open the GL Net Affect Inquiry.

Columns

Column Headers

Description
CommentDisplays the comment entered for the journal entry. 
CreatedDisplays the date and time the Journal was created.  This field populates when the record is created and does not update after that. A journal record can be created from a transaction; when clicking journal details for the first time from a record view of a transaction or when approving or posting a transaction without first clicking the journal details button.
Created ByDisplays the username of the user that created the Journal. This field populates when the record is created and does not update after that. A journal record can be created from a transaction; when clicking journal details for the first time from a record view of a transaction or when approving or posting a transaction without first clicking the journal details button.
GL PeriodDisplays the GL period in which the journal date resides.
GL YearDisplays the GL year in which the journal date resides.
Host JEDisplays the corresponding host system's journal entry number for the journal entry. 
Journal DateDisplays the date of the journal entry. 
Journal IDDisplays the journal ID for the journal entry as a hyperlink that, when clicked, opens the corresponding record view.
Journal TypeDisplays the type of the corresponding journal entry. E.g. all journal entries created from transactions display Transaction as the Journal Type.
Last UpdatedDisplays the date and time the Journal was most recently updated.
Last UserDisplays the username of the user who updated the Journal most recently.
Master NumberDisplays the master number of the corresponding journal entry to give users the ability to audit the trail of journal history.
NoteDisplays the first characters of the journal entry's note, if one exists. 
PostedDisplays the date and time the Journal was posted. This field is populated when manual journals or transaction journals are saved as Ready to Post or Posted.
Posted ByDisplays the username of the user that posted the Journal.  This field is populated when manual journals or transaction journals are saved as Ready to Post or Posted.
ReferenceDisplays the reference entered for the journal entry.
Source ModuleDisplays the name of the module from which the transaction resulting in the journal entry came. 
Source Trans DateDisplays the date of the transaction resulting in the journal entry.
Source Trans DetailDisplays a customer / vendor name and ID assigned to the transaction. This field is blank if not applicable.
Source Trans IDDisplays the transaction ID of the transaction resulting in the journal entry as a hyperlink that, when clicked, opens the corresponding transaction's record view. 
Source Trans TypeDisplays the transaction type to which the transaction resulting in the journal entry belongs. 
Source Trans VersionDisplays the version number of the transaction resulting in the journal entry.
StatusDisplays the status of the journal entry. 

Related Topics

Journal Entries List View

Journal Lines List View

Journal Line History Inq


 Page Definitions


 Technical Details


Stored Procedures:
IQx_GLSEL_JournalList