Grouping in report

nazu

Hi Experts,

I want to group by External Document no in Sales invoice hedaer.For that same external docuemnt no i want to group on the Sales invoice line by No.How do I do that

Example Lets say i have external document no is 12345.for this I have 5 documents with the same external no where the sales invoice line has say item 111 for all the five documents,so the output must be
external docuemnt no 12345
Item no 111 total 5 line amount(sum)

I created all teh keys bt i am not getting teh output.
the output which I get is
External docuemnt no 12345
Item no 111 total 1 line amt=111
Item no 111 total 1 line amt-111

Any help is really apprecaited

matttrax

I think the easiest solution is to copy the external document number to the lines when it is entered / changed. That way you can just group the lines on External Document No., No.

Andwian

Try to build a report from the wizard. That will help you much.

rhpnt

nazu wrote:

I created all teh keys bt i am not getting teh output.
the output which I get is
External docuemnt no 12345
Item no 111 total 1 line amt=111
Item no 111 total 1 line amt-111

If you really created the right key you should check the "GroupTotalFields" property of the SH dataitem and show the result in the GroupFooter section. And don't forget to use the TOTALSCAUSEDBY function.