From ICIHelp8.2
Jump to: navigation, search
 
(11 intermediate revisions by 2 users not shown)
Line 11: Line 11:
 
To view available Attributes:
 
To view available Attributes:
  
1.&nbsp;'''Click''' ''Home >&nbsp;''''Configuration'''''<b>. The ''Atrributes''&nbsp;page opens. On this page you can view a list of all the available attributes, Edit, or Add Attributes.</b>
+
1.&nbsp;'''Click''' &nbsp;Configure&nbsp;> Attribute&nbsp;'''. '''The Atrributes&nbsp;page opens'''. '''On this page you can view a list of all the available attributes, Edit, or Add Attributes.
<div class="image-green-border">[[File:Attribute Page.PNG|720px|RTENOTITLE]]</div>  
+
<div class="image-green-border">[[File:Picture41.png|600px|Picture41.png]]</div>  
 +
&nbsp;
 +
 
 
== Adding and Editing an Attribute ==
 
== Adding and Editing an Attribute ==
  
Line 19: Line 21:
 
To create an attribute:
 
To create an attribute:
  
1. '''Click''' ''Configuration''&nbsp;on ''My Dashboard''. The ''Configuration&nbsp;''page opens.&nbsp;
+
1. On Home Page,&nbsp;'''Click''' Configure > Attribute. TheAttribute page opens.&nbsp;
 
+
2.&nbsp;'''Click'''&nbsp;the&nbsp;''Attribute ''tile.
+
  
3.&nbsp;'''Click'''&nbsp;the&nbsp;''Add ''icon on the ''Attribute'' Library page. The ''Add Attribute'' page opens. The Attribute Code is displayed by default.
+
2.&nbsp;'''Click'''&nbsp;the New Attribute&nbsp;on the Attribute Library page. The Add Attribute page opens. The Attribute Code is displayed by default.
<div class="image-green-border">[[File:Add Attribute.jpg|720px|RTENOTITLE]]</div>  
+
<div class="image-green-border">[[File:Picture42.png|550px|Picture42.png]]</div>  
 
*Display Name:&nbsp;'''Type&nbsp;'''the appropriate name of the attribute. For example, corporate office.&nbsp;  
 
*Display Name:&nbsp;'''Type&nbsp;'''the appropriate name of the attribute. For example, corporate office.&nbsp;  
 
*Data Type list:&nbsp;'''Select&nbsp;'''the appropriate option from the list.&nbsp;Additional related fields are displayed based on the selected Data Type option. For example, when the data type is selected as Number, the related Total Length and Number of Decimals fields are displayed.&nbsp;When the data type is selected as Choice, the option to select the UI Control Type between Dropdown and Radio buttons is displayed. When the data type is selected as MultiSelectChoice, the option to select the UI Control Type between Dropdown and Checkbox is displayed. The selected user control will be rendered on browser.The page length will increase as the number of options in Radio button/Checkbox list increase. Hence, it’s recommended to select Radio button or Check box list when the options are less than eight, else select the Dropdown if there are more options.  
 
*Data Type list:&nbsp;'''Select&nbsp;'''the appropriate option from the list.&nbsp;Additional related fields are displayed based on the selected Data Type option. For example, when the data type is selected as Number, the related Total Length and Number of Decimals fields are displayed.&nbsp;When the data type is selected as Choice, the option to select the UI Control Type between Dropdown and Radio buttons is displayed. When the data type is selected as MultiSelectChoice, the option to select the UI Control Type between Dropdown and Checkbox is displayed. The selected user control will be rendered on browser.The page length will increase as the number of options in Radio button/Checkbox list increase. Hence, it’s recommended to select Radio button or Check box list when the options are less than eight, else select the Dropdown if there are more options.  
 +
<div class="image-green-border">[[File:Picture43.png|550px|Picture43.png]]</div>
 
*Help Message:&nbsp;'''Type&nbsp;'''the appropriate help message of the attribute. For example, enter the address of the corporate office.&nbsp;  
 
*Help Message:&nbsp;'''Type&nbsp;'''the appropriate help message of the attribute. For example, enter the address of the corporate office.&nbsp;  
 
*Source List:&nbsp;'''Select&nbsp;'''from the following:&nbsp;  
 
*Source List:&nbsp;'''Select&nbsp;'''from the following:&nbsp;  
Line 33: Line 34:
 
**Script&nbsp;   
 
**Script&nbsp;   
  
For example,&nbsp;'''select&nbsp;'''''Integrated&nbsp;''if source is inherited.&nbsp;
+
For example,&nbsp;'''select&nbsp;'''Integrated&nbsp;if source is inherited.&nbsp;
<div class="note-box">'''Note''': If you select the source as Integrated: ''Is Editable, Is Mandatory, Defined By Rule, Is Inherit ''and''Is Conditional'' fields become unavailable.&nbsp;</div>  
+
<div class="note-box">'''Note''': If you select the source as Integrated: Is Editable, Is Mandatory, Defined By Rule, Is Inherit andIs Conditional fields become unavailable.&nbsp;</div>  
 
*Default Value:&nbsp;'''Type'''&nbsp;the default value of the attribute. The value that you type will be displayed on creating a&nbsp;new agreement.  
 
