Background: GL Activity Inquiry
Use the GL Activity Inquiry (GTL) program to display GL transactions for an account. See Road Map for work flow.
This topic has these subtopics:
Journals
Net Zero Transactions
Original Transactions
History
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 not selected for the journal.
Net Zero Transactions
GL Activity Inquiry does not display transactions that net to zero. The system does provide an audit trail of these transactions. Use the Interface Journal Inquiry (GJQ) program to display these transactions. Use the Interface Journal Scheduler (GJ) program to print 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; for example:
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) |
Invoice, order number, shipment, commission split |
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 |
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.