Re: [GNC] Order of transactions

2019-03-19 Thread Derek Atkins
Adrien Monteleone writes: > I understood that already, but thanks for the detail. > > What doesn’t work is sorting off the part, because the sorting > stops at “.”, correct? Correct. > That’s why you can’t use “:” in the faux timestamp as the sorting will > stop before it gets to the minut

Re: [GNC] Order of transactions

2019-03-08 Thread Adrien Monteleone
I understood that already, but thanks for the detail. What doesn’t work is sorting off the part, because the sorting stops at “.”, correct? That’s why you can’t use “:” in the faux timestamp as the sorting will stop before it gets to the minutes portion, and why you have to use a 24 hour

Re: [GNC] Order of transactions

2019-03-08 Thread Derek Atkins
Adrien, On Fri, March 8, 2019 2:41 pm, Adrien Monteleone wrote: > I didn’t mean to still be able to sort by the real transaction number, but > if you have one, and you’ve repurposed the NUM field, you’ll likely want a > place to put it just for reference. I simply offered an overview of the > rema

Re: [GNC] Order of transactions

2019-03-08 Thread Adrien Monteleone
I didn’t mean to still be able to sort by the real transaction number, but if you have one, and you’ve repurposed the NUM field, you’ll likely want a place to put it just for reference. I simply offered an overview of the remaining options. Overloading NUM as a time field is pretty much giving u

Re: [GNC] Order of transactions

2019-03-08 Thread Derek Atkins
Adrien Monteleone writes: > Yes, that is why I was explaining the abuse of the NUM field as a time > field for sorting and how to do it in a way that works. If you are > doing this, (or instead using 1,2,3,4 ) *and* you want to keep track > of a transaction number, then you’ll have to put it some

Re: [GNC] Order of transactions

2019-03-07 Thread Stephen M. Butler
On 3/7/19 8:57 AM, Derek Atkins wrote: > Adrien Monteleone writes: > >> Lisa, >> >> I will add to David’s advice that you can use the NUM field other than >> a simple 1,2,3,4... >> >> You might, for example, need or want to keep an actual transaction >> number with the transaction. >> >> For that

Re: [GNC] Order of transactions

2019-03-07 Thread Adrien Monteleone
Yes, that is why I was explaining the abuse of the NUM field as a time field for sorting and how to do it in a way that works. If you are doing this, (or instead using 1,2,3,4 ) *and* you want to keep track of a transaction number, then you’ll have to put it somewhere else so you can still sort

Re: [GNC] Order of transactions

2019-03-07 Thread Derek Atkins
Adrien Monteleone writes: > Lisa, > > I will add to David’s advice that you can use the NUM field other than > a simple 1,2,3,4... > > You might, for example, need or want to keep an actual transaction > number with the transaction. > > For that case, you can put the real transaction number in th

Re: [GNC] Order of transactions

2019-03-02 Thread Adrien Monteleone
Lisa, I will add to David’s advice that you can use the NUM field other than a simple 1,2,3,4... You might, for example, need or want to keep an actual transaction number with the transaction. For that case, you can put the real transaction number in the Action or Memo field of the split. Ot

Re: [GNC] Order of transactions

2019-03-02 Thread David Cousens
Lisa In the register display for an account you will see a field Num. You can specify a number for each transaction which will determine the order in which the transactions are displayed.This however affects all registers in which the transaction appears as per the second reference below. It is r

[GNC] Order of transactions

2019-03-02 Thread Lisa Kurtz
Hi, I just started using GnuCash, and am still trying to figure out all the tips and trick of how to use this. I am coming from Quicken, and one of the things that I was able to do in there that I can't seem to figure out in GnuCash is choosing the order that the transactions are posting. For exam

Re: [GNC] order of transactions for mutual funds

2018-11-15 Thread Christian Pinedo Zamalloa
Yes David, I am sure my bank manager is going to provide me a detailed report, but it is fun to have all details under control :-D In fact, it is not so complicated, I only miss the possibility to move the order of transactions of one account manually. Perhaps one solution (that I think it is quit

Re: [GNC] order of transactions for mutual funds

2018-11-14 Thread David Carlson
Wow! That would be very messy to track in GnuCash and even a challenge in a simple spreadsheet. Do you have some other software designed to address this scenario? Can the fund manager give you a detailed report ? David C On Wed, Nov 14, 2018, 1:28 PM Christian Pinedo Zamalloa < chr.pin...@gmai

Re: [GNC] order of transactions for mutual funds

2018-11-14 Thread Christian Pinedo Zamalloa
Hello, in our case, the capital/gain losses are delayed in fund transfers and only considered when the share is sold. I would try to put a clearer example: Fund A account 1, 2010-1-1, buy 10 shares @ 10 €, gross/net buy 100 € 2, 2015-1-1, transfer 10 shares @ 9 € to fund B, gross sell 90€ with 10

Re: [GNC] order of transactions for mutual funds

2018-11-14 Thread David Carlson
If funds were used to buy a different security first then that security was sold for a withdrawal and intermediate gains matter unlike in U.S. custodial accounts, it could get very messy. David C On Wed, Nov 14, 2018 at 9:43 AM D wrote: > If OP is looking to track gains using FIFO, wouldn't the

Re: [GNC] order of transactions for mutual funds

2018-11-14 Thread D via gnucash-user
If OP is looking to track gains using FIFO, wouldn't the lots functionality work for them? I believe that it uses FIFO exclusively... David T. On November 14, 2018, at 8:23 PM, David Carlson wrote: I think that Christian is asking a slightly different question. I interpret it that in one par

Re: [GNC] order of transactions for mutual funds

2018-11-14 Thread David Carlson
I think that Christian is asking a slightly different question. I interpret it that in one parent custodial mutual fund account he purchased Fund A on dates 1, 2 and later then sold some or all of Fund A and bought Fund B in the same custodial account on date 3. Now I am not sure if he needs to a

Re: [GNC] order of transactions for mutual funds

2018-11-14 Thread Christian Pinedo Zamalloa
As you suggest, I am following the method 1 because I didn't know another solution. I didn't realise of the second approach but I consider the first option is more easy to implement. When I sell shares, I must select manually transactions to track capital gain/losses because the order of the trans

Re: [GNC] order of transactions for mutual funds

2018-11-14 Thread Derek Atkins
Hi, On Wed, November 14, 2018 8:42 am, Christian Pinedo Zamalloa wrote: > Hello, > > I would like to know if it is possible to order manually the transactions > of a mutual fund account. > > When I transfer suscriptions from one mutual fund to another one, the > order > of the transfer transaction

[GNC] order of transactions for mutual funds

2018-11-14 Thread Christian Pinedo Zamalloa
Hello, I would like to know if it is possible to order manually the transactions of a mutual fund account. When I transfer suscriptions from one mutual fund to another one, the order of the transfer transaction depends on the date when the transfer was done. However, it would be quite useful to