[GNC] Reverse all transactions

Derek Atkins derek at ihtfp.com
Thu Feb 11 15:17:25 EST 2021


Hi,

On Thu, February 11, 2021 3:12 pm, Anton Gladky wrote:
> Dear all,
>
> I need to reverse all transactions in a relatively large database.
> Something like "Increase <-> Decrease" for all entries.
>
> Is there any effective way to do it? Maybe, is it possible to
> operate on sqlte-database directly?

How did the entries get input into GnuCash?
Why do you believe they are incorrect (reversed)?

In short, no, there is no way to do it, and hand-modifying the database
could corrupt it.  But depending how the transactions were entered, there
may be an easy way to "start over" and do it correctly --- assuming that
they ARE incorrect.

GnuCash has a preference to "reverse" the sign on some normally-negative
accounts, so it's also possible that setting is incorrect, but your data
is correct.

This is why I'm asking the questions above.

Hope this helps,

> Thanks
>
> Anton

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant



More information about the gnucash-user mailing list