Revision as of 11:29, 28 March 2020

Masterdata

Creating Masterdata

With ICM, you can create and use the Masterdata for your Agreements.

To create Masterdata:

1. Click Configuration on My Dashboard.  The Configuration page opens. 

2. Click Masterdata on the Configuration page. The Masterdata page opens. 

3. Click Create Masterdata on the Masterdata page. The Create Masterdata page opens. 

The Create Masterdata page consists of 2 sections:

• Masterdata details

• Attributes

Masterdata Details

The Masterdata details section consists of three fields:

• Category: Select the appropriate category.
• Masterdata: Select the appropriate Masterdata category.
• Masterdata Description: This field facilitates users to select the desired Masterdata Contract Type.

4. Click Next. The Attribute tab opens.

Attributes

On the Attributes tab, you add different attributes to the masterdata:

• Name: Type the name of the masterdata. 
• Effective Date: Select an appropriate effective date.
• Expiry Date: Select an appropriate expiry date.
• Masterdata Code: This is a system generated code.
• Party Address: Type the party address.
• Party Name: Type the party name.
• Company Address: Select an appropriate category from list.
• Select File: Upload the Company Contract Document.
• Company Creation date: Select an appropriate company creation date.
• Company Details: Type appropriate company details.
• Company Email: Type the official company email address.
• Company Phone Number: Select an appropriate category from list.
• Company Profit: Select an appropriate category from list.
• Company Project User: Click the Add User icon. The Select User box opens. Under Select User, select an appropriate project user. Alternatively, in the Search User box, type the name of the desired user, and click the Search icon. Use the scroll arrows Scroll  to scroll through users. Click Add to add the user.
• Company URL: Type the official company URL. In the Link Text box, type free text.
• Contract Description: Type a description for the Contract. This field helps users to select the desired Contract Type.
• Contract Value: Select an appropriate category and then select appropriate currency from the Select Currency list.

6. Click Save. If the approval workflow is enabled in the Masterdata contract type for this instance, then after saving the Attributes page, Masterdata details page opens.

7. Click Team in the left pane.

8. After you click Team it will display the rule based Approvers for this instance. Now click Send For Approval to send it further for the approval.

9. In case approval workflow is not enabled for this instance, it will simply create the Masterdata.

You can apply multiple filters while referencing values from any master records. You can predefine filters or apply them based on the attribute values for the selected attributes while entering the details. 
Users can now:
•    Define UI based configuration for multiple static and dynamic filters for the referred masterdata 
•    Filter masterdata records directly in the drop-downs as well as the popup, based on the predefined configured static filters while working with agreements/amendments
•    Filter masterdata records directly in the drop-downs as well as the popup, based on the predefined dynamic filters as the user keys in the values for the selected attributes marked as filters while working with agreements/amendments
Section 1.01    Configuring Static and Dynamic filters on Masterdata records
To configure static filters:
Let us consider an example where Automation Country Master is a Masterdata Contract Type having attributes such as Country Name, Country Name String, Identifier Attribute and Name for Cascade and Lookup. We are configuring a static filter where Country Name String attribute must not contain the country West Indies.
1.    Click the Add Filter Configuration icon. The Filter Configuration window opens for the master record Automation Country Master.
Note: The Add Filter Configuration icon is enabled only when the user selects a master record Contract Type.
 
2.    Toggle On for the Is Mandatory field. 
Note: Is Mandatory toggle On indicates that filter cannot be removed. 
3.    Select Must Not from the Operator Type drop-down list. The Country Name String attribute must not contain the country West Indies.
Note: The Must/Must Not operator type sets the binding condition on the Attributes values. 
4.    Select Country Name String from the Attributes drop-down list. 
5.    The Country Name String attribute displays the names of countries. 
6.    Select the checkbox for the country. For example, the West Indies.

 
7.    Click Apply to view the output on the right side of the filter.
8.    Click Save. The Attribute updated successfully window opens.
 
9.    Enter the details in the remaining Association, Display Preference, Team, and Verify tabs to publish the Contract Type. Alternatively, you can edit an already existing Contract Type to add the filter to its existing attribute.
A Static filter is configured on Masterdata record where Country Name String attribute must not contain the country West Indies.

To Configure Dynamic filters on Masterdata records:
1.    Click the Add Filter Configuration icon. The Filter Configuration window opens for the master record Automation Country Master.
 
