[GNC] Reverse all transactions

[Stephen M. Butler]

Do you have a backup of the database from before these entries?  If so, 
can you restore that database to that state and start over?

Note:  if there have been a lot of other transactions entered in the 
interim, then the above may not be an option.

If you have a file holding the original transactions, then you should be 
able to import them twice.  Once to reverse the transactions original 
entry.  The second time to get them entered correctly.

Note that there is an option on a transaction-by-transaction basis to 
auto-generate a reversing entry.  You would need to do that twice in 
order to get the effect you need.  Again, that is a manual effort on one 
transaction at a time.

On 2/11/21 12:33 PM, Derek Atkins wrote:
> 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
>>>
>>>
>


-- 
Stephen M Butler, PMP, PSM
Stephen.M.Butler51 at gmail.com
kg7je at arrl.net
253-350-0166
-------------------------------------------
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8