GL Dimension and Dimension Values (v5.0)

Modified on Wed, 20 Sep, 2023 at 9:36 AM

 

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 field 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 5.00.00 is required for the functionality described in this document.


 

 

Table of Contents

 

Setting Up Dimensions and Dimension Values

 

1. Dimension can be accessed from Departments à Financial Management à   Administration Dimensions à Dimensions.


 

2. Select New from the Home Tab of the Ribbon 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 the 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.


Self-balance Dimension:  Indicates if the Dimensions is self-balancing.  See “Self-Balancing Overview” for details on how this field is utilized.  Refer to the GL Dimension Self-Balancing Overview Procedure Document for more information.

4. Once the Dimension Code is defined you can setup Dimension Values. Select which Dimension you would

    like to setup values for and then click on Home à 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 – Place a checkmark in this field to block the Dimension Value so that entries with this Value attached cannot be posted.

Excl. from Budget Enforcement: Place a checkmark in this field if you if you wish to exclude Budget Enforcement from being applied to 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.


 

Related Topics

  1. Account Schedules Overview
  2. Analysis Views
  3. Budget Enforcement Overview
  4. Chart of Accounts Overview
  5. Fund Overview
  6. GL Dimension Combinations
  7. GL Dimension Self-Balancing Overview
  8. Grants Overview

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article