Skip to Content
0
Former Member
May 01, 2009 at 11:50 PM

Filter out records with the Same Key?

43 Views

Hi SDN,

I am trying to load from a write-optimized DSO to a standard DSO. Based upon the key, the source DSO have two records with the same key DOC_Num+Doc_Item. The second record has STOR_NO = 'R' and quantity reversed in sign to negative. When the load takes places (and I have debugged it) only the second record is processed and I suspect that DTP in its step 'Filter Out New Records with the Same Key' is dropping the first record.

Can someone explain the process here because I was expecting both records in the End Routine so that I would sum up both the records leading to a zero. As I have now, the lone records returns a negative quantity with no offset.

Thanks.

SM