2.    Toggle On for the Is Dynamic field. 
Note: Is Dynamic toggle On indicates that the filter is a dynamic filter. 
3.    Select Must from the Operator Type drop-down list. 
Note: The Must/Must Not operator type sets the binding condition on the Attributes values. 
4.    Select Country Name String from the Contract Type Attribute drop-down list. 
5.    Select Country Name from the Linked To drop-down list. 
Note: The Contract Type Attribute drop-down list displays the attributes of Agreement Contract Type (Country Name String). The Linked To drop-down list displays the attributes of Masterdata Contract Type (Country Name).  Thus, Country Name String attribute value is dynamically linked to the attribute value of Country Name. 
 
 
6.    Click Apply.
7.    Click Save. The Attribute updated successfully window opens.
 
8.    Enter the details in the remaining Association, Display Preference, Team, and Verify tabs to publish the Contract Type. Alternatively, you can edit an already existing Contract Type to add a filter to its existing attribute.
A Dynamic filter is configured where Country Name String attribute value is dynamically linked to the attribute value of Country Name.
 
Section 1.02    Adding Static Filters at Agreement level on Masterdata records
1.    Click the Agreement Management tile on the Dashboard. The Agreement Management menu opens.
2.    Click the Create Agreement menu. The Create Agreement menu opens.
3.    Select the Contract Type Name. For example, MSA.
4.    Select Type Of Paper as Own.
 
5.    Click Next. The Attributes tab opens. 
6.    Click the Filtered Lookup Search or Add New Record icon in the Country Name String drop-down list.
 
The Country Name String attribute displays all countries except the country West Indies as set in the configured static filter.  
 
The predefined static filter is applied on the masterdata record.
7.    Select the checkbox as per requirement. For example, Indonesia.
8.    Click Select. 
9.    Click Next.
Complete the remaining tabs of Select Template and Verify to move the Agreement to the Draft state. 

Section 1.03    Adding Dynamic filters at Agreement level on Masterdata records
1.    Click the Agreement Management tile on the Dashboard. The Agreement Management menu opens.
2.    Click the Create Agreement menu. The Create Agreement menu opens.
3.    Select the Contract Type Name. For example, MSA.
4.    Select Type Of Paper as Own.
 
5.    Click Next. The Attributes tab opens. 
6.    Select the country in the Country Name drop-down list. For example, Singapore. 
7.    Click the Filtered Lookup Search or Add New Record icon in the Country Name String drop-down list to select the country. For example, Singapore.
 
The Country Name String attribute displays all countries except the country Singapore which is filtered dynamically based on the Country Name attribute value. This is as per the configuration where Country Name String attribute value is dynamically linked to the attribute value of Country Name.
 
 
8.    Select the checkbox. For example, Indiana.
9.    Click Select. 
10.    Click Next.
Complete the remaining tabs of Select Template and Verify to move the Agreement to the Draft state. 

Editing Masterdata

In ICM, you can create and edit Masterdata for your Agreements. You can edit the Masterdata to update any information which was either not provided or was not correct. 

To edit the Masterdata:

1. Click Configuration tile on My Dashboard. The Configuration page opens.

2. Click Masterdata tile. The Masterdata page opens. 

3. Click View  icon next to the Masterdata that you want to edit.The Masterdata Details page opens.

4. Click Edit. The Edit Masterdata page opens.

5. Edit the required information and click Update.

6. Click Deactivate on Masterdata Details page to deactivate the Masterdata. The deactivated Masterdata cannot be used for future transactions, though it remains searchable and visible in the Masterdata list.
When you click Update, the modifications will be saved.

Searching Masterdata

To search the masterdata:

1. Click Configuration tile on My Dashboard. The Configuration page opens.

2. Click Masterdata on Configurations page. The Masterdata page opens.

3. Under Search For, click Select Field list.

4. Select an appropriate field from the list. The number in the bracket denotes the number of masterdata records that meet the search criteria. You can also select multiple options.To narrow down your search, enter free text in the Custom Keyword text box, and then click Apply.

5. Alternatively, type keywords in the search box provided above the list of existing masterdata records. A list of relevant master data records is displayed.

You can enhance your search by using any of the following methods:

You can also view your saved search terms. In the More Searches box, select your saved search, and click the Add to Favorites icon to mark the search term as favorite.
You can find your marked favorites below the tiles.

Related Topics: Agreement Management |  Configuration