The Accounting Journal (JACTG) is a common research tool as it contains all debits and credits considered as having a financial accounting impact. The Accounting Type Journal indication on a Posting Code (PSCD) record directs the system to update the Accounting Journal. As delivered, this journal includes all posting codes except those used in budgeting and several one-sided cost accounting postings. When adding new posting codes, ensure a consistent Accounting Type Journal setting for both posting codes in a posting pair. If not, one side of the posting pair will post to the journal and the other will not, which will create a System Assurance 3 out of sync condition.
Although a popular and complete data source for inquiry, the Accounting Journal contains a very large number of records. Unless configured for an individual implementation, there are no required search criteria. The JACTG Maximum Record Count (JACTG_MAX_REC_COUNT) parameter on the Application Parameter table defines the maximum number of rows returned. When exceeded, system feedback will prompt additional criteria. While there is an online inquiry into the Accounting Journal, ledger inquiry pages or a report will perform better without restrictions.
The Accounting Journal page contains a unique action among journals. The Calculate Amount Total page action summarizes selected records from a search, populating the Calculated Amount. The Calculate Amount Total action is a securable one because of the system resources required. To prevent the calculation of large numbers of records, the following search criteria must be entered, or an error is issued when the action is taken.
Fiscal Year or Budget Fiscal Year, Fund, Posting Code, and either BSA, Object, or Revenue Source. At least one non-wild card value needs to be entered on the fields that are not years.
OR
If the following are populated, there are no other restrictions: Transaction Code, Transaction Department, or Transaction ID.
OR
If Transaction Record Date or Run Time Date is populated, there are no other restrictions.
OR
If Vendor Invoice Number is populated, there are no other restrictions.
In addition to the criteria above, the Record Limit for Calculated Amount Total Action parameter on the Application Parameter table defines a hard limit to the number of records summarized. Please note with Row Level Security, the search criteria and security role filter the number of rows returned. The Calculate Amount Total functionality includes the rows not displayed based on Row Level Security. A warning message calls this out.