[GNC] Reverse all transactions

[Anton Gladky]

Hi Derek,

Thanks for a quick reply!

> How did the entries get input into GnuCash?
Manually, but in a reverse order.

> Why do you believe they are incorrect (reversed)?
Well all entries in "Expenses" are in "Rebate" column,
and all entries in "Income" are in "Charge" column.

So I believe all of them need to be reversed.

Now the root structure looks like this:

Assets: -10
Expenses: -10
Income: 10


Thanks

Anton


Am Do., 11. Feb. 2021 um 21:17 Uhr schrieb Derek Atkins <derek at ihtfp.com>:

> 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
>
>