difference from validation

[Former Member]

Hi,

I have a problem with validations. Let's look at a very simple one that checks whether my total assets are equal to my total equity and liabilites. I would expect the validation account that is used as the target in the rule to show either a positive or a negative amount, depending on whether my balance sheet shows more assets or more equity/liabilities.

When I look at my data though, the difference is always a positive number. Is there a way to change this?

Example:

ACCOUNT	Value	Value
TOT AST	100	100
TOT LEQ	110	90
TOT BS	-10	10
Validation account	10	10

I would need the validation account to show the same value (and sign) as the TOT BS account.

Thanks,

Arnold    

[cecilia_petersson2 · Accepted solution]

Hi Arnold,

A workaround could be to mimick the validation rule and include it in the validation script. i.e. select all base members of TOT BS, the relevant flows etc and post to the validation account.

/Cecilia

[former_member186498]

Hi Arnold,

sorry maybe I don't have understand your question but in validation rules you can specify the sign of the account.

Regards

     Roberto

[Former Member]

Hi Roberto,

I know, and I did try, but it made no difference. Whether I selected 1 or -1, the difference posted to the validation account always kept the same sign.

If you look at my example and imagine the two columns to be two different elements in the auditid dimension. If you add the values together you would have a total assets figure of 200 and a total equity/liabilities figure of 200 as well. So on a total level the difference is zero.

This is not reflected on the validation account which, on total level, shows a difference of 20 instead.

Thanks