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 <[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 > > _______________________________________________ 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.
