GNOME Bugzilla – Bug 722123
Zero price entry added to price database on stock purchase
Last modified: 2018-06-29 23:24:43 UTC
Following the update to 2.6.0, gnucash has started adding zero price entries into the price database when a stock purchase is entered into a stock account register. The price source is recorded as user:split-register.
Created attachment 266188 [details] Price editor window
Rats. It's supposed to be adding the effective price, but it seems to do that only when entered from the stock account. When I enter the txn from the stock account it doesn't do anything. How are you entering the stock tranasction?
The transactions are entered into an account register of type stock. All transactions entered into 2.6.0 so far have been auto-filled from previous transactions entered using gnucash 2.4.x. Each transaction consists of splits for: - Stock purchase - Commission expense - Stamp duty expense - Decrease in the cash account for the purchase - Income recording the dividend - Increase in the cash account for the dividend. In previous versions of gnucash, entering such a transaction was not recording any entries in the price database.
Right, it's from a fix for Bug 157247, and it's supposed to insert the calculated price from the purchase split. I suppose that you have the splits visible to adjust the amounts when you hit Enter. Out of curiosity, why is there a pair of dividend splits? One doesn't usually get a dividend at the time one purchases stock.
The dividend is automatically reinvested when it is received into the account. Recording the dividend receipt as a split of the stock reinvestment was the only way I could get the dividend reported as income on the Advanced Portfolio report.
Yes, the transaction splits get filled from a previous reinvestment transaction. I adjust the figures to suit and press enter to record the transaction.
(In reply to comment #5) > The dividend is automatically reinvested when it is received into the account. > > Recording the dividend receipt as a split of the stock reinvestment was the > only way I could get the dividend reported as income on the Advanced Portfolio > report. Ah, I record those as separate transactions, because that's what my brokerage statements do. I also don't use the Advanced Portfolio Report, though I might have a look again after Mike Alexander worked it over yesterday. But I can't replicate the problem. I'm getting properly filled in prices showing in the price editor. Just to be sure, you're using the stock's register, not the cash account, right?
Yes, I'm entering the transaction into the stock's register. I entered a fresh transaction today, ie not one auto-filled from a previous transaction, and gnucash still entered a zero price into the price database.
Could you attach a screenshot of that last transaction? One of us is obviously doing something different...
Created attachment 266926 [details] Reinvestment transaction showing splits I've added a description in the split memo fields to help you identify each split as I've masked out sensitive data in the account names.
The stock purchase line was entered by entering the number of shares, blanking the price, entering the cost and letting gnucash calculate the price per share.
(In reply to comment #11) > The stock purchase line was entered by entering the number of shares, blanking > the price, entering the cost and letting gnucash calculate the price per share. That was the secret. Now I can reproduce it.
And fix it: r23740.
This is still an issue under the following condition: I have received a dividend which is not enough to buy one whole share. The dividend has been recorded in the stock account with the following splits: Tot Buy Tot Sell Stock Income 41.50 Cash 41.50 The stock split is a blank split to tie the transaction to the stock account. Gnucash has entered a zero price entry into the price database. This causes the account total on the accounts page to show zero.
OK, fixed that too with e421123.
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=722123. Please update any external references or bookmarks.