We have created a set of confirmation rules for our forms. However, there is a company that is failing the rule because of an adjustment that must be made by recommendation of the auditors but would not otherwise be accepted. Is there a way to exclude just this company from the rule?
You should be able to add an IF statement to your conformation rule to exclude a particular entity. You would dim out the current entity and add an IF statement to exclude that entity from whatever portion of your confirmation rule you desire here:
Teresa,
I couldn't see where the code example you attached contained reference to an entity, so I attached the code snippet above.
Do you have an example to post as it relates to a specific entity? I'm imagining that if this were a one-off with a specific entity, or set of entities, then hardcoding entity names in the IF statement would be OK?
The code is:
'Rule To ensure that all numbers entered in the disposal column (ROU)are negative.
Dim myBalanceValue As Decimal = api.Data.GetDataCell("Cb#FinancialRptg:C#Local:V#YTD:A#ROUAssetNet:F#DIS:O#Top:I#None:U1#Top:U2#Top:U3#Top:U4#Local_Stat_TB").cellAmount
args.ConfirmationRuleArgs.DisplayValue = myBalanceValue
Dim chkVal As Long
chkVal = args.ConfirmationRuleArgs.DisplayValue
If args.ConfirmationRuleArgs.DisplayValue <= 0.00 Then
Return True
Else
'args.ConfirmationRuleArgs.Info1 = "ROU Disposals has a positive amount"
'args.ConfirmationRuleArgs.Info2 = chkVal
Return False
End If
Below is a code snippet from a client of mine. When you want to execute on only one or two entities, or when you want to exclude only one or two entities, I've put this IF statement at the beginning of the confirmation rule.