*Default Value:&nbsp;'''Type'''&nbsp;the default value of the attribute. The value that you type will be displayed on creating a&nbsp;new agreement.  
*Is Default:&nbsp;'''Click'''&nbsp;''On''&nbsp;to enable rules to be set on the attribute.  
+
*Is Default:&nbsp;'''Click'''&nbsp;On&nbsp;to enable rules to be set on the attribute.  
*Is Editable:&nbsp;'''Click'''&nbsp;''On''&nbsp;to make the attribute editable in the Agreement, else&nbsp;'''select'''&nbsp;''Off''.  
+
*Is Editable:&nbsp;'''Click'''&nbsp;On&nbsp;to make the attribute editable in the Agreement, else&nbsp;'''select'''&nbsp;Off.  
<div class="note-box">&nbsp;'''Note''':&nbsp;If you select&nbsp;''On''&nbsp;in the&nbsp;''Is Editable&nbsp;''field''', '''the&nbsp;''Tracking Attribute''&nbsp;and the&nbsp;''Is Unique''&nbsp;fields are available.</div>  
+
<div class="note-box">&nbsp;'''Note''':&nbsp;If you select&nbsp;On&nbsp;in the&nbsp;Is Editable&nbsp;field''', '''the&nbsp;Tracking Attribute&nbsp;and the&nbsp;Is Unique&nbsp;fields are available.</div>  
*Is Mandatory:&nbsp;'''Click'''&nbsp;''On''&nbsp;to make the attribute mandatory.  
+
*Is Mandatory:&nbsp;'''Click'''&nbsp;On&nbsp;to make the attribute mandatory.  
*Tracking Attribute:&nbsp;'''Click&nbsp;'''''On''&nbsp;to make the attribute editable throughout the Agreement lifecycle.  
+
*Tracking Attribute:&nbsp;'''Click&nbsp;'''On&nbsp;to make the attribute editable throughout the Agreement lifecycle.  
*Is Unique:&nbsp;'''Click'''&nbsp;''On''&nbsp;to make the attribute unique for a Contract Type.  
+
*Is Unique:&nbsp;'''Click'''&nbsp;On&nbsp;to make the attribute unique for a Contract Type.  
*Defined by Rule:&nbsp;'''Click'''&nbsp;''On''&nbsp;to make the attribute editable throughout the Agreement lifecycle.  
+
*Defined by Rule:&nbsp;'''Click'''&nbsp;On&nbsp;to make the attribute editable throughout the Agreement lifecycle.  
*Is Inherit:&nbsp;'''Click'''&nbsp;''On''&nbsp;if you want the attribute to inherit the data from Associated Documents.  
+
*Is Inherit:&nbsp;'''Click'''&nbsp;On&nbsp;if you want the attribute to inherit the data from Associated Documents.  
*Is Searchable:&nbsp;'''Click'''&nbsp;''On''&nbsp;to make the attribute easy to search.  
+
*Is Searchable:&nbsp;'''Click'''&nbsp;On&nbsp;to make the attribute easy to search.  
*Is Supersedable:&nbsp;'''Click&nbsp;'''''On&nbsp;''to make the updated or amended attribute supersede the earlier one.&nbsp;  
+
*Is Supersedable:&nbsp;'''Click&nbsp;'''On&nbsp;to make the updated or amended attribute supersede the earlier one.&nbsp;  
*Is Conditional:&nbsp;'''Click'''&nbsp;''On''&nbsp;to make the attribute dependent on another attribute. The ''Conditional ''section opens. In the&nbsp;''Depend on Attribute''&nbsp;list, select the attribute on which the new attribute is dependent. In the&nbsp;''Depends On Value''&nbsp;box, type the value of the selected attribute.&nbsp;'''Select '''the values from the ''Depends on Value ''field which are automatically fetched based on the attribute selected in ''Depends On Attribute'' field, if the data type of that attribute is Lookup, Choice, MultiChoice, or Boolean.  
+
*Is Conditional:&nbsp;'''Click'''&nbsp;On&nbsp;to make the attribute dependent on another attribute. The Conditional section opens. In the&nbsp;Depend on Attribute&nbsp;list, select the attribute on which the new attribute is dependent. In the&nbsp;Depends On Value&nbsp;box, type the value of the selected attribute.&nbsp;'''Select '''the values from the Depends on Value field which are automatically fetched based on the attribute selected in Depends On Attribute field, if the data type of that attribute is Lookup, Choice, MultiChoice, or Boolean.  
<div class="image-green-border">[[File:SP7 Conditional Attributes & Rules 1.png|720px|SP7 Conditional Attributes & Rules 1]]</div>  
+
<div class="image-green-border">[[File:Picture44.png|550px|Picture44.png]]</div> <div class="image-green-border">&nbsp;</div>  
&nbsp;
+
4. '''Click''' Save. The attribute&nbsp;is displayed in the Available Attribute list.
<div class="image-green-border">[[File:SP7 Conditional Attributes & Rules 2.png|720px|SP7 Conditional Attributes & Rules 2]]</div>  
+
<div class="image-green-border">[[File:Picture45.png|600px|Picture45.png]]<br/> &nbsp;</div>  
4. '''Click''' ''Save''. The attribute&nbsp;is displayed in the ''Available Attribute'' list.
+
<div class="image-green-border">[[File:AttributeCreationSuccessful.jpg|720px|RTENOTITLE]]<br/> &nbsp;</div>  
+
 
=== Editing an Attribute ===
 
=== Editing an Attribute ===
  
 
In ICI, you can edit an existing attribute. Editing the attribute doesn't have any effect on the Contract Types where it is used.<br/> You can use the edited attribute to create new contract types. &nbsp;
 
In ICI, you can edit an existing attribute. Editing the attribute doesn't have any effect on the Contract Types where it is used.<br/> You can use the edited attribute to create new contract types. &nbsp;
  
'''Note:&nbsp;'''To edit an attribute in all the entities where it is used (Clauses, Templates, Agreements), go to the ''Attributes''&nbsp;tab of appropriate Contract Type, edit the attribute, and then publish it.
+
'''Note:&nbsp;'''To edit an attribute in all the entities where it is used (Clauses, Templates, Agreements), go to the Attributes&nbsp;tab of appropriate Contract Type, edit the attribute, and then publish it.
  
 
To edit an attribute:
 
To edit an attribute:
  
1.'''Click''' ''Configuration&nbsp;''on&nbsp;My Dashboard. The ''Configuration'' page opens.
+
1.'''Click''' Configuration&nbsp;on the Home page. The Configuration page opens.
  
2. '''Click''' ''Attribute&nbsp;&nbsp;''on the ''Configuration'' page. In the ''Available Attribute'' list, select an attribute that you want to edit.
+
2. '''Click''' Attribute&nbsp;&nbsp;on the Configuration page. In the Available Attribute list, select an attribute that you want to edit.
  
Alternatively, you can type the name of the attribute in the ''Search'' box, and then '''select''' the attribute. The ''Edit Attribute'' page opens.
+
Alternatively, you can type the name of the attribute in the Search box, and then '''select''' the attribute. The Edit Attribute page opens.
  
3. Modify the existing information as required, and then '''click''' ''Save''. The ''Success! Attribute updated successfully''&nbsp;message is displayed at the bottom of the page. You can modify all the field values except attribute code and attribute name.
+
3. Modify the existing information as required, and then '''click''' Save. The Success! Attribute updated successfully&nbsp;message is displayed at the bottom of the page. You can modify all the field values except attribute code and attribute name.
  
 +
&nbsp;
  
 +
=== Configuring File Section Attribute as read-only ===
  
 +
In ICI, you can upload a document file using the file selection attribute type. ICI provides an option to disable the user defined file selection attribute at the contract type level thereby preventing unintentional or intentional tampering with the document.
 +
 +
Configurators can configure a user defined file selection attribute as editable or non-editable on ICI User Interface. Business users cannot edit the uploaded documents but can still preview and download these read-only documents. This configuration can be done at attribute, agreement, amendment, association, masterdata and contract request contract types, extended entity attributes, extension attributes, and template variables level. This read-only setting for file selection attribute is also supported in Icertis Experience for Word and Bulk Actions.
 +
<div class="note-box">'''Note:''' All file selection attributes are editable by default.</div>
 +
System can still attach a file through a read-only file selection attribute through backend tasks or API integrations. However, users would not be able to replace or remove such original files from UI which are attached through backend task/integration.
  
 
== Arithmetic Operations and Logical Validations on Attributes ==
 
== Arithmetic Operations and Logical Validations on Attributes ==
Line 79: Line 85:
 
To configure arithmetic calculations and logical validations for attributes at the contract type level (agreement, contract request, association and masterdata):
 
To configure arithmetic calculations and logical validations for attributes at the contract type level (agreement, contract request, association and masterdata):
  
