Invoice amount is coming repetitative in Report

[Former Member]

Hi,

In my report, 3 fields are Invoice amount, base amount and tax amount...against document number. In it, base amount and tax amount are different with line items (document number have line items). But Invoice amount is same in all line items....when we do sub-total it sum multiple times...like

Invoice amount.....base amount......tax amount

10000.00.................5000.00...........200.00

10000.00.................5500.00...........100.00

10000.00.................5800.00...........530.00

10000.00.................6100.00...........620.00

10000.00.................8600.00...........400.00

please look at 1st column, Invoice amount is same and other are diff.

I want that Invoice amount should come only in 1st line item....like

Invoice amount.....base amount......tax amount

10000.00.................5000.00...........200.00

................................5500.00...........100.00

................................5800.00...........530.00

................................6100.00...........620.00

................................8600.00...........400.00

Because when we do sub total, it sum multiple times (as line items have with document number)..

Please tell me...

Thanks....

[Former Member]

Hi,

Could you please give more details lke internal table defination and requirement.

Regards,

Anil Salekar

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

Hello Gurus,

Please let me know how the Solutions provided here, can delete automatically....

Is there any problem with those cheater's.....???????????????????????

Edited by: Vijay Babu Dudla on Jul 20, 2009 7:55 AM

[former_member184657]

Those replies were NOT automatically deleted.

I reported those replies to the SCN Moderators because they were WRONG and hence got deleted.

As to why I did not answer your query: such questions have been asked and answered many times here in this forum. So its easily searchable.

pk