cancel
Showing results for 
Search instead for 
Did you mean: 

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

phadke_manas
Participant

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

Accepted Solutions (1)

Accepted Solutions (1)

jplambert
Newcomer

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

Answers (2)

Answers (2)

adelaide_brunel
Employee
Employee

Hi,

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

phadke_manas
Participant
0 Kudos

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
Employee
Employee
0 Kudos

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
Participant
0 Kudos

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_vasilieva
Employee
Employee
0 Kudos

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
Participant
0 Kudos

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_vasilieva
Employee
Employee
0 Kudos

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.