Skip to Content
0
Former Member
Feb 26, 2007 at 05:58 PM

How to filter repeated qty of item

22 Views

Hi BW Expert

I have a query based on the InfoSet. Since one delivery note item could have more than one invoice items or shipment cost items, the qyt of DN item is repeated.

for example:

DN--


DN item Delivery qty Invoice No. -Invoice Item ---Invoice value

100046-- -0001


100
900001

10
--


26

-


100--


20--


32

-


100--


30--


58

How can I avoid the repeated delivery qty (100) in the report?