Skip to Content
0
Former Member
Apr 30, 2012 at 02:14 PM

[BpC 10] - problem with validation

21 Views

Hi,

I am trying to use the validations (business rule) but it is not doing anything.

I have defined a rule that compares two accounts (total assets and total equity and liabilities) on a flow that is a base level element. The result, i.e. the difference should be written to the validation account.

The rule looks like in the screenshots and the script I am using is this:

*RUN_STORED_PROCEDURE=SPRUNVALID([%MODEL%],[%CATEGORY_SET%],[%CURRENCY_SET%],'%SCOPETABLE%','%LOGTABLE%')

I have also tried it as

*RUN_STORED_PROCEDURE=SPRUNVALID([Consolidation],[Actual],[LC],'%SCOPETABLE%','%LOGTABLE%')

but neither has generated any entries in the database.

What am I doing wrong?

Attachments

val_detail.jpg (26.3 kB)
val_header.jpg (31.1 kB)