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