cancel
Showing results for 
Search instead for 
Did you mean: 

Opening balance calculation on OwnerPostAdj

SC
New Contributor III

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

 

 

1 ACCEPTED SOLUTION

SC
New Contributor III

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

 

Regards,

S

View solution in original post

1 REPLY 1

SC
New Contributor III

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

 

Regards,

S

Please sign in! SC