Configure Adjustment s

The Data Adjustment Module provides capabilities to define templates that can be used for Adjustments. The entities on templates that can be defined refer to the Stage instrument tables of OFS Data Foundation Applications. The templates are used by a Balance Reconciliation to define default values for various attributes for the Instrument Tables. While posting adjustments, Data Adjustment Modules apply the defaults for the adjustments created by the Balance Reconciliation.

Topic:

·         Adjustments Summary Page

·        Search Adjustment Rule

·        Add Adjustment Rule

·        Update Adjustment Rule

Adjustments Summary Page

The Adjustments Summary Window displays all the Adjustment Templates defined for various entities. When you first navigate to the page, the Adjustment entries associated with the first dimension are presented in a Summary List. This page is the gateway to all Adjustment Rules and related functionality. You can navigate to other pages relating to Adjustment Rule from this page. You can use search criteria to search for an Adjustment Entry.

1.     The Adjustment Summary presents a list containing all of the Adjustment Entries that meet your search criteria. This list also offers several icons that allow you to perform different functions when an Adjustment Entry is selected. The following icons are:

§       Add : Click the Add icon, to add the Adjustment Entry and its parameters that are further displayed on the Adjustment Entry Summary Window.

§        Delete : Click the Delete icon, to delete the Adjustment Entry from the list.

 

Search Adjustment Rule

Prerequisites

Predefined Adjustment Rule

Procedure

To search the Adjustment rule, follow these steps:

1.     Navigate to the Adjustment Summary Page.

2.     Enter the Search criteria. Among other properties, each Adjustment Entry consists of a Run Execution ID, a GL Date, and a Definition. You may search on any of these properties in the Search Pane.

Add Adjustment Rule

To add an Adjustment Rule, follow these steps:

1.     Navigate to the Adjustment Summary Page.

2.     Click Add. The Adjustment Add Page is displayed.

3.     Enter Adjustment Rule and Description.

1.     Select the Entity Attribute that you want to define for the selected Adjustment Entity. You can also search the Entity Attributes from the search filter.

2.     Add the Expression for the selected attribute.

 For example:

¾      VARCHAR: ‘NAME’

¾      NUMBER: ‘12345’

¾      DATE: to_date(‘12/31/2020’,’mm/dd/yyyy’)

 

3.     Click the Save Expression button.

Update Adjustment Rule

To update the Adjustment Rule, follow these steps:

1.     Navigate to the Adjustment Summary Page.

2.      Click the Adjustment Rule link.

3.     Edit the details and click Update.