Forum Discussion

WillVitale's avatar
WillVitale
Contributor
8 days ago

How to Exclude Entities from Confirmation Rule

Hello,

I'm somewhat new to writing code for confirmation rules. I'm trying to create a confirmation that is only for 1 entity and we'd like it in our general rule groups for confirmation rules and not have to create it's own rule profile. 

Basically we need to the rule to be If WFProfile Entity <> 02140 return True, if not then (enter rule I already created).

I couldn't find anything in the documentation about making it entity specific and excluding other entities.

Thanks,

Will

Admin
Finance
  • Ioana's avatar
    Ioana
    6 days ago

    Hi Will,

    Can you try using the below example and adapt it for your needs? You should be able to run the confirmation rule only for 02140 and all others should return True:

    Thanks,

    Ioana

  • WillVitale's avatar
    WillVitale
    Contributor
    5 days ago

    Thanks Ioana! That worked great. One last question. I'm trying it to pass 3 accounts where all 3 need to have values in it. Right now it keeps failing, even though I have values in those accounts. Not sure if it's the "And" that isn't working correctly, but individually the accounts work. I know I can write it out individually, but I wanted to keep it in one rule.

    Dim EntityName As String = api.Pov.Entity.Name.ToString
Dim WFYear As Integer = api.Time.GetYearFromId(api.Pov.Time.MemberId)

If EntityName.Equals("02140") Then
	args.ConfirmationRuleArgs.DisplayValue = api.Data.GetDataCell("Cb#Consol:C#Local:S#Actual:V#Periodic:A#8211:F#EndBalInput:O#BeforeAdj:I#None:U1#81:U2#DEF:U3#L_UNA:U4#None:U5#None:U6#None:U7#USGAAP_JE:U8#None").cellAmount And
	args.ConfirmationRuleArgs.DisplayValue = api.Data.GetDataCell("Cb#Consol:C#Local:S#Actual:V#Periodic:A#9901:F#EndBalInput:O#BeforeAdj:I#None:U1#99:U2#DEF:U3#L_UNA:U4#None:U5#None:U6#None:U7#USGAAP_JE:U8#None").cellAmount And
	args.ConfirmationRuleArgs.DisplayValue = api.Data.GetDataCell("Cb#Consol:C#Local:S#Actual:V#Periodic:A#TaxPmt" & WFYear & ":F#EndBalInput:O#BeforeAdj:I#None:U1#00:U2#DEF:U3#L_UNA:U4#None:U5#None:U6#None:U7#USGAAP_JE:U8#None").cellAmount
    
	If args.ConfirmationRuleArgs.DisplayValue <> 0 Then
        Return True
    Else
        Return False
    End If

Else
	'Do Not run the rule for other entities (Set Bypass to True)
	args.ConfirmationRuleArgs.Bypass = True
	
End If

    Thanks,

    Will

  • Ioana's avatar
    Ioana
    New Contributor III
    6 days ago

    Hi Will,

    Can you try using the below example and adapt it for your needs? You should be able to run the confirmation rule only for 02140 and all others should return True:

    Thanks,

    Ioana

    • WillVitale's avatar
      WillVitale
      Contributor
      6 days ago

      Hi Ioana,

      Thank you for the reply. I also was able to do something similar for what you did below.

      ' To check if Entity equals 02140
If api.Pov.Entity.Name <> "02140" Then
    Return True
ElseIf args.ConfirmationRuleArgs.DisplayValue = api.Data.GetDataCell("Cb#Consol:C#Local:S#Actual:V#Periodic:A#8211:F#EndBalInput:O#BeforeAdj:I#None:U1#81:U2#DEF:U3#L_UNA:U4#None:U5#None:U6#None:U7#USGAAP_JE:U8#None").cellAmount And
	args.ConfirmationRuleArgs.DisplayValue = api.Data.GetDataCell("Cb#Consol:C#Local:S#Actual:V#Periodic:A#9901:F#EndBalInput:O#BeforeAdj:I#None:U1#99:U2#DEF:U3#L_UNA:U4#None:U5#None:U6#None:U7#USGAAP_JE:U8#None").cellAmount And
	args.ConfirmationRuleArgs.DisplayValue = api.Data.GetDataCell("Cb#Consol:C#Local:S#Actual:V#Periodic:A#TaxPmt|WFYear|:F#EndBalInput:O#BeforeAdj:I#None:U1#00:U2#DEF:U3#L_UNA:U4#None:U5#None:U6#None:U7#USGAAP_JE:U8#None").cellAmount Then
    If args.ConfirmationRuleArgs.DisplayValue <> 0 Then
        Return True
    Else
        Return False
    End If
End If

      My question to you now is, the 3rd args.ConfirmationRuleArgs.DisplayValue with account TaxPmt|WFYear|. OS doesn't like parameter in it. Currently I have the cube view set up to be dynamic, so when an user goes to that cube view in their WF, the account would automatically update to the correct year. So if they went back to 2022, it would change to TaxPmt2022 and when they move to WF year 2025, it will change to TaxPmt2025.

      Is there a similar way to do this for Confirmation Rules?

      Thanks,

      Will

      • Ioana's avatar
        Ioana
        New Contributor III
        6 days ago

        Can you include in the confirmation rule the following?

        Dim WFYear As Integer = api.Time.GetYearFromId(api.Pov.Time.MemberId)

        And then replace A#TaxPmt|WFYear| with A#""TaxPmt"& WFYear &". Check if this works.

        Thanks,

        Ioana