MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Financials > General Ledger > Screens > Transaction > GL170S3A - Transaction Inquiry Statistical Detail

GL170S3A - Transaction Inquiry Statistical Detail

 

 

WILLIAMS                        GENERAL LEDGER                         2/27/95

 DSP01                       TRANSACTION INQUIRY                   STATISTICAL

                                                                               

      Company/Location        001  BRV                                         

      Account                 1220           COMMON STOCK                

      Center                                                  

      Period/Year (From/To)    1 1995  2 1995  EA  EACH                        

      Sequence Code           A                                                

                                                                               

    Pd  Yr Beginning Balance Total Increases Total Decreases  Ending Balance   

    AC                  .00        50,005.00       15,000.00       35,005.00   +

   

 S  Pd  Yr     Journal     Journal Type  UM     Increase        Decrease       

   Jrn Description   Ref1  Ref2  Doc/Pay Tp/No    Vend/Cust  BkC               

    12  1995     JE0397                                5.00  

    12  1995     JE0398                                           15,000.00

    12  1995     JE0399                           50,000.00                

                                                                               

                                                                                

                                                                               

                                                                               

 F2=Command          F3=Exit             F4=Prompt           F6=Fold/Truncate  

 F7=Previous Rec     F8=Next Rec         F15=Print                             

 

 

This screen displays statistical transactions based on the criteria specified on the Function Select screen.  There are two subfiles on the screen.  The first displays the transaction totals by period.  The second displays the individual transactions.

COMPANY

Display only.  This field displays the company that the transactions are from.

LOCATION

Display only.  This field displays the location within the company that the transactions are from.

ACCOUNT

Optional.  This field displays the account to which the transaction belongs.  You may view transactions for another account by typing over the account displayed and pressing the Enter key.

CENTER

Optional.  This field displays the center to which the transaction belongs.  You may view transactions for another center by typing over the center displayed and pressing the Enter key.

FROM FISCAL PERIOD

Display only.  This field displays the first fiscal period for which transactions were requested.  This date defaults from the Transaction Inquiry Function Select screen (GL170S01); however, you may view transactions for another period by typing over the period displayed and pressing the Enter key.

FROM FISCAL YEAR

Display only.  This field displays the first fiscal year for which transactions were requested.  The year defaults from the Transaction Inquiry Function Select screen (GL170S01); however, you may view transactions for another year by typing over the year displayed and pressing the Enter key.

TO FISCAL PERIOD

Display only.  This field displays the last fiscal period for which transactions were requested.  The date defaults from the Transaction Inquiry Function Select screen (GL170S01); however, you may view transactions for another period by typing over the period displayed and pressing the Enter key.

TO FISCAL YEAR

Display only.  This field displays the last fiscal year for which transactions were requested.  The year defaults from the Transaction Inquiry Function Select screen (GL170S01); however, you may view transactions for another year by typing over the year displayed and pressing the Enter key.

SEQUENCE CODE

Display only.  This field displays the sequence in which the Account/Center Master File was read.  The sequence will determine which account/center you view after pressing either F5 or F6.  Account sequence is indicated by a 'A', center sequence is indicated by a 'C'.

FISCAL PERIOD

Display only.  This field displays the fiscal period for which transaction totals are displayed.  A period of 'AC' indicates that the totals are accumulated for all of the periods.

FISCAL YEAR

Display only.  This field displays the fiscal year for which the transaction totals are displayed.

BEGINNING BALANCE

Display only.  This field displays the balance in the Account/Center Master File at the time of the from period.  If the account is a balance sheet account, the beginning balance is the ending balance of the previous period.  If the account is an income statement account, the beginning balance is the sum of the ending balances of each period since the first period of the fiscal year.

TOTAL INCREASES

Display only.  This field displays the total of all increases in quantity during the date range for which transactions are requested.

TOTAL DECREASES

Display only.  This field displays the total of all decreases in quantity during the date range for which transactions are requested.

ENDING BALANCE

Display only.  This field displays the balance at the end of the period.  This figure is calculated by adding the beginning balance to the total increases, and subtracting total decreases.

SELECT

Display only.  This field is used to view the originating document of a specific transaction.  Enter an 'X' to select a transaction.  More than one transaction may be selected at a time.  If the transaction did not originate from the Accounts Payable or Accounts Receivable subsystem, you will not be able to select it.  If the selected transaction was passed in summary to the general ledger, all subsystem documents related to the selected transaction will be displayed.  If the selected transaction was passed in detail to the general ledger, the originating document will be displayed.

FISCAL PERIOD

Display only.  This field displays the fiscal period during which the transaction occurred.

FISCAL YEAR

Display only.  This field displays the fiscal year during which the transaction occurred.

JOURNAL NUMBER

Display only.  This field displays the journal number of the journal that the transaction belongs to.

JOURNAL TYPE

Display only.  This field displays the journal type of the journal that the transaction belongs to.

UNIT OF MEASURE

Display only.  This field displays the unit of measure that the transaction quantity is expressed in.

INCREASE

Display only.  This field displays the increase in quantity for the transaction.  If the transaction has a decrease in quantity, this field will be blank.

DECREASE

Display only.  This field displays the decrease in quantity for the transaction.  If the transaction has an increase in quantity, this field will be blank.

JOURNAL DESCRIPTION

This field displays descriptive information about the journal in which the transaction occurs.

MAJOR REFERENCE

Display only.  This field displays reference information about a transaction.

MINOR REFERENCE

Display only.  This field displays reference information about a transaction.

COMMAND KEYS

F2    - Display a window where a fast path option or mnemonic can be entered.  Fast path allows the next menu selection to be made directly from this screen.  When the window is displayed, pressing F3 will remove it.

F3    - Exit program without processing the entered data.

F4    - Display a list of values for the field where the cursor is positioned.  If you select one of the items from the list, it will be returned to the application screen.

F6    - Used to alternate between one-line and multi-line display formats.

F7    - Used to display the previous record on a file.  When you are reviewing a title file, for example, pressing this command key will retrieve the previous record line item on the file.  The new account and center displayed will depend on whether you specified that the data should be in account sequence or center sequence.

F8    - Used to display the next record on a file.  When you are reviewing a title file, for example, pressing this command key will retrieve the next record on the file.  The new account and center displayed will depend on whether you specified that the data should be in account sequence or center sequence.

F15   - Used to prepare a listing of the transactions for the displayed account/center.