Skip to Content
0
Former Member
Nov 15, 2010 at 04:24 AM

The infoset aggregation issue

25 Views

Hi all,

there is a customer abc which is having 2 billing documents because of 2 delivery items 60 and 40 and hence we i run the query using the infoset which contains sales order item and billing documents for the same customer it is getting aggregated

like

customer sales order number billing qty amt

abc 1700000000 100 10,000

abc 1700000000 100 10,000

The amount is supposed to be 5,000 only but it is getting aggreated because of 2 billing documents andd even the quanitity?

Thanks