On 4/13/19 8:53 PM, David Carlson wrote:
ToddAndMargo,
On Sat, Apr 13, 2019 at 9:22 PM ToddAndMargo via gnucash-user
<[email protected] <mailto:[email protected]>> wrote:
On 4/13/19 3:53 PM, ToddAndMargo via gnucash-user wrote:
> Oh Geez,
>
>
I try to reverse the numbers and get all kinds of junk to Imbalance USD.
> Is there a way to elegantly do this?
I exported it to a CSV. I found founbd columns:
Amount With Sym
Amount Num.
It it really easy to reverse their signs and write it back
out with Libre Office Calc
Is there a way to read it back in and overwrite what was there?
Many thanks,
-T
When editing a transaction in GnuCash it is easy and recommended to tab
from field to field in the transaction and change the text, signs or
amounts as desired, with the caveat that tabbing off the right end of a
line will trigger GnuCash to calculate a sum of the two values in the
credit and debit fields and place a positive value in one of the boxes.
Then you can continue through the transaction until all lines are as
desired. To commit your completed edit press Return or Enter whatever
it is called on your keyboard. GnuCash will then re-arrange the lines
so all the lines with positive values in the left box appear first, then
lines with positive values in the right box appear below. If there are
lines with zeros the zeros disappear but the line remains with empty
boxes in between the other lines. This is also when GnuCash adds lines
called Imbalance if all the lines do not add up to zero. Once you get
used to that behavior it seems automatic and logical.
--
David Carlson
That explains a lot. I had been pressing Enter on every block.
_______________________________________________
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.
