FC 10.1: Control expression to check value on PACK01 vs local adj audit id?

[phadke_manas]

Hi Experts,

Our requirement is to have a blocking control which checks if the value for an account flow pair on the original package audit id (PACK01) is the same as that on a local adjustment audit id (PACK02). We already have a formula on the data entry schedule where the user is required to enter the data on PACK01 and PACK02 au id's which shows the difference if any which acts as a 'visual' control. However we also need a blocking control in the category to prevent the user from publishing the package in case of a difference.

We have tried the below control expression and factor but the control shows up as rejected in the validation report due to invalid settings.
In the env tab Original package audit id is ticked, a filter containing the other local adjustment au id is selected and Audit Id by Audit id option is ticked.

Factor: {FL = F99}
Expression : {AC = ABCDEF ; AU = PACK01} = {AU = PACK02}

Regards,
Manas Phadke

[jplambert · Accepted solution]

Hi Manas,

Because FC does not allow Audit ID dimension in its controls, we did kind of the same as what Olga proposed to do (calculate the difference between the two AU), but with package rules instead of formulas.

In this case, we clearly needed to separate the generated amounts from the reporting ones, so we generated amounts on a new specific flow (e.g. CONTROL, i.e. separated from F99, PER, etc). This is this difference, stored in this "CONTROL" flow, that can be picked up by controls in FC category scenario.

A rather sophisticated series of such a control was implemented at a client of mine 10 years ago, and is still working very well. We couldn't find any better solution but I would be very happy to be proven wrong, and to learn from you.

Regards,

Jean-Pierre

[adelaide_brunel]

Hi,

In order to better understand the behavior, can you paste a screenshot of the error at the validation ?
Thanks

[phadke_manas]

The control appears under controls rejected

manual control TEST-001 - "F99 Current year tax rate for Statutory on PACK02 should match PACK01 " is rejected (invalid settings)

[adelaide_brunel]

Hi,

Indeed, it means that those values are not defined in the category scenario.
Can you show the formula expression which is working with the audit id, in order to compare ?
Thanks

[phadke_manas]

Hi,

We do not have any other control which has an expression that contains AU id dimension members. This is the first control where we need to compare the value of an account-flow pair on two separate audit id's individually.

[Olga_Vasileva]

Hello phadke_manas,

I'm doubtful that a control in-between audits would work like that, as there're audit selection options in control definition as you mentioned.

In your case you can try using formula to calculate the difference and apply control on that difference.

UPD: formulas don't seem to support AU for calculation either, so it's not an option unforturnately.

[phadke_manas]

Thanks Olga, I tried creating a formula to store the difference but even the formula doesn't like AU id dimension in the expression and shows up as rejected.

[Olga_Vasileva]

phadke_manas , yes, formulas are similar to controls and don't support AU, so as Jean-Pierre mentioned the package rules + control on difference are probably the only way to automate it.