1.&nbsp;'''Click&nbsp;'''the&nbsp;''Configuration&nbsp;''tile on the Dashboard. The&nbsp;''Configuration&nbsp;''page opens.&nbsp;
+
1.&nbsp;'''Click&nbsp;'''the&nbsp;Configure&nbsp;> Contract Types&nbsp;on the Home page.&nbsp;The&nbsp;&nbsp;Contract Type&nbsp;page opens.&nbsp;
<div class="image-green-border">[[File:7.10 Arithmatic 1.png|720px|7.10 Arithmatic 1.png]]</div>
+
<div class="image-green-border">[[File:Picture46.png|600px|Picture46.png]]</div>  
2.&nbsp;'''Click&nbsp;'''''Create Contract Type&nbsp;''tile. The&nbsp;''Create Contract Type&nbsp;''page opens.&nbsp;
+
3.&nbsp;'''Select&nbsp;'''the Contract Type you want to create. For example, AGREEMENT.
<div class="image-green-border">[[File:7.10 Arithmatic 2.png|360px|7.10 Arithmatic 2.png]]</div>  
+
<div class="image-green-border">[[File:Picture47.png|600px|Picture47.png]]</div>  
3.&nbsp;'''Select&nbsp;'''the agreement contract type you want to create.&nbsp;
+
4.&nbsp;'''Click&nbsp;'''Next.&nbsp;The&nbsp;Create Contract Type&nbsp;page opens.&nbsp;<br/> 5.&nbsp;'''Enter&nbsp;'''a name in the&nbsp;Contract Type Name&nbsp;field.&nbsp;<br/> 6.&nbsp;'''Enter&nbsp;'''all the details on the&nbsp;Details&nbsp;tab.&nbsp;<br/> 7.&nbsp;'''Click&nbsp;'''Next.&nbsp;The&nbsp;Attributes&nbsp;tab opens.&nbsp;
<div class="image-green-border">[[File:7.10 Arithmatic 3.png|720px|7.10 Arithmatic 3.png]]</div>  
+
<div class="note-box">'''Note''':&nbsp;The arithmetic calculations are supported for attributes like Currency, Date, Number and Percentage data types.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Picture48.png|550px|Picture48.png]]</div>  
4.&nbsp;'''Click&nbsp;'''''Next.&nbsp;''The&nbsp;''Create Contract Type&nbsp;''page opens.&nbsp;<br/> 5.&nbsp;'''Enter&nbsp;'''a name in the&nbsp;''Contract Type Name&nbsp;''field.&nbsp;<br/> 6.&nbsp;'''Enter&nbsp;'''all the details on the&nbsp;''Details&nbsp;''tab.&nbsp;<br/> 7.&nbsp;'''Click&nbsp;'''''Next.&nbsp;''The&nbsp;''Attributes&nbsp;''tab opens.&nbsp;
+
For example, if you want to calculate the Total Price of a commodity, you need to multiply the attribute values in the fields Product Price and No Of Units. You can also set validation messages on its outcome so that the Total Price value must be greater than 100.
<div class="note-box">'''Note''':&nbsp;The arithmetic calculations are supported for attributes like Currency, Date, Number and Percentage data types.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:7.10 Arithmatic 4.png|720px|7.10 Arithmatic 4.png]]</div>  
+
For example, if you want to calculate the ''Total Price'' of a commodity, you need to multiply the attribute values in the fields ''Product Price'' and ''No Of Units''. You can also set validation messages on its outcome so that the ''Total Price'' value must be greater than 100.
+
  
8.&nbsp;'''Select '''the attribute ''Total Price ''from the ''Available Attribute ''list and move it to the ''Selected Attribute'' list.<br/> 9.&nbsp;'''Toggle''' the ''Enable Expressions'' flag ''On'' for the attribute Total Price. The ''Expressions'' tab opens.&nbsp;
+
8.&nbsp;'''Select '''the attribute Total Price from the Available Attribute list and move it to the Selected Attribute list.<br/> 9.&nbsp;'''Toggle''' the Enable Expressions flag On for the attribute Total Price. The Expressions tab opens.&nbsp;
  
Calculations are performed through the default expression field denoted as ''EXPR1''.&nbsp;
+
Calculations are performed through the default expression field denoted as EXPR1.&nbsp;
 +
<div class="note-box">'''Note''': The Expression field&nbsp;cannot be removed. The new expression can be added or removed by NEW ROW and REMOVE ROW buttons. Each expression such as EXPR1, EXPR2, EXPR3, and so on contains Function and Parameters fields. Based on arithmetic and logical operators selected through the Function field, parameters are set in the Parameters field.</div>
 +
The available functions include Constants (NUMBER, BOOLEAN, DATE, STRING), Arithmetic operations (ADD, SUBSTRACT, MULTIPLY, DEVIDE, PERCENT), Date operations (such as DATE ADD, DATE DIFFERENCE), Logical operations (such as GREATER THAN, LESS THAN, EQUALS, ALL, ANY, NOT) and String operations (CONTAINS, IN, STARTS WITH, HAS VALUE).
  
'''Note''': The ''Expression'' field&nbsp;cannot be removed. The new expression can be added or removed by ''NEW ROW'' and ''REMOVE ROW'' buttons. Each expression such as ''EXPR1, EXPR2, EXPR3, ''and so on contains ''Function ''and ''Parameters ''fields. Based on arithmetic and logical operators selected through the ''Function ''field, parameters are set in the ''Parameters ''field.
+
10. '''Select''' an expression (for example, MULTIPLY) from the Function drop-down of EXPR1.&nbsp;<br/> 11.&nbsp;'''Select''' Product Price and No Of Units from the Parameters field to multiply product price and no of units attribute values to get the total price.<br/> 12.&nbsp;'''Click''' NEW ROW to add a new expression. For example, EXPR2 and EXPR3.<br/> 13.&nbsp;'''Select''' a Function CONSTANT (NUMBER, BOOLEAN, DATE, and STRING) from the Function drop-down of EXPR2 if you want that to be a constant value.<br/> 14.&nbsp;'''Enter''' a value (for example, 100) in the Parameters field to set the value of Total Price. A validation message will be displayed if this value is greater than the total price.<br/> 15. '''Select''' another function (GREATER THAN) from the Function drop-down of EXPR3.<br/> 16.&nbsp;'''Select''' Total Price and EXPR2 in the Parameters drop-down of EXPR3.<br/> The Result Expression field is used to reflect the result of the selected expression field (EXPR1, EXPR2, EXPR3, and so on).&nbsp;
 
+
The available functions include Constants (NUMBER, BOOLEAN, DATE, STRING), Arithmetic operations (ADD, SUBSTRACT, MULTIPLY, DEVIDE, PERCENT), Date operations (such as DATE ADD, DATE DIFFERENCE), Logical operations (such as GREATER THAN, LESS THAN, EQUALS, ALL, ANY, NOT) and String operations (CONTAINS, IN, STARTS WITH, HAS VALUE).
+
  
