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

Agg Override ODR to Insertion Point Calc

Hi, I`d like some guidance from converting this ODR into Insertion point (currently trying FCC_25)

Test App Specs:

Application DSO (Period - Movement)
Main Currency USD
CalcMvmtsPostFCCS10 - True
CONFCALC_Enable_Rate_Amount_Override - True
ODR_Enable_Rate_Amount_Override - True (when using the ODR method)

This calc aggregates the override from the child to the parent entity

ODR Calc that works (already tested)
/* Agg Overrides */
FIX (@RELATIVE ("Total Data Source",0),@CHILDREN ("FCCS_Amount Override Accounts"),@RELATIVE ("FCCS_Intercompany Top", 0), "No Custom 1", "No Custom 2 ", "Actual")
    "FCCS_Periodic" (
       @CALCMODE (BLOCK);
        IF(@ISUDA ("Entity", "USD_Override_Child"))
            "EntityCurrency"->"FCCS_Entity Input";
        ENDIF
    )
ENDFIX
FIX (@RELATIVE  ("Total Data Source",0),@CHILDREN ("FCCS_Amount Override Accounts"),@RELATIVE ("FCCS_Intercompany Top", 0), "No Custom 1", "No Custom 2", "Actual", "USD", "FCCS_AmountOverride")
    "FCCS_Periodic" (
       @CALCMODE (BLOCK);
        IF (NOT(@ISMBR (@LEVMBRS ("Entity", 0))))
            IF(@ISUDA ("Entity", "Non_USD_Parent"))
                @SUM (@RELATIVE (@CURRMBR ("Entity"),0));
           ENDIF
        ENDIF
    )
ENDFIX
/* END Agg Overrides */

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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