MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Financials > General Ledger > Screens > Drill Down > GL180S01 - Drill Down Inquiry Function Select

GL180S01 - Drill Down Inquiry Function Select

 

 

WILLIAMS                        GENERAL LEDGER                        11/06/92

 DSP01                        DRILL DOWN INQUIRY                         SELECT

                                                                               

                                                                               

                  Company/Location        001 BEL                              

                  Period/Year                                                  

                  Fin or Stat                                                  

                  Sequence Code           A                                    

                                                                                

                  Account/Center Template *1                                   

                  From Account/Center                                          

                  To Account/Center                                            

                                                                               

                  Account Type                                                 

                  Account Class                                                 

                  Statement Code                                               

                  Responsibility Code                                          

                                                                               

                                                                               

                                                                               

                                                                                

 F2=Command          F3=Exit             F4=Prompt                             

                                                                               

                                                                               

 

 

This online inquiry program allows you to inquire into the chart of accounts based on various selective criteria.  Each listed account may then be selected so that all transactions for that account are displayed.  In turn, the transactions may be selected and also the originating journals.

If the selected journal is from Accounts Receivable or Accounts Payable and the transaction was posted in detail, the originating document will be displayed.  If the transaction was posted in summary, all journals for that account will be displayed.  A journal may be selected and the original document will be displayed.

COMPANY/LOCATION

Required.  Enter the company and location for which you want accounts to be displayed.

PERIOD/YEAR

Optional.  Enter the month and year for which you want account balances to be displayed.

FINANCIAL OR STATISTICAL

Optional.  This field determines whether financial (amount) or statistical (quantity) data will be displayed for the selection criteria.  Valid values are 'F' and 'S'.

SEQUENCE CODE

Optional.  This field determines whether the Account/Center Master File will be read in account order or center order.  Valid values are 'A' and 'C'.  The default is 'A'.

ACCOUNT/CENTER TEMPLATE

Optional.  Used to search for account/centers.  When the detail screen is displayed, it will contain only accounts and centers that match the characters entered in these fields.  The left field is for the account number, the right for the center.  You can enter letters, numbers, or asterisks (*) in the fields.  An asterisk acts as a 'wild card'.  For example:

o  If you enter 1, all accounts beginning with 1 will be displayed.

o  If you enter *1, all accounts where the second character is 1 will be displayed.

o  If you enter **1, all accounts where the third character is 1 will be displayed.

o  If you enter *1*1, all accounts where the second and fourth characters are 1 will be displayed.

FROM ACCOUNT/CENTER

Optional.  This field specifies the first account and center of the range that will be displayed on the Drill Down Inquiry Detail screen (GL180S02).

TO ACCOUNT/CENTER

Optional.  This field specifies the last account and center of the range that will be displayed on the Drill Down Inquiry Detail screen (GL180S02).

ACCOUNT TYPE

Optional.  This field is used to restrict the records displayed to a specific account type.  Valid values are:

1 - Assets

2 - Liabilities and net worth accounts

3 - Year-to-date retained earnings

4 - Revenues

5 - Expenses

6 - Suspense

ACCOUNT CLASS

Optional.  If entered, only accounts for the selected account class will be displayed.  If entered, the account class must exist on Reference File category 340.

STATEMENT CODE

Optional.  The statement code is used as a sequential line reference for each financial statement line.  If entered, this is used as additional selection criteria when accessing a line description record.

MAJOR RESPONSIBILITY CODE

Optional.  The major responsibility code identifies the higher-level responsibility area to which one or more lower-level responsibility areas report.  Valid responsibility codes are found on the Reference File.  If this field is entered, it is used as additional selection criteria when displaying account balances.

REPORTING CLASS

Optional.  You may enter a valid reporting class in this field that will be used to select accounts for inquiry.

This field is only displayed if the Management Account Reporting option is set to yes (Y) on Reference File category 133.  Valid reporting classes are:

C - Common

F - Fiscal

M - Management

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.