10. '''Select''' an expression (for example, ''MULTIPLY'') from the ''Function'' drop-down of ''EXPR1''.&nbsp;<br/> 11.&nbsp;'''Select''' ''Product Price'' and ''No Of Units'' from the Parameters field to multiply product price and no of units attribute values to get the total price.<br/> 12.&nbsp;'''Click''' ''NEW ROW'' to add a new expression. For example, ''EXPR2 ''and ''EXPR3''.<br/> 13.&nbsp;'''Select''' a ''Function CONSTANT'' (''NUMBER'', ''BOOLEAN'', ''DATE'', and ''STRING'') from the ''Function'' drop-down of ''EXPR2'' if you want that to be a constant value.<br/> 14.&nbsp;'''Enter''' a value (for example, 100) in the Parameters field to set the value of ''Total Price''. A validation message will be displayed if this value is greater than the total price.<br/> 15. '''Select''' another function (''GREATER THAN'') from the ''Function ''drop-down of ''EXPR3''.<br/> 16.&nbsp;'''Select''' ''Total Price'' and ''EXPR2 ''in the ''Parameters ''drop-down of ''EXPR3''.<br/> The ''Result Expression'' field is used to reflect the result of the selected expression field (''EXPR1, EXPR2, EXPR3,'' and so on).&nbsp;
+
==== Configuring the validation message for an attribute: ====
  
