Account Based Calculation Issue

[Former Member]

Hi Experts

I am currently using Account Based Calculation Business rule to calculate retained earning

I have created a business rule to totally allocate net income for the year to retained earning but there is something very strange

retained earning over all months were calculated correctly except Dec of every year

[Former Member · Accepted solution]

the only difference is that on 12-2013 data purely coming from ecc

but on 12-2014 data was coming from ecc and i did some reclassification for some costs in the P/L statement on the audit trail member ( local adjustment )

[former_member186338 · Accepted solution]

Then it looks like that this audit trail member is out of scope of this rule...

[Former Member]

i just changed it to confirm that its working with the business rule

just to test it

[Former Member]

the one that have parent is what i use

vadim i run a business rule for the local adj member only and it transformed the amount correctly

so it seems that the amount of the ECC Input Member overwrite the balances of member Local Adj

so how can configure the business rule with sum mode not overwrite mode

[former_member186338]

Use common parent! But I don't like the member with space in the ID - "Input Total" - incorrect ID!

Also why do you need to change AUDITTRAIL ID in the rule? What is the business scenario?

[Former Member]

[former_member186338]

Ups, you have strange ID's of AUDITRAIL members! With spaces inside ....

Vadim

P.S. And LocalADJ has no parent...

[Former Member]

[former_member186338]

Screenshot of administration of audittrail dimension?

[Former Member]

i mean that i have configured the business rule which include the audit trail (local ADJ) as in the below pic

the problem is that audit trail member not effected by the business rule (out of the scope as u told me )

what i need to do now is to know why this specific member is out of scope

[Former Member]

hi vadim

i have checked it and the member audit trail (local adj) is not reflected using the business rule

but i have configured it in the business rule so i dont know what exactly the problem

why its net reflected using the business rule

[former_member186338]

"but i have configured it in the business rule" - what do you mean?

[Former Member]

Vadim i tried the business rule on Dec 2013 and its working fine

this mean that the problem is with Dec 2014 only

may cause there was some manual input reclassification ?

[former_member186338]

Something like this... I am not able to look on your system... You have to find the difference between 2013 and 2014 yourself!

Vadim

[Former Member]

i am using it to post net income to retained earning to balance the balance sheet

it always balanced except DEC

let me explain

[Former Member]

Hi Vadim

Thanks for your answer

is time dim important for Account Based Calculation ?

I think its important only for Balance Carry Forward right ?

one more thing that i need to know

when i choose Total audit ( input,local adjustment) bpc will take the total value and reclassify it ?

[former_member186338]

"is time dim important for Account Based Calculation ?" = in general - no, but you mentioned that the issue is in DEC

And what is the issue? Can you provide some data sample?

[former_member186338]

And where can I see all required setup screenshots?

Vadim

[Former Member]

[former_member186338]

And what about time dimension?