[GNC] Reverse all transactions

[Derek Atkins]

Hi,

On Thu, February 11, 2021 3:26 pm, Anton Gladky wrote:
> 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

Two things:

1) Yes, this definitely looks wrong.  Sorry.
2) From my experience it's much better (and easier) to enter transactions
from Asset and Liability accounts instead of Income and Asset accounts.

I'm afraid you're going to have to re-enter your data.

You can TRY to export it to CSV, manipulate it there, and then import.

-derek

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


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