MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Financials > General Ledger > Key Concepts and Procedures > Master File Reporting > Prepare Consolidation Worksheet

Prepare Consolidation Worksheet

 

To prepare consolidation worksheets for a specific company or all companies, perform the following procedures.  The user should be aware that in a multi-currency environment, consolidation is in the base currency of the entity.  Therefore, care should be taken when performing consolidation on entities with different base currencies.

Select Report Selection Screen

1.   Enter the Consolidation Worksheet master file reporting option on the GLMENU to display the Consolidation Worksheet Request Screen (GL600S01).

Select Worksheet Parameters

2.   Enter the from and to company fields to print the worksheet for a range of companies.  Leave these fields blank to print the worksheet for all companies.  Determine whether to perform accumulations at the company or location level.

The submit code determines when the consolidation worksheets will be printed.  When you set the submit code to Y and press the Enter  key, a job is submitted to perform the print processing.  The message "Report request submitted" is displayed and the request screen is redisplayed.  The print job is held for later processing.  (See the Releasing Submitted Jobs discussion for more information on job scheduling.)

When you set the submit code to N and press the Enter key, print processing is performed interactively.  As reports are processed the message "Report print in progress" is displayed.  The message "Print request completed" is displayed when all print processing is completed.

When a large number of reports are processed interactively, the terminal from which the print request is entered may not be available for an extended period of time.  Also, interactive computer resources may be unduly taxed by this processing.

When all report requests are processed, end the session.  (See step 4, End Session.)

Cancel Request

3.   To cancel the print request before you submit the job, press the Exit key (F3).  Displayed worksheet request parameters are not processed, and the GLMENU is redisplayed.

End Session

4.   To end the conversation and redisplay the GLMENU, press the Exit key (F3).