Skip to Content
0
Former Member
Mar 05, 2009 at 12:57 PM

InfoSet query - eliminate duplicates while calculating amounts

64 Views

I got InfoSet consist of FI DSO and Dunning data DSO.

FI fields in Infoset are:

AC_DOC_NUM

LINE_ITEM

AMOUNT

Dunn. fields in InfoSet are:

AC_DOC_NUM

LINE_ITEM

DUNN_NUM

DUNN_AMOUNT

ODS are joined through AC_DOC_NUM + LINE_ITEM fields.

Every combination of FI (ac_doc_num+line_item) can have several dunn_num, and as a result I get wrong (larger) amounts in InfoSet while summing up on ac_doc_num level.

Is there any possibility to get valid FI amounts on Query level?