I am sure that this is one of those fancy function things that SOMEBODY has figured out before, and why reinvent the wheel? Especially if math gives a person hives?
This is the issue - I need to balance my report data to the total in the system, and I need to minus out all of the reversals. Sounds easy - but wait, there's more. The lines with a tax ID number (cleverly masked here) and that haven't been reversed are entered into the system - you can tell reversals because the transaction is repeated with all of the same data minus the tax ID, but with a tran code 81. There are other entries on the report that went in with no tax ID number at all, and these need to be ignored - they are not in the system that I am balaning to. I could say I want nothing with a tax ID = 0, but then I have all of the transactions that were subsequently reversed. I really need logic that states IF all these fields are the same (OTC, Teller #, Tran Amt, Int Amt) get rid of one of them. A number of the reversals are then reposted with the same data (don't ask me why) so I don't want to reverse ALL of the ones that have matching criteria - only the one. Migraine meds, anyone?
Here is my example:
Tax ID OTC REV BRCH TILL TELLER ACCOUNT TRANSACTION INTEREST EFFECTIVE
TRAN NBR NBR NUMBER NUMBER AMOUNT AMOUNT DATE
(null) 0600000111 010 106 600 1006 1,031.36 631.36 20100121
(null) 0700000094 010 107 700 4582 100.96 .96 20100121
0057####### 081 116 1608 1016 12,640.00 7,640.00 20100121
0057####### 1608000066 010 116 1608 1016 12,640.00 7,640.00 20100121
0057####### 1608000066 010 116 1608 1016 12,640.00 7,640.00 20100121 /FONT
Sorry - it is just not lining up right. HTML is not nice to tab delimited fields.
Can you get enough out of this to see the dilemma?
Help and thanks - !