The ''Validate Expression'' field is used to validate the evaluation based on the selected expression (''EXPR1, EXPR2, EXPR3,'' and so on). The ''Validate Message'' field is linked to the ''Validate Expression'' field and triggers a user-entered message in case of an invalid expression.
+
The Validate Expression field is used to validate the evaluation based on the selected expression (EXPR1, EXPR2, EXPR3, and so on). The Validate Message field is linked to the Validate Expression field and triggers a user-entered message in case of an invalid expression.
<div class="image-green-border">17.&nbsp;'''Select''' ''EXPR1 ''in the Result Expression drop-down.<br/> 18.&nbsp;'''Select''' ''EXPR3'' in the Validate Expression drop-down.<br/> 19.&nbsp;'''Enter''' ''Total price'' ''must be greater than 100'' in the ''Validate Message ''field.<br/> <br/> [[File:7.10 Arithmatic 5.png|720px|7.10 Arithmatic 5.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">You can set a ''Visibility Expression'' for displaying an attributes dynamically on ICI UI instance, based on business conditions. For example, attribute ''Cost Surcharge Percentage'' can be displayed when the calculated ''Total Price'' is less than ''100.00''.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">20. '''Click '''Add on the Attribute page. The Add Attribute section opens.<br/> 21. '''Enter '''Display Name. For example, Cost Surcharge Percentage.<br/> 22. '''Enter '''details for the attribute.<br/> 23. '''Toggle '''the Enable Expressions to On. The Expressions section opens.<br/> 24. '''Set '''the EXPR1 and EXPR2 same as attribute Total Price.<br/> 25. '''Click '''NEW ROW to add a new expression. For example, EXPR3. Here you can set the condition for attribute’s visibility.&nbsp;<br/> 26. '''Select '''a Function. For example, LESS THAN.<br/> 27. '''Select '''Parameters. For example, Total Price and EXPR2.<br/> 28. '''Select '''EXPR3 in the Visibility Expression drop-down. The attribute Cost Surcharge Percentage will be displayed on UI only upon satisfying conditions for EXPR3.<br/> &nbsp;</div>  
+
<div class="image-green-border">17.&nbsp;'''Select''' EXPR1 in the Result Expression drop-down.<br/> 18.&nbsp;'''Select''' EXPR3 in the Validate Expression drop-down.<br/> 19.&nbsp;'''Enter''' Total price must be greater than 100 in the Validate Message field.<br/> <br/> [[File:Picture49.png|600px|Picture49.png]]</div>  
 
&nbsp;
 
&nbsp;
<div class="image-green-border">screen 1</div> <div class="image-green-border"><div class="note-box">'''Note:''' In case of ''String'' ''Function-'' ''IN'', the first ''Parameters'' drop-down will display only multi-select choice attributes from the current contract type and users can select multiple attributes in a second dropdown to configure the expression.</div> </div>
 
20. '''Click''' Save.
 
<div class="note-box">Note: Arithmetic calculations, logical validations and visibility expressions for attribute values are supported at the following contract type levels: agreement, contract request, associated document, and masterdata.</div>
 
<br/> 21. '''Enter '''the details in the Association, Display Preference and Team tabs.<br/> 22. '''Verify '''the details and click Create.<br/> 22. '''Publish '''and Approve the Contract Type following standard ICI workflows.
 
<div class="image-green-border"><br/> <br/> [[File:7.10 Arithmatic 6.png|720px|7.10 Arithmatic 6.png]]</div>
 
  
 +
==== Configuring the visibility conditions for an attribute: ====
  
 +
You can set a Visibility Expression for displaying an attributes dynamically on ICI UI instance, based on business conditions. For example, attribute Cost Surcharge Percentage can be displayed when the calculated Total Price is less than 100.00.
 +
<div class="image-green-border">&nbsp;</div> <div class="image-green-border">20. '''Click '''Add on the Attribute page. The Add Attribute section opens.<br/> 21. '''Enter '''Display Name. For example, Cost Surcharge Percentage.<br/> 22. '''Enter '''details for the attribute.<br/> 23. '''Toggle '''the Enable Expressions to On. The Expressions section opens.<br/> 24. '''Set '''the EXPR1 and EXPR2 same as attribute Total Price.<br/> 25. '''Click '''NEW ROW to add a new expression. For example, EXPR3. Here you can set the condition for attribute’s visibility.&nbsp;<br/> 26. '''Select '''a Function. For example, LESS THAN.<br/> 27. '''Select '''Parameters. For example, Total Price and EXPR2.<br/> 28. '''Select '''EXPR3 in the Visibility Expression drop-down. The attribute Cost Surcharge Percentage will be displayed on UI only upon satisfying conditions for EXPR3.<br/> &nbsp;</div> <div class="image-green-border">[[File:Picture 50.png|500px|Picture 50.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border"><div class="note-box">'''Note:''' In case of String Function- IN, the first Parameters drop-down will display only multi-select choice attributes from the current contract type and users can select multiple attributes in a second dropdown to configure the expression.</div> </div>
 +
29. '''Click''' Save.
 +
<div class="note-box">Note: Arithmetic calculations, logical validations and visibility expressions for attribute values are supported at the following contract type levels: agreement, contract request, associated document, and masterdata.</div>
 +
30. '''Enter '''the details in the Association, Display Preference and Team tabs.<br/> 31. '''Verify '''the details and click Create.<br/> 32. '''Publish '''and Approve the Contract Type following standard ICI workflows.
 +
<div class="image-green-border">&nbsp;</div>
 
== Arithmetic Operations Evaluation at Agreement level ==
 
== Arithmetic Operations Evaluation at Agreement level ==
  
The attributes will be displayed on the ICI UI instance as per the configured ''Enabled Expressions'' while creating an agreement, contract request, associated document, and masterdata contract type instances.
+
The attributes will be displayed on the ICI UI instance as per the configured Enabled Expressions while creating an agreement, contract request, associated document, and masterdata contract type instances.
  
 
To create agreement contact type instance:
 
To create agreement contact type instance:
  
1. '''Click''' the ''Agreement Management'' tile on the ''Dashboard''. The ''Agreement Management'' page opens.&nbsp;<br/> 2. '''Click''' the ''Create Agreement'' tab. The ''Create Agreement'' page opens.<br/> 3.&nbsp;'''Enter '''all the details in the ''Create Agreement'' page.<br/> 4.&nbsp;'''Enter''' a name in the ''Contract Type Name'' field.<br/> 5.&nbsp;'''Select''' ''Own'' in the Type Of Paper drop-down.&nbsp;<br/> 6.&nbsp;'''Click''' ''Next''. The ''Attributes'' tab opens.<br/> 7.&nbsp;'''Enter''' the value in the attribute ''Product Price''. For example, 9.<br/> 8.&nbsp;'''Enter''' the value in the attribute ''No Of Units''. For example, 10. ''Total Price'' is calculated as 90 by multiplying the ''Product Price'' (9) and ''No Of Units'' (10).
+
1. '''Click''' the Agreement tile on the Dashboard. The Agreement Management page opens.&nbsp;<br/> 2. '''Click''' the Create . The Create Agreement page opens.<br/> 3.&nbsp;'''Enter '''all the details in the Create Agreement page.<br/> 4.&nbsp;'''Enter''' a name in the Contract Type Name field.<br/> 5.&nbsp;'''Select''' Own in the Type Of Paper drop-down.&nbsp;<br/> 6.&nbsp;'''Click''' Next. The Attributes tab opens.<br/> 7.&nbsp;'''Enter''' the value in the attribute Product Price. For example, 9.<br/> 8.&nbsp;'''Enter''' the value in the attribute No Of Units. For example, 10. Total Price is calculated as 90 by multiplying the Product Price (9) and No Of Units (10).
<div class="image-green-border">Since the ''Total Price'' is less than 100, a validation message will be displayed indicating that ''Total Price'' must be greater than 100 and the attribute ''Cost Surcharge'' ''Percentage'' is displayed on the UI.<br/> <br/> [[File:7.10 Arithmatic 7.png|720px|7.10 Arithmatic 7.png]]</div>  
+
<div class="image-green-border">[[File:Picture 51.png|600px|Picture 51.png]]<br/> &nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">Since the Total Price is less than 100, a validation message will be displayed indicating that Total Price must be greater than 100 and the attribute Cost Surcharge Percentage is displayed on the UI.</div> <div class="image-green-border"><br/> &nbsp;</div>  
 
=== Configuring Event Rule for Reverse-sync in Word Add-in ===
 
=== Configuring Event Rule for Reverse-sync in Word Add-in ===
  
Line 122: Line 128:
  
 
'''Creating an Event Rule'''
 
'''Creating an Event Rule'''
<div class="image-green-border">1. '''Click''' ''Configuration'' tile on the ''Dashboard''. The ''Attributes'' page opens.<br/> 2.&nbsp;'''Click''' ''Rule''. The ''Rules'' page opens.<br/> 3.&nbsp;'''Click''' ''Create Rule''. The ''Create Rule'' page opens.<br/> <br/> [[File:7.10 Arithmatic 8.png|720px|7.10 Arithmatic 8.png]]</div>  
+
<div class="image-green-border">1. '''Click''' Configure&nbsp;> Rules on the Home Page&nbsp;. The Rules&nbsp; page opens.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Picture 52.png|600px|Picture 52.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">You can see existing list of rules and Crete button.&nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">2. '''Click''' Create to crate a new rule.&nbsp;&nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Picture 53.png|600px|Picture 53.png]]<br/> &nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">The crete Rule page opens.&nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Picture 54.png|550px|Picture 54.png]]</div> <div class="image-green-border"><br/> 4.&nbsp;'''Select''' the Contract Type for which you want to create a rule in the Contract Type list.&nbsp;<br/> 5.&nbsp;'''Enter''' a name of the Rule in the Rule Name field.&nbsp;</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Picture 55.PNG|600px|Picture 55.PNG]]<br/> 6.&nbsp;'''Enter''' a description for the Rule in the Rule Description box.<br/> 7.&nbsp;'''Select''' the Event Rule in the Rule Type drop-down.&nbsp;<br/> 8.&nbsp;'''Select''' an appropriate category in the Event drop-down. For example, Agreement Document Uploaded.&nbsp;<br/> 9.&nbsp;'''Click''' Next. The Build tab opens.<br/> 10.'''Click''' Add Rule in the Builder tab.<br/> 11. '''Select''' And from the Conditions drop-down.&nbsp;<br/> 12.&nbsp;'''Select''' an appropriate attribute value in the S''''elect Valuedrop-down. For example, Created Date.<br/> 13.&nbsp;'''Select'''an appropriate attribute value in the Select Value drop-down. For example, Is After.<br/> 14.&nbsp;'''Enter'''a value in the Enter Value field. For example, 01-Nov-19.<br/> 15.&nbsp;'''Select'''Calculate Expression in the Select Action drop-down in the Actions tab.<br/> 16.&nbsp;'''Click'''Next.&nbsp;<br/> 17.&nbsp;'''Click'''Create.'''</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Picture 56.png|550px|Picture 56.png]]</div>  
4.&nbsp;'''Select''' the ''Contract Type'' for which you want to create a rule in the ''Contract Type'' list. For example, ''Purchase Agreement''.<br/> 5.&nbsp;'''Enter''' a name of the Rule in the ''Rule Name'' field.&nbsp;<br/> 6.&nbsp;'''Enter''' a description for the Rule in the ''Rule Description'' box.<br/> 7.&nbsp;'''Select''' the ''Event Rule'' in the ''Rule Type'' drop-down.&nbsp;<br/> 8.&nbsp;'''Select''' an appropriate category in the ''Event ''drop-down. For example, ''Agreement Document Uploaded''.&nbsp;<br/> 9.&nbsp;'''Click''' ''Next''. The ''Build'' tab opens.<br/> 10.'''Click''' ''Add Rule'' in the ''Builder'' tab.<br/> 11. '''Select''' ''And'' from the ''Conditions'' drop-down.&nbsp;<br/> 12.&nbsp;'''Select''' an appropriate attribute value in the ''S''''elect Value'''''<b>drop-down. For example, ''Created Date''.<br/> 13.&nbsp;</b>Select'''an appropriate attribute value in the ''Select Value'' drop-down. For example, ''Is After''.<br/> 14.&nbsp;'''Enter'''a value in the ''Enter Value'' field. For example, ''01-Nov-19''.<br/> 15.&nbsp;'''Select'''''Calculate Expression'' in the ''Select Action'' drop-down in the Actions tab.<br/> 16.&nbsp;'''Click'''''Next''.&nbsp;<br/> 17.&nbsp;'''Click'''''Create''.'''
+
The event rule gets triggered to calculate the value that will be displayed in the Expression section of the Contract Type Purchase Agreement when the Created Date is after 1-Nov-19.
<div class="image-green-border">[[File:7.10 Arithmatic 9.png|720px|7.10 Arithmatic 9.png]]</div>  
+
The event rule gets triggered to calculate the value that will be displayed in the ''Expression ''section of the Contract Type ''Purchase Agreement'' when the ''Created Date'' is after ''1-Nov-19''.
+
  
 
== Arithmetic Operations Evaluation through Reverse Sync in Word Add-in ==
 
== Arithmetic Operations Evaluation through Reverse Sync in Word Add-in ==
  
1. '''Click''' the ''Agreement Management'' tile on the ''Dashboard''. The ''Agreement Management'' page opens.&nbsp;<br/> 2.&nbsp;'''Click''' the ''Create Agreement'' tab. The ''Create Agreement'' page opens.<br/> 3.&nbsp;'''Enter''' all the details on the ''Create Agreement'' page.<br/> 4.&nbsp;'''Select''' ''Purchase Agreement'' for Contract Type Name.<br/> 5.&nbsp;'''Select''' ''Own'' in the ''Type Of Paper'' drop-down.&nbsp;<br/> 6.&nbsp;'''Click''' ''Next''. The ''Attributes'' tab opens.<br/> 7.&nbsp;'''Enter''' the value in the attribute ''Unit Price''. For example, ''2''.<br/> 8.&nbsp;'''Enter''' the value in the attribute ''No Of Units''. For example, 100. ''Total Price'' is calculated as 200, by multiplying the ''Unit Price'' and ''No Of Units'' as per the Contract&nbsp;Type configuration.<br/> 9.&nbsp;'''Select''' a date in the Effective Date field. For example, ''1-Nov-19''.<br/> 10. '''Enter''' ''Duration In Days''. For example, ''2''.<br/> 11.&nbsp;The ''Expiry date'' is calculated as per contract type configuration. For example, ''4-Nov-19''.<br/> 12.&nbsp;'''Click''' ''Next''. The ''Select Template'' page opens.<br/> 13.&nbsp;'''Select''' a template. For example, ''Purchase Template''.<br/> 14.&nbsp;'''Click''' ''Next''.&nbsp;<br/> 15. '''Click''' ''Create and Publish''. The ''Purchase Agreement'' state becomes ''Draft''.
+
1. '''Click''' the Agreement Management tile on the Dashboard. The Agreement Management page opens.&nbsp;<br/> 2.&nbsp;'''Click''' the Create Agreement tab. The Create Agreement page opens.
<div class="image-green-border">[[File:7.10 Arithmatic 10.png|720px|7.10 Arithmatic 10.png]]<br/> <br/> 16.&nbsp;'''Click''' ''Download''. The ''Purchase Agreement'' gets downloaded.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:7.10 Arithmatic 11.png|720px|7.10 Arithmatic 11.png]]</div>  
+
 
