Forum Discussion

SC's avatar
SC
New Contributor III
3 years ago

Opening balance calculation on OwnerPostAdj

Hi experts,

The business users had posted some retained earnings adjustments to both base and parent entities at OwnerPostAdj consolidation level.

I have a very simple opening balance rule that works across all entities and consolidation levels:

api.Data.Calculate("F#100= RemoveZeros(F#EndBal:T#PovPriorYearM12)","A#<balance sheet accounts>.Base")

We are seeing that the opening balance (F#100) member is correctly pulling the OwnerPostAdj numbers for the base entities from prior years, but is not bringing in the opening balance from the parent entities at OwnerPostAdj level.

I did a 'Force calculate with logging' and see that the 'ReadDataRecordsinDataUnit' step is showing zero records in the database. However, I can confirm that the journal was posted in M12 at the parent entity and C#OwnerPostAdj level.

Any suggestions as to what else I might need to check?

Regards,

S

 

 

  • This was solved by setting 'Calculate OwnerPostAdj if NoData' to True at the cube level.

     

    Regards,

    S

  • SC's avatar
    SC
    New Contributor III

    This was solved by setting 'Calculate OwnerPostAdj if NoData' to True at the cube level.

     

    Regards,

    S