Environment Management Templates

<< Click to display table of contents >>

Environment Management Templates

XML File

Workbook Name

UI Task ID

Location in Default UI

Description

Environment Configuration

BW_ET101.xml

BW_ENVIRONMENT.xlsx

CustomSheet

Admin User > Environment Management

Saving this template enables users to view, for example, the account chart and units in Excel.

Dimension Codes

BW_ST110.xml

BW_DimensionChart.xlsx

CustomSheet

Admin User > Environment Management

Used for adding dimensions and hierarchy settings. For instructions, see Adding Dimensions.

Document Series

BW_ST120.xml

BW_DocumentSeriesMnt.xlsx

CustomSheet

Admin User > Environment Management > Other Parameters

Used for adding document series to the system. See the template for instructions.

Period Start and End Dates

BW_ET114.xml

BW_ET114.xlsx

UI_BW_ET114.xml

Admin User > Turn of the Year

Used for adding the start and end dates for the periods separately for each year. The period dates are used on almost all reports.

Rate Difference Entries (ARD)

BW_ST125.xml

BW_ARDMnt.xlsx

CustomSheet

Admin User > Environment Management > Automatic Entries

Used for managing automatic rate difference definitions. For instructions, see Automatic Rate Difference Definitions.

Calculated Accounts (ACA)

BW_ST130.xml

BW_ACAMnt.xlsx

CustomSheet

Admin User > Environment Management > Automatic Entries

Used for managing automatic calculated account definitions. For instructions, see Automatic Calculated Account Definitions.

Non-Controlling Interest (NCI)

BW_ST135.xml

BW_NCIMnt.xlsx

CustomSheet

Admin User > Environment Management > Automatic Entries

Used for managing automatic non-controlling interest entry definitions. For instructions, see Automatic NCI Entry Definitions.

Proportional Consolidation (PROC)

BW_ST145.xml

BW_PROCMnt.xlsx

CustomSheet

Admin User > Environment Management > Automatic Entries

Used for managing proportional consolidation definitions. For instructions, see Proportional Consolidation Definitions.

The proportional consolidation definitions contain only the opening balance type accounts for which the target account for change in ownership needs to be defined. For all other accounts not included in these definitions, the default calculation is applied (the calculated entry is recorded to the input account).

Internal Margins in Inventories (INV)

BW_ST140.xml

BW_INVMnt.xlsx

CustomSheet

Admin User > Environment Management > Automatic Entries

Used for managing automatic inventory margin entry definitions. For instructions, see Automatic Inventory Margin Entry Definitions.