What is a cross validation rule?
Cross-validation (also known as cross-segment validation) controls the combinations of values you can create when you enter values for key flexfields.
A cross-validation rule defines whether a value of a particular segment can be combined with specific values of other segments.
Solution:
Step1: Enable 'Cross-Validate Segments'
Login to user 'TATAUSER' created by us.
Navigation: Tata General Ledger Responsibility > Setup > Financials > Flexfields > Key > Segments
1. Query by entering following info
Application: General Ledger
Flexfield Title: Accounting Flexfield
2. Then again query for the Code 'Tata Coa'
3. Uncheck 'Freeze Flexfield Definition'
4. Check 'Cross-Validate Segments'
5. Check 'Freeze Flexfield Definition'
Step2: Create Cross Validation Rule and add a add a Include Rule
Navigation: Tata General Ledger Responsibility > Setup > Financials > Flexfields > Key > Rules
1. Query for Structure: Tata Coa
2. Under Cross-Validation Rules
Select Name, Description, Error Message as below
3. Under Cross-Validation Rule Elements
Create a Include Rule by selecting value 'Include' under 'Type'
Note: Every Cross-Validation Rule must have an 'Include' rule. An include rule is used to include all the combinations between the segments.
In the following screen we gave Company: 01 to 99 and Division: 00 to 99. This means that we've included all Companies and Divisions.
Step3: Now add a Exclude Rule
Note: We can have more than one Exclude Rule. An Exclude rule is used to exclude few combinations from the combinations given in Include rule.
Here we are excluding Division values 11-99 to the Segment 01. This means 00 to 10 are only valid divisions for Company 01
For example 01.11.00.00.3000 is a invalid combination. Define another Exclude rule like below.
Following 2 screenshots exclude divisions 01 to 10 and 21-99 for company 02
This means 11-20 is the only valid divisions for Company 02. [Also 00 is a valid Division] Define another Exclude rule like below.
Following screenshot exclude divisions 01 to 99 Companies 03, 04.
This means 00 is the only valid Division for Companies 03, 04
Step4: Testing
Journals > Enter > New Journal
Enter 01.11.00.00.3000. It shows our error message 'Invalid Combination'.
Cross-validation (also known as cross-segment validation) controls the combinations of values you can create when you enter values for key flexfields.
A cross-validation rule defines whether a value of a particular segment can be combined with specific values of other segments.
Solution:
Step1: Enable 'Cross-Validate Segments'
Login to user 'TATAUSER' created by us.
Navigation: Tata General Ledger Responsibility > Setup > Financials > Flexfields > Key > Segments
1. Query by entering following info
Application: General Ledger
Flexfield Title: Accounting Flexfield
2. Then again query for the Code 'Tata Coa'
3. Uncheck 'Freeze Flexfield Definition'
4. Check 'Cross-Validate Segments'
5. Check 'Freeze Flexfield Definition'
Step2: Create Cross Validation Rule and add a add a Include Rule
Navigation: Tata General Ledger Responsibility > Setup > Financials > Flexfields > Key > Rules
1. Query for Structure: Tata Coa
2. Under Cross-Validation Rules
Select Name, Description, Error Message as below
3. Under Cross-Validation Rule Elements
Create a Include Rule by selecting value 'Include' under 'Type'
Note: Every Cross-Validation Rule must have an 'Include' rule. An include rule is used to include all the combinations between the segments.
In the following screen we gave Company: 01 to 99 and Division: 00 to 99. This means that we've included all Companies and Divisions.
Step3: Now add a Exclude Rule
Note: We can have more than one Exclude Rule. An Exclude rule is used to exclude few combinations from the combinations given in Include rule.
Here we are excluding Division values 11-99 to the Segment 01. This means 00 to 10 are only valid divisions for Company 01
For example 01.11.00.00.3000 is a invalid combination. Define another Exclude rule like below.
Following 2 screenshots exclude divisions 01 to 10 and 21-99 for company 02
This means 11-20 is the only valid divisions for Company 02. [Also 00 is a valid Division] Define another Exclude rule like below.
Following screenshot exclude divisions 01 to 99 Companies 03, 04.
This means 00 is the only valid Division for Companies 03, 04
Finally Cross-Validation Rules form looks like following. Save.
Important: Whenever you define/modify/delete a Cross-Validation rule then you need to re-Compile accounting Flexfield. In this case compile our flexfield 'Tata Coa' [Tata General Ledger Responsibility > Setup > Financials > Flexfields > Key > Segments]Step4: Testing
Journals > Enter > New Journal
Enter 01.11.00.00.3000. It shows our error message 'Invalid Combination'.
0 comments