Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community, I need help
I have a table with monthly bills and this table have cases of chargebacks in the table that the situation would be "COD_MOV" = 11 and when that happens I need to ignore the previous payments, ie desconsidero payment before the reversal in such cases I able to treat using a flag to mark the fields, however, there are cases in which I have more than one payment in months extorno for previous payments, my doubt and how to deal with this situation, follow the attached qvw
in waiting, thanks
as it should be the document using the flags
COTA | DATE | COD_MOV | VLR | FLAG |
1 | 01/01/2013 | 10 | 100 | |
1 | 01/02/2013 | 10 | 100 | 1 |
1 | 01/02/2013 | 11 | -100 | 1 |
1 | 02/02/2013 | 10 | 100 | |
1 | 01/03/2013 | 10 | 100 | 1 |
1 | 01/03/2013 | 10 | 200 | 1 |
1 | 01/03/2013 | 11 | -100 | 1 |
1 | 01/03/2013 | 11 | -200 | 1 |
1 | 02/03/2013 | 10 | 100 | |
1 | 02/03/2013 | 10 | 200 | |
1 | 01/04/2013 | 10 | 100 |
no problem, thanks for helping out so far