Using the Accounting Journal (JACTG) to Review Transactions

Overview

This job aid will assist you in understanding how to review CORE transactions using the Accounting Journal. The Accounting Journal (JACTG) is useful for reviewing transactions that are limited in scope and nearly the only way to review the final impact of transactions that are not yet available in InfoAdvantage because the associated ETL run has not yet happened.

The Accounting Journal can be used to look at single specific transactions or a range of transactions that meet the search parameters.

Highlight JACTG Global Search

2. Enter your search criteria:

highlight search fields

This guide will take us through two types of searches and items that can be reviewed in each.

highlight specific transaction search fields

Since we were looking for a specific transaction, the search returned all the lines on that one specific transaction.

highlight specific transaction search for all lines

At this point, you can review the posting information of the highlighted row by clicking the caret on the right side of line and looking at the fields below or you can use the blue hyperlink to jump directly to the transaction. If we wanted to review a different line we could highlight that line (NOT on the hyperlink for that line) and it will update the information displayed below.

highlight posting information on row by caret expansion fields

If you use the hyperlink to go to the full transaction, the areas that can be reviewed are within the tabs:

Each of these elements comes from the original transaction. You can compare some of these elements in the different tabs. For example, if you look at the Header tab, you can see the Record Date, FY, BFY, and Accounting Period used for this line. 

highlight jv1stnd header tab transaction element fields

The Posting tab shows the posting amount matches the line amount. Each section can be reviewed for the accuracy of the specific posting.

highlight posting tab showing posting amount matches line amount

2. Search By COA Elements

This sort of search will provide all transactions hitting a specific set of COA elements. So, it is recommended to enter all applicable COAs to limit the search results.

In the below example, we will look for all transactions with a specific Fiscal Year, Department, and BSA combination.

highlight accounting journal search fields
highlight accounting journal search results

Detailed information on each line can be reviewed like above. Note that a specific Transaction Record Date range is allowed together with specific COA elements in the search:

highlight transaction record date range
highlight transaction record date sign