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