Executing Rollups 

Procedure

  1. Choose Accounting ® Financial Accounting ® Special Purpose Ledger ® Periodic Tasks ® Rollup ® Execute. The Execute Rollup: Initial Screen appears.
  2. Enter the name of the rollup that you want to execute.
  3. Choose . The Execute Rollup <Name>: Parameter Screen appears.

If you entered a value or set variable in one of your rollup sets, a dialog box appears, prompting you to confirm or change the default value of the variable.

The dialog box for set variables appears first, followed by the dialog box for value variables. The Execute Rollup <Name>: Parameter Screen appears.

If there are errors in the rollup definition, a screen appears, listing errors that you have to correct. If the errors are only warnings, choose . The Execute Rollup <Name>: Parameter Screen appears.
  1. Enter the following information:

Parameter fields:

For standard, hierarchical and export rollups (when the fiscal year variants are the same for the source ledger(s) and rollup ledger):

Enter the beginning period for which you want to reverse rollup data.

Enter the fiscal year for the value entered in the From period field.

Enter the end period for which you want to reverse rollup data.

Enter the fiscal year for the value entered in the To period field.

For standard rollups (when the fiscal year variants are different for the source ledger(s) and the rollup ledger):

Enter the start date for the rollup execution

Enter the end date for the rollup execution

Set the Carry-frwrd period frm yr indicator if you want to reverse the carry forward period of a specific year. In the second field, enter the fiscal year for which you want to roll up the carry forward period.

Set the Special periods indicator if you want to roll up all special periods.

Processing options fields:

If you want to execute your rollup in the background, set the Background processing indicator.

For more information on background processing for rollups, see Defining Background Jobs for Rollup Execution.

If you want the option of reversing the rollup after it has been executed, set the Write line items indicator.

If you set the Write line items indicator, the system writes line items to the line item database. If you do not plan to reverse the rollup or drill down to rollup line items in a report created for the rollup ledger (or if you are rolling up large quantities of data), you should leave the Write line items indicator blank to avoid unnecessary database updates and increased runtime.

Enter the document type for the rollup, if line items should be created for the rollup. The document type groups together documents that are processed in the same way.

If you want new rollup data to be added to existing rollup data in the rollup ledger, set the Accumulate values indicator. If you want new rollup data to overwrite existing rollup data, do not set this indicator.

If you want the system to insert blank records (records with the value zero in their amount fields) in the rollup ledger, set the Write records with amount 0 indicator.

If you want to create a report that shows all accounts in a group of accounts (including accounts that have amounts equal to zero), you must include records that have zero in their amount fields. If blank records are not included in your rollup ledger, then the summary records of those accounts that are equal to zero will not be created or available for reporting.

If you want to eliminate internal business volume within a set hierarchy, set the Elim.of int.bus.vol.frm bus indicator . You can only use this field for hierarchical rollups. Elimination of internal business volume is only possible with dimensions for which a partner dimension has been defined in the master files (for example, SCNTR for SCNTR).

If you have allocated costs between the final cost centers within a cost center area, you can eliminate inter-company business volume.

If you also want to summarize data for sender objects parallel to the receiver object, set the Summarize partner by level indicator. You can only use this indicator if the rollup is a hierarchical rollup.

If you want to output a list containing details on all the records read and created during the rollup execution, set the Detail list indicator.

Processing time could take longer if you are processing a large volume of data and set the Detail list indicator.
  1. You can use the following additional functions in this screen:

    2. Additional Functions (Screen Execute Rollup <Name of Rollup>: Parameter Screen)

    Menu Path

    Function

    Extras ® Export File

    Import data from a sequential file or PC file or export data to a sequential file or PC file.

    Extras ® History

    View the execution history of the rollup.

    Extras ® Delete History

    Delete the execution history information for the rollup.

    Extras ® Document Rollup

    Document the rollup definition and record results of the rollup.

  2. Choose .

Result

A list of the records read and created for the executed rollup appears.