Use the Journal feature to review journal transactions, drill into related records, and access supporting transaction details directly from reports or from the Journal workspace.
In this article, we will cover:
Opening the Journal Workspace
You can access Journal data in two ways.
Opening Journal from a Report
Open a report.
Right-click a journal cell.
-
Select Show Journal details.
In multi-currency environments, drill-down is available only when the report uses the Entity functional currency.
Opening Journal from the Navigation Pane
In the left navigation pane, select Journal.
-
Select the required filters:
Company
Book
Fiscal Year
Configuring Journal Settings
You can configure Journal display and export settings from the Journal workspace.
Opening Journal Settings
Open the Journal workspace.
Select the settings menu.
-
Select one of the following options:
Journal settings
Column settings
Download journal
Download transactions
Configuring Column Settings
Use column settings to:
Change column order
Control visible columns
- Configure the Journal grid layout
Downloading Journal Data
You can export Journal information to Microsoft Excel format.
| Export Option | Description |
|---|---|
| Download Journal | Exports Journal Record |
| Download Transactions | Exports transaction - level details |
Using DrillDown
Use DrillDown to view detailed transaction information related to Journal entries.
Opening DrillDown Details
Open the Journal workspace.
Select a Journal row.
-
Select a DrillDown button.
-
The system displays additional transaction details either:
On the right side of the Journal grid.
In the lower DrillDown panel.
Available DrillDown Data
DrillDown can display:
Invoice details
Invoice line details
Physical invoice attachments
Order numbers
Part information
In DrillDown, you can have file formats such as txt, doc, and pdf.
Drill Further into Related Records
If a blue drill icon appears, additional drill-down levels are available.
Select the blue drill icon.
-
Open the related transaction details.
Continue drilling into associated records as needed.
Downloading Attachments
You can download attachments associated with Journal transactions.
Open DrillDown details for a Journal record.
Locate the attachment section.
-
Select the download icon.
Invoice attachments and TranGLC results display together in a single DrillDown tab.
Use the Show Lines Panel
The Show Lines Panel displays transaction lines related to the selected Journal record.
Opening the Show Lines Panel
The Show Lines Panel option is enabled by default when you open the Journal workspace.
Open the Journal workspace.
Select a Journal record.
Review the transaction details displayed in the lower panel.
Security Behavior
The rows displayed in the Show Lines Panel depend on user security settings. Users can view only the rows permitted by their administrator.
Additional Information
DrillDown buttons appear only for rows that contain attachments or TranGLC records.
DrillDown results can display in multiple layouts depending on the selected view.
Journal exports are generated as Excel files.