Ideal Online Documentation

28525 G/L INQUIRIES
GL3-01 General Ledger Inquiry

 

PURPOSE

 

The general ledger inquiry program is used to inquiry upon general ledger transactions.

 

General Ledger Inquiry is accessed from:

  • G/L Main menu.

 

PROCEDURE

 

When you select General Ledger Inquiry from the G/L Main menu the following prompts display.

 

AS AT DATE ? (CR FOR SYSTEM DATE):

 

Enter the date up to which transactions will display.

 

[Enter] for the current date.

 

FROM DATE ? (CR FOR START OF MONTH):

 

Enter the date from which transactions will display.

 

[Enter] for the first day of the "as at date" month.

 

SHORT OR LONG FORMAT ? (ENTER 'S' OR 'L'):

 

"S" for short format.

 

Does not display the second description line that is used in the accounts payable invoice posting program.

 

 

"L" for long format.

 

Displays the second description line.

 

 

** PRESS CR TO CONTINUE:

 

[Enter] to display transactions.

 

[F4] to exit to menu.

 

The inquiry screen is displayed.


GENERAL LEDGER INQUIRY DISPLAY

┌────────────────────────────────────────────────────────────────────────────────┐
│06/22/07     GENERAL LEDGER INQUIRY FROM 06/01/07 THROUGH 06/22/07              â”‚
│────────────────────────────────────────────────────────────────────────────────│
│COMPANY...... 01    D E M O   C O M P A N Y                                     â”‚
│DIVISION..... __                                                                â”‚
│ACCOUNT......                                                                   â”‚
│SUB-ACCOUNT..                                                                   â”‚
│────────────────────────────────────────────────────────────────────────────────│
│SUB.  PERIOD  JRN.   DATE    SOURCE  SEQ#  REF#            DEBIT         CREDIT â”‚
│────────────────────────────────────────────────────────────────────────────────│
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│ENTER F3 FOR DATE, F4 TO END, F5 FOR INQUIRY.                                   â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
DIVISION

 

Enter the desired division code.

 

[F3] to reenter dates.

 

[F4] to exit to menu.

 

[F5] to display list for selection.

 

ACCOUNT

 

Enter the desired account code.

 

[F5] to display list for selection.

 

SUB-ACCOUNT

 

Enter the desired sub-account.

 

This prompt requires entry only if the account code entered has sub-accounts.

 


Example G/L Inquiry Transactions display:

┌────────────────────────────────────────────────────────────────────────────────┐
│Jun22/07     GENERAL LEDGER INQUIRY FROM Jun01/07 THROUGH Jun22/07              â”‚
│────────────────────────────────────────────────────────────────────────────────│
│COMPANY...... 06    DEMO COMPANY                                                │
│DIVISION..... 00    THE IDEAL COMPUTER GROUP INC.                               â”‚
│ACCOUNT...... 1000  BANK ACCOUNT                                                â”‚
│SUB-ACCOUNT..                                                                   â”‚
│────────────────────────────────────────────────────────────────────────────────│
│SUB.  PERIOD  JRN.   DATE    SOURCE  SEQ#  REF#            DEBIT         CREDIT â”‚
│────────────────────────────────────────────────────────────────────────────────│
│                   BALANCE FORWARD BEFORE Jun01/07:     5,978.62                â”‚
│      2007/06 DM   Jun01/07  DM2075  3537  cC23855                     5,226.03 â”‚
│      2007/06 DM   Jun01/07  DM2077  3650  cC23856                       500.00 â”‚
│      2007/06 DM   Jun01/07  DM2077  3651  cC23857                       500.00 â”‚
│      2007/06 DM   Jun01/07  DM2077  3652  cC23858                       500.00 â”‚
│      2007/06 DM   Jun01/07  DM2077  3653  cC23859                       500.00 â”‚
│      2007/06 DM   Jun01/07  DM2077  3654  cC23860                       317.06 â”‚
│      2007/06 DM   Jun01/07  DM2077  3655  cC23861                       500.00 â”‚
│      2007/06 DM   Jun01/07  DM2077  3656  cC23862                       500.00 â”‚
│      2007/06 DM   Jun01/07  DM2077  3657  cC23863                       500.00 â”‚
│      2007/06 DM   Jun01/07  DM2077  3658  cC23864                       500.00 â”‚
│      2007/06 DM   Jun01/07  DM2078  3668  cC23865                       237.42 â”‚
│                                                                                â”‚
│** PRESS CR FOR NEXT SCREEN, F2 TO SCROLL TO END, F4 TO SKIP TO END:            â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘

 

OPTIONS

 

After you enter an account code one of the following prompts will appear.

 

1. When there are more transactions than can be displayed on one screen:

 

** PRESS CR FOR NEXT SCREEN, F2 TO SCROLL TO END, F4 TO SKIP TO END:

 

[Enter] to display the next screen of transactions.

 

[F2] to display all transactions to the end.

 

The transactions display one after another without pause until the final page of transactions, where option prompt 2 is displayed.

 

 

[F4] to jump to the final screen display.

 

Option prompt 2 is displayed.

 

 

2. When there are no further transactions to display:

 

** PRESS F1 TO CONTINUE; 'P' FOR PRINTOUT:

 

[F1] to return to the DIVISION field.

 

You can inquire upon another account. Press [Enter] to remain in the same division or enter a different division code and then the desired account code.

 

 

"P" to queue this account for printing.

 

The account information will print when you exit the program.

 

 

 

FIELDS

 

SOURCE

 

Displays the batch number and indicates where a transaction came from.

 

DATE

 

Displays the transaction date.

 

REFERENCE #

 

If the transaction was automatically updated via another program module, the first two characters from the source code are displayed here. If the entry was posted through the JOURNAL ENTRY program, the reference that was keyed in during the posting is displayed here.

 

DESCRIPTION

 

If the transaction was automatically updated via another program module, the description will indicate which module performed the update. If the entry was posted through the JOURNAL ENTRY program, the description as keyed in during the posting will be displayed here.

 

DEBIT/CREDIT

 

Displays the transaction amounts in their respective columns.