BPC 10.0 SP20 : Journal entries are only periodical data

[Former Member]

Hi BPC experts,

I need some help about journal entries in a YTD Consolidation model.

Let's say that I posted a manual journal entry in 2015.02. Those data are only recorded in the period 2015.02 but not from 2015.03 to 2015.12 although we are in a YTD model. From what I read on related topics, this seems normal. As a consequence, in order to replicate these data to the following periods, we would need to Re-open it. But this method is rather unpractical.

For instance, if there are over 20 journal entries per month from period 01 to 11, that would mean there would be over 200 journal entries reopened in period 12. That would be not readable for users.

Therefore, I would like to use JOURNAL.LGF to replicate those data. Is it possible ? If yes, what would be the logic script ?

Thank you in advance,

Dat

[former_member186338 · Accepted solution]

Hi Dat,

It's not so simple!

Something can be done if journal is posted for the single month. You have to use different AUDITTRAIL ID's to differentiate adjustments:

Journal.lgf will be like:

*SELECT(%Y%,[YEAR],TIME,[ID]=%TIME_SET%) //Get year from single month in %TIME_SET%

*SELECT(%TID%,[TIMEID],TIME,[ID]=%TIME_SET%) //Get TIMEID

*SELECT(%MS%,[ID],TIME,[TIMEID]>=%TID% AND [YEAR]=%Y% AND [CALC]=N) //Select months from %TIME_SET% till the end of the year

*FOR %M%=%MS% //Loop months

*XDIM_MEMBERSET TIME=TMVL(-1,%M%),%M%

*XDIM_MEMBERSET AUDITTRAIL=JournalAdj,CalcAdj

*WHEN AUDITTRAIL

*IS JournalAdj

*WHEN TIME

*IS %M%

*REC(EXPRESSION=%VALUE%,AUDITTRAIL=CalcAdj)

*ENDWHEN

*IS CalcAdj

*WHEN TIME

*IS TMVL(-1,%M%) //Prev month

*WHEN TIME.MONTHNUM

*IS<>12 //exclude DEC of prev year for JAN in journal

*REC(EXPRESSION=%VALUE%,TIME=%M%)

*ENDWHEN

*ENDWHEN

*ENDWHEN

Vadim

[Former Member · Accepted solution]

Thank you Vadim !