Background: GL Transaction Inquiry

Use the GL Transaction Inquiry (GTI) program to display detail (for example, the purchase order, receiver, invoice, and/or check number) and the posting journal. See Road Map for work flow.

This topic has these subtopics:

Uses	Organization vs. Organization Group
Journals	History
Original Transactions

Uses

The GL Transaction Inquiry helps you locate a particular transaction when you do not know the journal or account number. If you know the journal, you can display the transaction with the Interface Journal Inquiry (GJQ) program. If you know the account, you can use the GL Activity Inquiry (GTL).

GL Transaction Inquiry displays all transactions that meet the Selection options you set. Performance can be slow if you have not set any options because the program reads all records. On the other hand, setting too many Selection options can also slow performance as the program reads all records, searching for those that meet your selection criteria.

If you typically are looking for transactions in the current period, you may want to set the Trans date Selection option to always display the current period. To do so, Click Prog opts, click Other info, click Modify, enter SOM in the From column and EOM in the To column, click Save, and click OK. If you want to display the current quarter or year, choose the appropriate date shortcut. See Date Shortcuts.

Journals

You can display the originating journal, if it is available. This program also allows you to view journal detail when you post to the GL in summary. Journal detail is available only if the Erase posting files after posting? option in the System Options Maintenance (GL Journal Options) program is set to N for the journal.

Original Transactions

Click Detail to drill to the original transaction. For example, from a cash transaction you can display the specific customer payment information, including the invoices that were paid and the corresponding sales orders for those invoices.

The program you drill to depends on the journal source:

Source	Detail button displays	Then you can display
GJ1	Manufacturing Order Cost History Inquiry (MHC)	Standard and actual unit costs and variance or standard and actual units per hour and efficiency percent
GJ2	Sales Commission Inquiry (SCQ)
GJ3	Receiver Inquiry (IRCQ)	Quantity received, inspected, and rejected
GJA	AR Adjustments Inquiry (RAI)	Invoice, GL journal
GJB	Recurring Journal Inquiry (GRQ)	Journal lines
GJC	AR Payment Inquiry (RPI)	Invoice, GL journal
GJD	AP-Purchasing Inquiry (NDQ)	Invoice, PO, Receiver, Check, Vendor
GJE	WIP Order Inquiry (WIQ)	Components, receiver
GJF	AR Invoice Inquiry (RQ)	Sales order, Shipment
GJI	AR Invoice Inquiry (RQ)	Sales order, Shipment
GJJ	Branch Transfer Inquiry (ITSQ)	Item, quantity, and branches
GJK	WIP Order Inquiry (WIQ)	Components, receiver
GJL	Manufacturing Labor Inquiry (MLI)	Labor details
GJM	AP Inquiry (NI)	Invoice, PO, Check, Journal
GJN	AP-Purchasing Inquiry (NDQ)	Invoice, PO, Receiver, Check, Vendor
GJO	Allocating Journal Inquiry (GAQ)	Journal lines
GJP	Fixed Asset Inquiry (FI)	Fixed asset details
GJR	Receiver Inquiry (IRCQ)	Item, quantity received, inspected, and rejected, warehouse/bin location, control number
GJS	WIP Movement Inquiry (WPQ)	Manufacturing order
GJT	Material Issues and Adjustments Inquiry (IMIQ)	Warehouse, bin, control number
GJU	Receiver Inquiry (IRCQ)	Item, quantity received, inspected, and rejected, warehouse/bin location, control number
GJV	AP-Purchasing Inquiry (NDQ)	Invoice, PO, Receiver, Check, Vendor
GJW	Receiver inquiry (IRCQ)	Receiver lines, Order
GJX	AR Payment Inquiry (RPI)	Invoice, GL journal
GJY	Rejected Material Disposition (MRB)	Quantity and disposition
GJZ	Cost-Rollup Inquiry (MCRQ)	Item number cost updates

Organization vs. Organization Group

You can print the report for a specific organization or an organization group. When you print a report for an organization group, it will include a section for each organization in the group.

Note
If you print a report for a consolidation, the report is for that organization only and not for the subsidiaries that consolidate to it. If you want to include the subsidiary organizations, select a consolidation group (for example, **0).

History

You must select the YTD transaction history? option in the System Options Maintenance (XM) program (General Ledger Options) to be able to view transactions from closed periods.