Opening in Dimension Detail

mrigya
mrigya Member Posts: 124
edited 2009-10-06 in NAV/Navision Classic Client
Hi All...
Please tell me where should i write the code for getting the opening balance in Report No 28 Dimension Detail.
I am trying to write it on Level3 body 2 trigger, but its not working fine...

Thanks and Regards
Mrigya

Comments

  • Avinashpanwar
    Avinashpanwar Member Posts: 2
    mrigya wrote:
    Hi All...
    Please tell me where should i write the code for getting the opening balance in Report No 28 Dimension Detail.
    I am trying to write it on Level3 body 2 trigger, but its not working fine...

    Thanks and Regards
    Mrigya

    Hi Mrigya,

    Use the below code

    //avi
    AnalysisViewEntry.RESET;
    AnalysisViewEntry.SETRANGE(AnalysisViewEntry."Analysis View Code","Analysis View".Code);
    AnalysisViewEntry.SETRANGE(AnalysisViewEntry."Dimension 1 Value Code",DimVal.Code);
    AnalysisViewEntry.SETFILTER("Posting Date",'<%1',StartDate);
    AnalysisViewEntry.CALCSUMS(AnalysisViewEntry.Amount);

    OpeningBalance := AnalysisViewEntry.Amount;
    //avi


    Put the above code in analysis view (on after get triger) between

    EndDate := CLOSINGDATE(AccountingPeriod."Starting Date" - 1);
    //avi
    AnalysisViewEntry.SETRANGE("Posting Date",StartDate,EndDate);

    i think it may work



    Regards,

    Avinash Panwar

Categories