cancel
Showing results for 
Search instead for 
Did you mean: 

AUDITTRAIL Property | IS_CONSOL & IS_CONVERTED

Former Member
0 Kudos

Hi guys,

I'm trying to get this 2 properties figured out. I have this understanding that when we put an ID with the property IS_CONSOL = Y and IS_CONVERTED = N, I could post a journal and the figure will be consolidated. I've posted a Journal in NON_GROUP and somehow after running consolidation, the figure is still stuck in LC. I even tried posting the Journal in USD but somehow it still remains in USD, NON_GROUP instead of GROUP_CONSOL (consoscope group of consolidation).

Please help me figure this out, i've been trying various ways and I just don't seem to get this property to work.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Rudy,

BPC is used for both planning and consolidation. In case of planning, as well, you might want to keep a track of the source of the information. However, you might not want to get these information consolidated. The, in this case, you would want to keep the property IS_CONSOL for these audit IDs as N.

When you run the consolidation, it only considers those entries for which IS_CONSOL is Y. Journal entries are passed to ensure the balances tally, and these entries are passed only after the consolidation has been run; since only after running the consolidation, you will know whether you need any additional accounting entries or not. Remember, journal entries are passed for the group, after the consolidation has been done.

Ideally, you should not be passing journal entries in the stand alone books of a subsidiary; since the TB of these books will already be balanced. If its not, then there is problem in ECC.

Hope this helps.

Former Member
0 Kudos

Hi Rudy,

Journals entries posted are not taken into consideration when you run consolidation, only data loaded using input form, data manger packages, scrip logic or BADI  are taken into account for consolidation.

So if you want to see the effect of journal entries in your consolidated results, post them to relevant groups/sub-groups post consolidation run.

Hope this helps.

Regards,

Kalyan.

Former Member
0 Kudos

Actually it does. I have an audit ID for my input where the property of IS_CONSOL and IS_CONVERTED is both 'Y' and the figure is translated and consolidated accordingly. The difference with what i'm doing now is having IS_CONVERTED to 'N' and IS_CONSOL to 'Y'.

former_member599120
Contributor
0 Kudos

Hi Rudy,

I agree with Kalyan. I am Sorry to say, You should to know first business reason to use BPC jounal, BPC Journal is only help you to make top side adjustments for consolidation (Group adjusting entries). If your subsidiaries TB data came not balance, please fixed it on ERP system and load it again to BPC, then run translation and consolidation again. Those properties did not relevant with journal translation.

Kind regards,

Wandi Sutandi 

Former Member
0 Kudos

Im so sorry but that just dont make any sense. Why would there be a property "is_consol" and "is_converted" then? If there are no point of using this then why is it there? Ive used an audit with both set to 'y' and the figure is translated and consolidated accordingly.