want to print Dimension Name on G/L Entry GroupFooter

Stivan_dsouza21

want to print Dimension Name on G/L Entry GroupFooter
In Case of Journal Voucher, Multiple lines JV with different dimension staff code
i want print staff name on g/l entry groupfooter


Below is the code written on G/l Entry - onaftergetrecord
DimensionValue := '';
DocumentDimension.RESET;
DocumentDimension.SETRANGE(DocumentDimension."Table ID",17);
DocumentDimension.SETRANGE(DocumentDimension."Entry No.","G/L Entry"."Entry No.");
DocumentDimension.SETRANGE(DocumentDimension."Dimension Code",'D004');
IF DocumentDimension.FINDSET THEN
REPEAT
DimensionValue := DocumentDimension."Dimension Value Code";

DimensionValueName := '';
RecDimensionValue.RESET;
RecDimensionValue.SETRANGE(RecDimensionValue."Dimension Code",'D004');
RecDimensionValue.SETRANGE(RecDimensionValue.Code,DimensionValue);
IF RecDimensionValue.FINDFIRST THEN
DimensionValueName := RecDimensionValue.Name;
UNTIL DocumentDimension.NEXT = 0;

now in case of multiple lines JV, it picking Last dimension name and print it....

can somebody help me out....

vijay_g

What is your Grouping field name? Try it on groupfooter...

IF RecDimensionValue.GET('D004',DocumentDimension."Dimension Value Code") THEN
    DimensionValueName := RecDimensionValue.Name;

Stivan_dsouza21

vijay where should i write the code....

vijay_g

on groupfooter where you want to print name.
what's grouping field name?

Stivan_dsouza21

g/l entry.posting date

vijay_g

Then why don't you print name in body? or how would you print dim value name in posting date footer for each gl entry?

Stivan_dsouza21

Client to print dimension values of staff below groupfooter is there anyother way...

vijay_g

Then you can put it after footer not group footer.

Stivan_dsouza21

i took a g/l entry footer and tried in it but it picking up the last record of the document

vijay_g

You can do it by taking another two dataitem(one is Gl entry with same filter as above and 2nd one is document dim) after GLentry and linked them. in the body of document dimension print dimension name.
hope it's clear to you now..

Stivan_dsouza21

should i indent the new g/l entry from first g/l entry and ledger entry dimension under new g/l entry

Stivan_dsouza21

vijay i m geting the dimension Value Code now how can i print name (from dimension value) of dimension Value Code

Stivan_dsouza21

Thanks Vijay it has been done as per your suggestion.....