MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Financials > General Ledger > Screens > Consolidation Worksheet Request > GL600S01 - Consolidation Worksheet Request Selection

GL600S01 - Consolidation Worksheet Request Selection

 

 

WILLIAMS                        GENERAL LEDGER                         2/27/95

 DSP01                  CONSOLIDATION WORKSHEET REQUEST                 SELECT

                                                                               

                                                                                

                                                                               

     Company (From/To)                 001 BRU             (Blank = all)       

     Company or Location Report        C                                       

                                                                               

         Submit                        Y                                       

                                                                                

                                                                               

                                                                               

                                                                               

                                                                               

                                                                               

                                                                                

                                                                               

                                                                               

                                                                               

                                                                               

                                                                               

 F2=Command          F3=Exit             F4=Prompt                             

                                                                                

                                                                               

 

 

The Consolidation Worksheet Request screen allows the request of a range of companies to be extracted in order to produce a consolidation worksheet.

When requesting consolidation worksheets for more than one company, the currency level on Reference File category 133 must be defined at a global level.  If the currency level is defined at the company level, only one company can be requested at a time.  No consolidation worksheets can be run if the currency level is defined at the location level.

Note:  If consolidation worksheets are requested when the currency level is defined at the location level, or when the currency level is defined at the company level and more than one company is requested, an error is reported and processing ends.

The Consolidation Worksheet Request can be printed using a 132- or 198-character-wide format depending on the entries on Reference File category 025.  For more information, see the report description of the Consolidation Worksheet (GL610) in the report section of this manual.

FROM COMPANY NUMBER

Optional.  The company range consists of a 'from' company and a 'to' company.  The consolidation worksheet extract will extract records beginning at the 'from' company, and continue processing through the 'to' company.  The 'from' company must be less or equal to the 'to' company, or an error will be displayed.  If both of the fields are left blank, the report is requested for all companies.

TO COMPANY NUMBER

Optional.  The company range consists of a 'from' company and a 'to' company.  The consolidation worksheet extract will extract records beginning at the 'from' company, and continue processing through the 'to' company.  The 'from' company must be less or equal to the 'to' company, or an error will be displayed.  If both of the fields are left blank, the report is requested for all companies.

COMPANY OR LOCATION REPORT TYPE INDICATOR

Required.  The report type indicator is used to determine the level of detail printed on the consolidation worksheet.  The valid values are:

C - Company level

L - Location level

SUBMIT CODE

Required.  The submit flag specifies whether a report should be submitted for later execution or whether the report should be generated immediately.  Immediate processing is usually reserved for low volume requests because the terminal used to request the processing will not be available until the processing is completed.  Valid values are:

Y - Submit processing request for later batch execution;

N - Perform processing interactively.

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.