Mass delete of zero split lines?

[David G. Hamblen]

On 07/09/2010 08:34 AM, Colin Law wrote:
> On 9 July 2010 12:44, jcard21 xxxxxxx<jcard21+gnucash at gmail.com>  wrote:
>    
>>> JimR wrote:
>>>        
>>>> I just discovered something that before I thought was an annoyance, but
>>>> now I think is much more of a pain.  When I split a checkbook register
>>>> transaction to a payee, the next time I create a split to the same payee,
>>>> GNUCash remembers all of those splits.
>>>>
>>>> In particular, when I break down my credit card bill into multiple
>>>> accounts, it remembers those accounts and amounts month-to-month.  For the
>>>> past several years, when a particular month did not have a charge to a
>>>> specific account, I simply deleted the amount, leaving the split line,
>>>> thinking that it caused no harm.
>>>>
>>>> However, when I went to search for a phrase within one of the accounts, I
>>>> got back every month's line item, even though those were all nil amounts.
>>>>   (I probably should have expected this.  Hindsight is always 20-20.)
>>>>
>>>> Is there some way that I can delete all of those nil transactions?  (I
>>>> have a hunch a side benefit is that it might speed up the loading of my
>>>> files on startup.)
>>>>
>>>> Thanks in advance,
>>>>
>>>>          
>> NOTE: I've been using gnuCash 2.2.9 since April, 2009... and I don't
>> use gnuCash's Scheduled Transactions feature.
>>
>> When I create a new txn (for example: CableTV), I position the cursor
>> on the date field of the existing previous month's CableTV txn, press
>> Alt+N (MenuBar Transaction), C (copy); then I move the cursor down to
>> the last/new/empty line, and I press Alt+N, P (paste).
>>
>> Then I just edit the new CableTV txn's date, amount, notes, splits, etc.
>>
>> When editing splits, to completely remove zero amount split lines,
>> make sure you delete that split line's Note, Account, and amount
>> fields. Then, once you move the cursor off that "empty" split line,
>> that split line will get automatically deleted.
>>
>> Then, just save the new txn.
>>
>> NOTE: I would recommend gnuCash continues to allow zero amount split lines.
>>      
> Can you explain why please?
>    

I have a couple of recurring transactions where I like the zero split to 
remain.  One example is a paycheck which has splits for several 
withholdings, not all of which happen on every paycheck.  One one 
paycheck there might not be any withholding for federal taxes, but the 
next paycheck does.  I like having a "standard" set of splits so that I 
can see the zero amounts, and also not have to re-enter the split the 
next time when it's non-zero.


> Colin
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.