Now, change the tagged attribute values of ''No of Units'' to ''3'' and ''Effective Date'' to ''03-Nov-19''.
+
3.&nbsp;'''Enter''' all the details on the Create Agreement page.<br/> 4.&nbsp;'''Select''' Purchase Agreement for Contract Type Name.<br/> 5.&nbsp;'''Select''' Own in the Type Of Paper drop-down.&nbsp;<br/> 6.&nbsp;'''Click''' Next. The Attributes tab opens.<br/> 7.&nbsp;'''Enter''' the value in the attribute Unit Price. For example, 2.<br/> 8.&nbsp;'''Enter''' the value in the attribute No Of Units. For example, 100. Total Price is calculated as 200, by multiplying the Unit Price and No Of Units as per the Contract&nbsp;Type configuration.<br/> 9.&nbsp;'''Select''' a date in the Effective Date field. For example, 1-Nov-19.<br/> 10. '''Enter''' Duration In Days. For example, 2.<br/> 11.&nbsp;The Expiry date is calculated as per contract type configuration. For example, 4-Nov-19.<br/> 12.&nbsp;'''Click''' Next. The Select Template page opens.<br/> 13.&nbsp;'''Select''' a template. For example, Purchase Template.<br/> 14.&nbsp;'''Click''' Next.&nbsp;<br/> 15. '''Click''' Create and Publish. The Purchase Agreement state becomes Draft.
 +
<div class="image-green-border"><br/> 16.&nbsp;'''Click''' Download. The Purchase Agreement gets downloaded.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Purchase Agreement - Attributes.png|550px|Purchase Agreement - Attributes.png]]</div>  
 +
Now, change the tagged attribute values of No of Units to 3 and Effective Date to 03-Nov-19.
  
17.&nbsp;'''Click''' ''Save'' to save the Word document.
+
17.&nbsp;'''Click''' Save to save the Word document.
<div class="image-green-border">[[File:7.10 Arithmatic 12.png|720px|7.10 Arithmatic 12.png]]</div>
+
<div class="image-green-border">18.&nbsp;'''Click''' the Select File to select the updated document.</div> <div class="image-green-border"><br/> 19.&nbsp;'''Click''' Upload File.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">[[File:Upload file -Attributes.png|500px|Upload file -Attributes.png]]</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border"><br/> 20.&nbsp;'''Click''' the Details tab. The attribute values of No Of Units and Effective Date are changed through reverse sync (from the Word Add-in to ICI) and also calculations are evaluated accordingly.</div> <div class="image-green-border">&nbsp;</div> <div class="image-green-border">21.&nbsp;'''Click''' Assemble Contract to be able to view the updated values in the document.</div> <div class="image-green-border">&nbsp;</div>  
18.&nbsp;'''Click''' the ''Select File'' to select the updated document.<br/> 19.&nbsp;'''Click''' ''Upload File''.<br/> 20.&nbsp;'''Click''' the ''Details'' tab. The attribute values of ''No Of Units'' and ''Effective Date'' are changed through reverse sync (from the Word Add-in to ICI) and also calculations are evaluated accordingly.
+
<div class="image-green-border">[[File:7.10 Arithmatic 13.png|720px|7.10 Arithmatic 13.png]]</div>  
+
21.&nbsp;'''Click''' ''Assemble Contract'' to be able to view the updated values in the document.
+
<div class="image-green-border">[[File:7.10 Arithmatic 14.png|720px|7.10 Arithmatic 14.png]]</div>  
+
 
&nbsp;
 
&nbsp;
  
 
'''Related Topics''':&nbsp;[[Agreement_Management|Agreement Management]] |&nbsp;[[Configuration|Configuration]]&nbsp;|&nbsp;[[Contract_Type|Contract Type]]&nbsp;|[[Template_Management|Template Management]]
 
'''Related Topics''':&nbsp;[[Agreement_Management|Agreement Management]] |&nbsp;[[Configuration|Configuration]]&nbsp;|&nbsp;[[Contract_Type|Contract Type]]&nbsp;|[[Template_Management|Template Management]]

