GNOME Bugzilla – Bug 728999
Scheduled transaction creates lines with empty amount
Last modified: 2018-06-29 23:30:24 UTC
Created attachment 275190 [details] db grid Sometimes random scheduled transactions create lines with an empty amount. I am using pgsql database, if I look at the splits table I see that there is a value in value_num column and 0 in quantity_num. See attaches screen with another good transaction aside.
What is the SX template transaction that creates the bad transaction, and did it also create the good transaction?
All scheduled transactions create good and bad ones. I have done more investigation on it and I found that bad transactions have GBP currency while all my accounts are in EUR (default currency in settings is EUR). Another observation is that these transactions (in GBP) are not editable. This means that if I type a new value it is impossible to leave the line. No errors are visible in log either. The only way to end it is to close the account tab. It is still possible to delete a bad transaction. GBP could be explained by my locale (en_GB), but I suppose that at least default currency from settings should take precedence. By the way is there a way to see transaction's currency from Gnucash? I can only see it directly in database.
This sounds like it's the same as Bug 731019 and maybe Bug 723524. Do you have accounts in GBP? Are any of them involved in the SXes that cause the problem? Are any of the defective transactions carried over from 2.4? Are any of them from 2.6? No, there's nothing that exposes the transaction currency to the GUI AFAIK. You can probably fix the defective ones with an update query, changing the transactions.currency_guid field to the commodity.guid for EUR. The report of 731019 was able to fix his similar problem in the XML backend that way.
I have no accounts in GBP, so I was surprised to find some GBP transactions. Surely I was able to fix it in backend, but what I want is to stop them being created. Scheduled transactions which create defective transaction could be from 2.4, but defective transactions themselves were created now, by 2.6. I remember even to recreate some SXs (is this scheduled transactions acronym?) but it didn't prevent them to create defective lines. I could imagine that then I create a SX with default currency set to GBP it creates transactions in GBP regardless on the account's currency. Is it possible? How can I check SXs currency?
I think this is a duplicate of bug 736703. SXs are created in the default currency -- the one set on the Account tab in Preferences. Because the amount is set to 0, the exchange rate isn't editable in either participating account window, but it is editable in find results and general ledger windows. The fix for 736703 prevents SXs from creating 0 amount splits in currency accounts. That fix is in 2.6.4. *** This bug has been marked as a duplicate of bug 736703 ***
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=728999. Please update any external references or bookmarks.