[GNC] Don't understand why I have what I have

ToddAndMargo ToddAndMargo at zoho.com
Sun Apr 14 00:16:44 EDT 2019


On 4/13/19 8:53 PM, David Carlson wrote:
> ToddAndMargo,
> 
> 
> On Sat, Apr 13, 2019 at 9:22 PM ToddAndMargo via gnucash-user 
> <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>> 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.




More information about the gnucash-user mailing list