You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Calculate Beginning Balance to Roll forward from December Prior Year

I'm trying to calculate a Beginning Balance account to Rollforward from the December Prior Year Ending balance account. I can't seem to get it to work. This is the latest version of the calculation that I'm trying:

SET HYBRIDBSOINCALCSCRIPT NONE;

FIX ("Entity Currency", "FCCS_Entity Input", @Relative("Intercompany",0), @Relative("Total C1", 0),@Relative("Total C2", 0) @Relative("Total C3", 0), "FCCS_Periodic" , "Ovr" , "FCCS_Managed Data") "GrsUnrealGLFixedMatEOP" ( @CALCMODE(BOTTOMUP);

IF(@ISMBR("Jan")) [GrsUnrealGLFixedMatEOP] = @PRIOR("Dec"->[GrsUnrealGLSubOthEOP]-> @Relative("Entity",0), 1, @RELATIVE("Years",0));

ELSE [GrsUnrealGLFixedMatEOP] = @PRIOR([GrsUnrealGLSubOthEOP]);

ENDIF

ENDFIX

This code worked in the member formula. However, when I tried to add it to insertion rule 10, it did not give us consistent results. Sometimes, the calcs worked and the other time, they did not work.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!