Latest revision as of 05:12, 24 December 2021

Attribute

Attributes or metadata are the key components of an Agreement. Attribute data is displayed on contracts and associated documents.

Attributes are of two types:

  • Global: These Attributes are used for all Contract Types.
  • Local: These Attributes are used for specific Contract Types.

To view available Attributes:

1. Click  Configure > Attribute . The Atrributes page opens. On this page you can view a list of all the available attributes, Edit, or Add Attributes.

Picture41.png

 

Adding and Editing an Attribute

With ICI, you can create an attribute and use it while creating a Contract Type.

To create an attribute:

1. On Home Page, Click Configure > Attribute. TheAttribute page opens. 

2. Click the New Attribute on the Attribute Library page. The Add Attribute page opens. The Attribute Code is displayed by default.

Picture42.png
  • Display Name: Type the appropriate name of the attribute. For example, corporate office. 
  • Data Type list: Select the appropriate option from the list. Additional related fields are displayed based on the selected Data Type option. For example, when the data type is selected as Number, the related Total Length and Number of Decimals fields are displayed. When the data type is selected as Choice, the option to select the UI Control Type between Dropdown and Radio buttons is displayed. When the data type is selected as MultiSelectChoice, the option to select the UI Control Type between Dropdown and Checkbox is displayed. The selected user control will be rendered on browser.The page length will increase as the number of options in Radio button/Checkbox list increase. Hence, it’s recommended to select Radio button or Check box list when the options are less than eight, else select the Dropdown if there are more options.
Picture43.png
  • Help Message: Type the appropriate help message of the attribute. For example, enter the address of the corporate office. 
  • Source List: Select from the following: 
    • User
    • Integrated
    • Script 

For example, select Integrated if source is inherited. 

Note: If you select the source as Integrated: Is Editable, Is Mandatory, Defined By Rule, Is Inherit andIs Conditional fields become unavailable. 
  • Default Value: Type the default value of the attribute. The value that you type will be displayed on creating a new agreement.
  • Is Default: Click On to enable rules to be set on the attribute.
  • Is Editable: Click On to make the attribute editable in the Agreement, else select Off.
 Note: If you select On in the Is Editable field, the Tracking Attribute and the Is Unique fields are available.
  • Is Mandatory: Click On to make the attribute mandatory.
  • Tracking Attribute: Click On to make the attribute editable throughout the Agreement lifecycle.
  • Is Unique: Click On to make the attribute unique for a Contract Type.
  • Defined by Rule: Click On to make the attribute editable throughout the Agreement lifecycle.
  • Is Inherit: Click On if you want the attribute to inherit the data from Associated Documents.
  • Is Searchable: Click On to make the attribute easy to search.
  • Is Supersedable: Click On to make the updated or amended attribute supersede the earlier one. 
  • Is Conditional: Click On to make the attribute dependent on another attribute. The Conditional section opens. In the Depend on Attribute list, select the attribute on which the new attribute is dependent. In the Depends On Value box, type the value of the selected attribute. Select the values from the Depends on Value field which are automatically fetched based on the attribute selected in Depends On Attribute field, if the data type of that attribute is Lookup, Choice, MultiChoice, or Boolean.
Picture44.png
 

4. Click Save. The attribute is displayed in the Available Attribute list.

Picture45.png
 

Editing an Attribute

In ICI, you can edit an existing attribute. Editing the attribute doesn't have any effect on the Contract Types where it is used.
You can use the edited attribute to create new contract types.  

Note: To edit an attribute in all the entities where it is used (Clauses, Templates, Agreements), go to the Attributes tab of appropriate Contract Type, edit the attribute, and then publish it.

To edit an attribute:

1.Click Configuration on the Home page. The Configuration page opens.

2. Click Attribute  on the Configuration page. In the Available Attribute list, select an attribute that you want to edit.

Alternatively, you can type the name of the attribute in the Search box, and then select the attribute. The Edit Attribute page opens.

3. Modify the existing information as required, and then click Save. The Success! Attribute updated successfully message is displayed at the bottom of the page. You can modify all the field values except attribute code and attribute name.

 

Configuring File Section Attribute as read-only

In ICI, you can upload a document file using the file selection attribute type. ICI provides an option to disable the user defined file selection attribute at the contract type level thereby preventing unintentional or intentional tampering with the document.

Configurators can configure a user defined file selection attribute as editable or non-editable on ICI User Interface. Business users cannot edit the uploaded documents but can still preview and download these read-only documents. This configuration can be done at attribute, agreement, amendment, association, masterdata and contract request contract types, extended entity attributes, extension attributes, and template variables level. This read-only setting for file selection attribute is also supported in Icertis Experience for Word and Bulk Actions.

Note: All file selection attributes are editable by default.

System can still attach a file through a read-only file selection attribute through backend tasks or API integrations. However, users would not be able to replace or remove such original files from UI which are attached through backend task/integration.

Arithmetic Operations and Logical Validations on Attributes

Users can configure arithmetic calculations, logical validations and visibility conditions for attributes using the Enable Expressions attribute property at the agreement, contract request, association and masterdata contract type level.

Configuring Expressions for attributes  

To configure arithmetic calculations and logical validations for attributes at the contract type level (agreement, contract request, association and masterdata):

1. Click the Configure > Contract Types on the Home page. The  Contract Type page opens. 

Picture46.png

3. Select the Contract Type you want to create. For example, AGREEMENT.

Picture47.png

4. Click Next. The Create Contract Type page opens. 
5. Enter a name in the Contract Type Name field. 
6. Enter all the details on the Details tab. 
7. Click Next. The Attributes tab opens. 

Note: The arithmetic calculations are supported for attributes like Currency, Date, Number and Percentage data types.
 
Picture48.png

For example, if you want to calculate the Total Price of a commodity, you need to multiply the attribute values in the fields Product Price and No Of Units. You can also set validation messages on its outcome so that the Total Price value must be greater than 100.

8. Select the attribute Total Price from the Available Attribute list and move it to the Selected Attribute list.
9. Toggle the Enable Expressions flag On for the attribute Total Price. The Expressions tab opens. 

Calculations are performed through the default expression field denoted as EXPR1. 

Note: The Expression field cannot be removed. The new expression can be added or removed by NEW ROW and REMOVE ROW buttons. Each expression such as EXPR1, EXPR2, EXPR3, and so on contains Function and Parameters fields. Based on arithmetic and logical operators selected through the Function field, parameters are set in the Parameters field.

The available functions include Constants (NUMBER, BOOLEAN, DATE, STRING), Arithmetic operations (ADD, SUBSTRACT, MULTIPLY, DEVIDE, PERCENT), Date operations (such as DATE ADD, DATE DIFFERENCE), Logical operations (such as GREATER THAN, LESS THAN, EQUALS, ALL, ANY, NOT) and String operations (CONTAINS, IN, STARTS WITH, HAS VALUE).

