contra entries

[crimlet]

I have a list of transactions against various accounts. Is it possible to quickly take out contra entries, e.g those with both a positive and a negative value in the same account.

Help much appreciated as I have thousands of lines

 

[s-o-s]

On 2002-05-03 07:59, crimlet wrote:
I have a list of transactions against various accounts. Is it possible to quickly take out contra entries, e.g those with both a positive and a negative value in the same account.

Help much appreciated as I have thousands of lines

Just picked this from the bottom of the screen with no replies...so thought I would raise it.

You could do it with code...
Search recursively through the accounts,
Find all matching accounts
Check each value against others if equal and opposite then Mark in new column as Contra (perhaps better than deleting since we like audit trails...and you can always filter them out)
loop through values
loop through accounts.

This will do it but will be slow.

If its anything like an accounting system I worked on the system generated a text field for reversals therefore using other fields you may be able to limit the repetitive nature.

Anyone have any other ideas?

_________________<A HREF= "http://website.lineone.net/~s-o-s/Index.html">

This message was edited by s-o-s on 2002-05-03 08:58