Omit Cancellation and its pair from an Invoice Line table

[nese]

Hello,

I need to make a script to omit a cancellation of the previously paid items from invoice line database. How can I make sure that what cancellation pair to omit?

Here's an example of the data:

Date Sess Desc. Charge Credit

2/2/09 Feb09 Item A $135

2/2/09 Feb09 Item B $1040

2/2/09 Feb09 Payment - Thank You $285

2/23/09 Feb09 Payment - Thank You $1175

2/24/09 Feb09 Refund $285

2/11/09 Mar09 Item B $1040

2/11/09 Mar09 Payment - Thank You $4160

2/11/09 Apr09 Item B $1040

3/31/09 Apr09 Cancellation - Item $1040

2/11/09 May09 Item B $1040

3/31/09 May09 Cancellation - Item $1040

....

...

...

Could someone give me a hint or ideas of how to script this please?

thank you!

Sumomo

[Lee Smith]

Is this an accurate representation of your data?

Edited April 2, 2009 by Guest

[nese]

I've included a sample data in pdf enclosed. Hopefully that'll make my questions clearer.

Thank you very much!

Sumomo

sample.pdf