GL Dimension and Dimension Values

Purpose of this document

This document covers how to setup Dimensions and Dimension Values. Dimensions and Dimension Values are used to include additional detail in an entry and will flow all the way to the general ledger entry. These fields can then be reported on in financial reporting. Each Dimension can have an unlimited number of Dimension Values that are sub-units of that Dimension. For example, a Dimension called Department can have values of Administration, Agency Services, Operations, etc.

Ceres Object release 6.00.00 is required for the functionality described in this document.

TABLE OF CONTENTS

• Setting Up Dimensions and Dimension Values

Setting Up Dimensions and Dimension Values

1. Dimensions can be accessed by selecting “Search” from the Dynamics 365 Business Central Banner and entering “Dimensions” in “Tell me what you want to do” then selecting “Dimensions” from the results in the Go to Pages and Tasks section OR by selecting the “Dimensions” menu action (if present) from your Role Center home page.

2. Select New from the menu options to create a new Dimension.

3. Update the fields, as necessary.

Code: This is the main identifier for the Dimension, which can be entered as any combination of text and numbers.

Name: Enter a name for the Dimension.

Code Caption: Ceres fills this field by copying the Dimension Code you enter in the Code field. However, you can enter your own caption for Dimension. The caption is how this Dimension is presented to the user throughout Ceres. For example, it will show Department instead of Global Dimension 1.

Filter Caption: Ceres fills this field by copying the Dimension Code you enter in the Code field. However, you can enter your own caption for the Dimension filter. The caption is how this Dimension is presented to the user throughout Ceres. For example, it will show Department Filter instead of Global Dimension 1 Filter.

Description: Alternative field that you can use to describe the Dimension.

Blocked: Place a checkmark in this field to block the usage of this Dimension.

4. Once the Dimension Code is defined you can set up Dimension Values. Select which Dimension you would like to setup values for and then click on Dimension à Dimension Values.

5. Select Home à  New to create a new Dimension Value.

6. Update the fields, as necessary.

Code: Unique identifier for the Dimension Value being created.

Name: Enter a name for the Dimension Value.

Dimension Value Type: Identifies the purpose of the Dimension Value. The options are:

Standard - Used for standard posting of Dimension Values.

Heading: - A heading for a group of Dimension Values.

Total - Total is used when you want Ceres to total a series of balances on Dimension Values that do not immediately precede the Total Dimension Value. You can use Total when Dimension Values from several Dimension Value groups should be totaled. If you use the Dimension Value Type Total, the Totaling field must not be left blank.

Begin Total - A marker for the beginning of a series of Dimension Values to be totaled ends with an End-Total Dimension Value Type. The Begin-Total dimension value type can also be posted to in the same way as the dimension value type Standard.

End Total - A total of a series of Dimension Values that starts with the Dimension Value type Begin-Total. The total is defined in the Totaling field.

Totaling - Enter a Dimension Value interval or a list of Dimension Values. Ceres will total the entries for the Dimension Values displayed in the field to give a total balance. The field is completed in different ways, depending on the Dimension Value Type you selected in the Dimension Value Type field:

1. If the dimension value type is Standard, Begin-Total or Heading, the Totaling field must be blank.
2. If the dimension value type is End-Total, the program will automatically fill in the Totaling field when you click Actions, point to Functions, and then click Indent Dimension Values. The dimension values that are totaled are the ones that lie between each pair of Begin-Total and End-Total dimension values.
3. If the dimension value type is Total, you must fill in the Totaling field yourself to indicate which dimension values will be totaled.

Blocked – Check this field to block the Dimension Value so that entries with this Value attached cannot be posted.

Excl. from Budget Enforcement: Check this field if you if you wish to exclude Budget enforcement from any transaction posted to this Dimension. Refer to the Budget Enforcement Overview Procedure Document for more information.

Budget Notification Group: If a Dimension is not “Excl. from Budget Enforcement”, you can specify a Budget Notification Group if you would like warning or failure budget notifications to be sent to a Budget Notification Group other than or in addition to the default Budget Notification Group specified on the G/L Budget. Refer to the Budget Enforcement Overview Procedure Document for more information.

7.  The Dimensions Values can be indented between the Begin-Totals and End-Totals by selecting Actions à Indent Dimension Values.