Opening in Dimension Detail

mrigya

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

Avinashpanwar

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