AUDITTRAIL Property | IS_CONSOL & IS_CONVERTED

[Former Member]

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.

[Former Member]

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]

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]

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]

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.