Hi guys, how to group g/l numbers into single line for analysis view entry. instead of showing all the transactions by g/l acc i would like to summarize by each individual g/l account
eg:
Current output
g/l no. amount [:(]
1234 $10
1234 $50
1234 $35
3456 $19
3456 $11
3456 $5
3456 $5
7890 $17
7890 $23
the desired output: [:D]
g/l no. amount
1234 $95
3456 $40
7890 $45
Did you try with Grouping the report on Account No?
hi mohana,
thanks for replying…GroupTotalFields = G/L Account No. in my analysis view entry data item
what appears in my reports:
g/l no. amount 
1234 $10
1234 $50
1234 $35
3456 $19
3456 $11
3456 $5
3456 $5
7890 $17
7890 $23
Did you add the Fields in GroupFooter section of Dataitem?
Did you set proper key?
hi mohana,
now it works after i delete away the second level integer data item… another qs pop up…
i need to separate the account contribution by division
previously:
g/l total
1000 $380
desired output:
g/l divison1 division
1000 $300 $80
I guess you have already created another post for that…
Please close this therad as you got solution…
mohana,
just a side topic, how to i delete my own post? (there’s no replies in it [:(])
You should have options in More–>delete…
if not give me the link…i will delete…
hi mohana,
do you mean this ?
Sorry…
Image is not visible…
If you dont mind, send me the post link…
I will Delete…
hi mohana,
sent to you in your profile already [:)]
Done [:D]
Automation server vs custom control>> http://dynamicsuser.net/forums/t/46615.aspx
Item Return not issue with Cr Memo>> http://dynamicsuser.net/forums/t/44712.aspx
[:(]
Done…
why do you want to delete them?
after so long… (few months) no one replying them
[:’(]
It doesn’t make any problem/harm to you, right?