Road Map: 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 Background for more information.

Before you run this program each time

You should run these programs:  

Accounts Payable

  • AP Invoice Entry (NE) to enter a batch of invoices (vendor vouchers) and print the AP Invoice Register for a batch of invoices, for fixed expenses, and for sales commission payments, which updates the general ledger.

  • AP Payment Register (NCR) to print a batch of payments and update the general ledger.

  • On-Account Payments Application (NMO) to select on-account transactions to invoices and print the AP On-Account Payment Register.

  • AP Check Void & Reversal (NVC) to void checks for reconciliation purposes, reverse checks posted to the general ledger, and print the AP Check Reversal Register.

Accounts Receivable

  • AR Invoice Register (RR) to select confirmed shipments to invoice and print the AR Invoice Register, which creates AR invoices and updates the general ledger.

  • Cash Receipts Entry (RCE) to enter cash receipts and print the Cash Receipt Register.

  • AR Adjustments Entry (RB) to apply an AR adjustment or write-off, transfer an invoice balance to another AR account, and print the AR Adjustment Register.

  • Finance Charge Calculation (RFC) to calculate finance charges on past due invoices in customer accounts and print the Finance Charge Register.

  • AR Check Reversal (RVC) to reverse a check or credit card payment and print the AR Payment Reversal Register.

Fixed Assets

  • Fixed Assets Depreciation Register (FR) to print fixed asset depreciation for a period and update the general ledger.

general ledger

  • Recurring Journal Processing (GRP) to process recurring journals set up in the Recurring Journal Maintenance (GRM) program and to print the GL Recurring Journal Register.

  • General Journal Entry (GIP) to print and post general journal entries; also run from GL Period-End Closing (GME).

  • Allocating Journal Processing (GAP) to process allocating journals and to print the GL Allocating Journal Register.

  • Closed Period Adjustments (GIC) to enter a general journal adjustment or correction to a closed period and print the Journal Adjustments Register.

  • Automatic Journal Maintenance (GMI) to maintain automatic journal postings prior to updating GL.

Inventory

  • Material Issues and Adjustments (IMI) to print the Inventory Adjustment Register and to update the general ledger if you have inventory interfaced to the GL.

  • Physical Inventory Update (HCU) to update on-hand inventory balances based on deviations recorded in Inventory Deviation Listing (HDL) and update the general ledger if you have inventory interfaced to the GL.

  • Standard Cost Rollup (MCR) to roll up costs of inventory items and update the general ledger if you have inventory interfaced to the GL.

  • Transfer Shipment Register (IEJ) to print a listing of transfer shipments and update inventory accounts in the general ledger if you have inventory interfaced to the GL.  

  • Transfer Receipt Register (IRJ) to print a listing of transfer shipments that a branch receives and update inventory accounts in the general ledger if you have inventory interfaced to the GL.

  • RMA Receipt Register (SRJ) to print a list of Return Material Authorizations that you have received and update them to the general ledger if you have inventory interfaced to the GL.

  • Manufacturing Order Receipt Register (MRJ) to print a list of manufacturing orders you have received into inventory and update them to the general ledger if you have inventory interfaced to the GL.

  • PO Receipt Register (VRJ) to print a list of received purchase orders and update them to the general ledger if you have inventory interfaced to the GL.

  • Rejected Material Disposition Register (VBJ) to print a list of rejected and disposed materials and update the general ledger if you have inventory interfaced to the GL.

Manufacturing

  • Manufacturing Order Picking Register (MPKJ) to print a listing of components you have picked and update the general ledger if you have inventory interfaced to GL.

  • WIP Register (WIPR) to print a listing of good and scrapped pieces for operation sequences on a manufacturing order and update the general ledger if you have inventory interfaced to the GL.

  • Labor Entry Register (LPR) to print a listing of labor entries and update the general ledger if you have labor and inventory interfaced to the GL.

  • Manufacturing Cost Adjustments (MCA) to enter an adjustment to material, labor, purchased service, overhead (labor and machine), and miscellaneous costs for a manufacturing order, print the Manufacturing Cost Adjustments Register, and update the general ledger if you have inventory interfaced to the GL.

  • Manufacturing Order Close (MJC) to close completed manufacturing orders and print the Manufacturing Order Close Register.

Before you run this program the first time

You should run these programs:

  • System Options Maintenance (XM) (GL Journal Options) to set the Erase posting files after posting? option.

  • System Options Maintenance (XM) (General Ledger Options) to select the YTD transaction history? option.

  • System Options Maintenance (XM) (Enterprise Options) to select a date display format for your enterprise, Branch Maintenance (TBM) to select a date display format for your branch, or User Maintenance (UIM) to select a date display format for an individual user.

  • GL Account Maintenance (GMM) to set up GL organization codes and GL accounts.

  • Posting Criteria Maintenance (XPC) to set up posting criteria and accounts that programs use to post to the general ledger.

  • GL User Maintenance (GUIM) to add GL users and give them access or restrict them from accessing specific accounts.

  • Output Device Maintenance (XDM) to set up the output devices that you plan to use.

  • Date-Output Device Maintenance (ZE) to select your default output device and set whether you can override that device.

After you run this program

You will most likely run these programs:

  • GL Activity Inquiry (GTL) to display GL transactions for an account.

  • GL Transaction Listing (GYL) to print account transactions within a date range.

  • Interface Journal Inquiry (GJQ) to display a journal's transactions.

  • GL Activity Report (GAR) to print a report that shows debits, credits, net change, current balance, and profit for a period.