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 <[email protected]>:
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
[email protected] www.ihtfp.com
Computer and Internet Security Consultant
--
Stephen M Butler, PMP, PSM
[email protected]
[email protected]
253-350-0166
-------------------------------------------
GnuPG Fingerprint: 8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
