Update the Model/ Consolidated Field

Purpose

This document provides an overview of the functionality of the Update the Model/Consolidated Field Global Update (R0006QD) including the setup and output of the report.

Scope

This document is intended for Finance Functional users who will be reviewing and modifying the organization and account structures.

Details

Overview of Functionality

If a business unit is a model, all of the accounts in the business unit contain a 'M' in the Model/Consolidated field in the F0901 table. Otherwise, the Model/Consolidated field is blank.

If you change a model business unit to a business unit that is not a model, you must run the Update Model/Consolidated Field program (R0006QD) to update the F0901 table. The system changes theModel/Consolidated field to blank for all of the accounts within the business unit.

Likewise, if you change a business unit that is not a model to a model business unit, you must run the Update Model/Consolidated Field program to update the F0901 table. The system changes the Model/Consolidated field to M for all of the accounts within the business unit.

NOTE: If records exist for the business unit in the F0911 or F0902 table or both, you cannot change a business unit that is not a model to a model business unit The Update Model/Consolidated Field program does not update the Model/Consolidated field in the F0901 table for accounts that belong to a consolidation business unit. Instead, those accounts are updated with a value of C in the Model/Consolidated field by the Refresh Consolidation program (R10862).

Setup

Processing Options

This program does not have any processing options.

Data Selection

It is recommended to run the R0006QD report only for the business units you have modified the Model Accounts and Consolidation Flag.

Reviewing the Report

The report prints a message of "Update is Successful" if it updates F0901 accounts with the correct value of Model Accounts and Consolidation Flag from the Business Unit.

NOTE: For more information on other Global Updates available in General Accounting, you may refer to Global Updates for Organizational and Account Structure Revisions.