10. Select an expression (for example, MULTIPLY) from the Function drop-down of EXPR1. 
11. Select Product Price and No Of Units from the Parameters field to multiply product price and no of units attribute values to get the total price.
12. Click NEW ROW to add a new expression. For example, EXPR2 and EXPR3.
13. Select a Function CONSTANT (NUMBER, BOOLEAN, DATE, and STRING) from the Function drop-down of EXPR2 if you want that to be a constant value.
14. Enter a value (for example, 100) in the Parameters field to set the value of Total Price. A validation message will be displayed if this value is greater than the total price.
15. Select another function (GREATER THAN) from the Function drop-down of EXPR3.
16. Select Total Price and EXPR2 in the Parameters drop-down of EXPR3.
The Result Expression field is used to reflect the result of the selected expression field (EXPR1, EXPR2, EXPR3, and so on). 

Configuring the validation message for an attribute:

The Validate Expression field is used to validate the evaluation based on the selected expression (EXPR1, EXPR2, EXPR3, and so on). The Validate Message field is linked to the Validate Expression field and triggers a user-entered message in case of an invalid expression.

17. Select EXPR1 in the Result Expression drop-down.
18. Select EXPR3 in the Validate Expression drop-down.
19. Enter Total price must be greater than 100 in the Validate Message field.

Picture49.png

 

Configuring the visibility conditions for an attribute:

You can set a Visibility Expression for displaying an attributes dynamically on ICI UI instance, based on business conditions. For example, attribute Cost Surcharge Percentage can be displayed when the calculated Total Price is less than 100.00.

 
20. Click Add on the Attribute page. The Add Attribute section opens.
21. Enter Display Name. For example, Cost Surcharge Percentage.
22. Enter details for the attribute.
23. Toggle the Enable Expressions to On. The Expressions section opens.
24. Set the EXPR1 and EXPR2 same as attribute Total Price.
25. Click NEW ROW to add a new expression. For example, EXPR3. Here you can set the condition for attribute’s visibility. 
26. Select a Function. For example, LESS THAN.
27. Select Parameters. For example, Total Price and EXPR2.
28. Select EXPR3 in the Visibility Expression drop-down. The attribute Cost Surcharge Percentage will be displayed on UI only upon satisfying conditions for EXPR3.
 
Picture 50.png
 
 
Note: In case of String Function- IN, the first Parameters drop-down will display only multi-select choice attributes from the current contract type and users can select multiple attributes in a second dropdown to configure the expression.

29. Click Save.

Note: Arithmetic calculations, logical validations and visibility expressions for attribute values are supported at the following contract type levels: agreement, contract request, associated document, and masterdata.

30. Enter the details in the Association, Display Preference and Team tabs.
31. Verify the details and click Create.
32. Publish and Approve the Contract Type following standard ICI workflows.

 

Arithmetic Operations Evaluation at Agreement level

The attributes will be displayed on the ICI UI instance as per the configured Enabled Expressions while creating an agreement, contract request, associated document, and masterdata contract type instances.

To create agreement contact type instance:

1. Click the Agreement tile on the Dashboard. The Agreement Management page opens. 
2. Click the Create . The Create Agreement page opens.
3. Enter all the details in the Create Agreement page.
4. Enter a name in the Contract Type Name field.
5. Select Own in the Type Of Paper drop-down. 
6. Click Next. The Attributes tab opens.
7. Enter the value in the attribute Product Price. For example, 9.
8. Enter the value in the attribute No Of Units. For example, 10. Total Price is calculated as 90 by multiplying the Product Price (9) and No Of Units (10).

Picture 51.png
 
 
Since the Total Price is less than 100, a validation message will be displayed indicating that Total Price must be greater than 100 and the attribute Cost Surcharge Percentage is displayed on the UI.

 

Configuring Event Rule for Reverse-sync in Word Add-in

You need to create an event rule to evaluate the Arithmetic calculation, where users have made changes in the tagged attribute value of the document. For example, the following steps help you to set an event rule at the agreement document upload level.

Creating an Event Rule

1. Click Configure > Rules on the Home Page . The Rules  page opens.
 
Picture 52.png
 
You can see existing list of rules and Crete button. 
 
2. Click Create to crate a new rule.  
 
Picture 53.png
 
 
The crete Rule page opens. 
 
Picture 54.png

4. Select the Contract Type for which you want to create a rule in the Contract Type list. 
5. Enter a name of the Rule in the Rule Name field. 
 
Picture 55.PNG
6. Enter a description for the Rule in the Rule Description box.
7. Select the Event Rule in the Rule Type drop-down. 
8. Select an appropriate category in the Event drop-down. For example, Agreement Document Uploaded. 
9. Click Next. The Build tab opens.
10.Click Add Rule in the Builder tab.
11. Select And from the Conditions drop-down. 
12. Select an appropriate attribute value in the S'elect Valuedrop-down. For example, Created Date.
13. 
Selectan appropriate attribute value in the Select Value drop-down. For example, Is After.
14. 
Entera value in the Enter Value field. For example, 01-Nov-19.
15. 
SelectCalculate Expression in the Select Action drop-down in the Actions tab.
16. 
ClickNext. 
17. 
ClickCreate.
 
Picture 56.png

The event rule gets triggered to calculate the value that will be displayed in the Expression section of the Contract Type Purchase Agreement when the Created Date is after 1-Nov-19.

Arithmetic Operations Evaluation through Reverse Sync in Word Add-in

1. Click the Agreement Management tile on the Dashboard. The Agreement Management page opens. 
2. Click the Create Agreement tab. The Create Agreement page opens.

3. Enter all the details on the Create Agreement page.
4. Select Purchase Agreement for Contract Type Name.
5. Select Own in the Type Of Paper drop-down. 
6. Click Next. The Attributes tab opens.
7. Enter the value in the attribute Unit Price. For example, 2.
8. Enter the value in the attribute No Of Units. For example, 100. Total Price is calculated as 200, by multiplying the Unit Price and No Of Units as per the Contract Type configuration.
9. Select a date in the Effective Date field. For example, 1-Nov-19.
10. Enter Duration In Days. For example, 2.
11. The Expiry date is calculated as per contract type configuration. For example, 4-Nov-19.
12. Click Next. The Select Template page opens.
13. Select a template. For example, Purchase Template.
14. Click Next. 
15. Click Create and Publish. The Purchase Agreement state becomes Draft.


16. Click Download. The Purchase Agreement gets downloaded.
 
Purchase Agreement - Attributes.png

Now, change the tagged attribute values of No of Units to 3 and Effective Date to 03-Nov-19.

17. Click Save to save the Word document.

18. Click the Select File to select the updated document.

19. Click Upload File.
 
Upload file -Attributes.png
 

20. Click the Details tab. The attribute values of No Of Units and Effective Date are changed through reverse sync (from the Word Add-in to ICI) and also calculations are evaluated accordingly.
 
21. Click Assemble Contract to be able to view the updated values in the document.
 

 

Related TopicsAgreement ManagementConfiguration | Contract Type |Template Management