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

GL170S2A - Transaction Inquiry Financial Detail

 

 

WILLIAMS                        GENERAL LEDGER                         2/27/95

 DSP01                       TRANSACTION INQUIRY                     FINANCIAL

                                                                               

      Company/Location        001  BRV                                         

      Account                 1130           CASH - FIRST NATIONAL             

      Center                                                                   

      Period/Year (From/To)    1 1994 12 1994                                   

      Sequence Code           A              Reporting Class    C              

                                                                               

 Pd Yr Beginning Balance   Total Debits     Total Credits    Ending Balance    

 AC                 .00     14398,751.43        793,044.97     13605,706.46     +

                                                                               

 S  Pd  Yr     Journal     Journal Type  Cur      Debit           Credit       

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

    12  1995     JEAL03          X         BFR                     24,240.00   

  MISCELLANEOUS EXPENSE     

    12  1995     JE0301          X         BFR                     18,804.97    

  RETURNS                                                                       

    12  1995     JE0301          X         BFR    1865,853.91                   

  SALES RECEIPTS                                                                 

    12  1995     JE0397          X         BFR         250.00                   

  STOCK SALE                                                                    

                                                                                +

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

 F7=Previous Rec     F8=Next Rec         F15=Print           F19=Foreign Amt  

 

 

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

COMPANY/LOCATION

Display only.  These fields display the company and location where 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

Optional.  This field displays the first 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.

FROM FISCAL YEAR

Optional.  This field displays the first fiscal year for which transactions were requested.  The date 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 F7 or F8.  Account sequence is indicated by an 'A', center sequence is indicated by a 'C'.

REPORTING CLASS

Display only if management accounts are used.  Displays the management reporting class of the transactions on the screen.  Only transactions of this class are displayed.  Valid values are:

C - Common

F - Fiscal

M - Management This field is only displayed if the Use Management Accounts flag on Reference File category 133 is set to yes (Y).

FISCAL PERIOD

Display only.  This field displays for which fiscal period the transactions 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 DEBITS

Display only.  This field displays the total of all debits during the date range for which transactions are displayed.

TOTAL CREDITS

Display only.  This field displays the total of all credits during the date range for which transactions are displayed.

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 debits, and subtracting total credits.

SUBFILE AREAS

The following fields may be displayed in the same area of the screen, depending on whether the fold/truncate key is pressed.  Consequently, these fields are included in the same help area.  You can page down to view help for any of the fields.

Line 1:  Period, Year, Journal Number

Line 2:  Journal Description, Minor Reference

The following fields may be displayed in the same area of screen, depending on whether the fold/truncate key is pressed.  Consequently, they are included in the same help area.  You can page down to view help for any of the fields.

Line 1:  Journal Type, Currency, Debit Amount

Line 2:  Minor Reference, Doc/Pay, Tp/No, Vend/Cust

SELECT

Optional.  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.  You can only select a transaction if it was distributed from the Accounts Payable or Accounts Receivable subsystem.  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.  Journal types are:

A  -  Allocation journal

C  -  Accounts Receivable journal

I  -  Intercompany journal

M  -  Manual or recurring journal

P  -  Accounts Payable journal

R  -  Journal reversed by system processing

S  -  Standing journal

V  -  Revaluation journal

X  -  Other subsystem journal

CURRENCY CODE

Display only.  This field displays the code of the currency that the debit or credit field is expressed in.

DEBIT

Display only.  This field displays the amount of a positive transaction.  If the transaction amount is negative, this field is blank.

CREDIT

Display only.  This field displays the amount of a negative transaction.  If the transaction amount is positive, this field is 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.

DOCUMENT/PAYMENT TYPE

Display only.  This field identifies the type of document or payment associated with the transaction.

DOCUMENT/PAYMENT NUMBER

Display only.  This field identifies the document or payment that is associated with the transaction.

VENDOR/CUSTOMER

Display only.  The vendor or customer for whom the document was created.

BANK CODE

Display only.  This field identifies the bank associated with the 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.

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.

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

F19   - Used to switch the transaction amounts displayed from base currency to foreign currency.  This option is only available when the transaction amounts are shown in base currency.

F19   - Used to switch the transaction amounts displayed from foreign currency to base currency.  This option is only available when the transaction amounts are shown in foreign currency.