Extraction of specific entries
Forums
Hi,
I'm new to IDEA-Script and haven't been able to find a relevant post in the forum. I hope you can help me. I have a table with entries like these:
Date GroupNo EntryNo AccountNo Amount
11/01 4711 1 123 100.00
11/01 4711 2 123 -100.00
11/01 4711 3 234 200.00
11/01 4711 4 0 0.00
11/01 4711 5 234 -200.00
11/02 4812 1 123 -300.00
11/02 4812 2 0 0.00
11/02 4812 3 123 100,00
11/02 4812 4 123 300.00
I want to extract the records where entries within the same date and group, only if the have the same account number and opposite amount and a transaction with an amount of 0.00 between them. In the example above, these would be entries 3 and 5 on November 1st and entries 1 and 4 on November 2nd. How can this be accomplished with IDEA-Script?
Thanks a lot for suggestions,
Eberhard
For the reversals do they…
For the reversals do they have transactions in between them such as the 3rd transaction for Nov 2nd of $100. Also do the 0 transactions not have an account number?