GNOME Bugzilla – Bug 410604
multi-currency bug: blank splits and unbalanced transactions
Last modified: 2018-06-29 21:27:35 UTC
Please describe the problem: sometimes parts of a transaction show up blank when viewed from one account, but not when viewed from another. Transactions don't balance. Steps to reproduce: Steps to reproduce: GnuCash 2.0.5 (or any older version back to at least 1.8.11). * my default currency is CAD. * File -> New -> New File: create a brand new set of accounts, for example "Common Accounts". Choose CAD (the default) as the base currency. Do not enter any opening balances. * under "Current Assets", create a new asset account named "USD Cash", denominated in USD. * under "Income", create a new income account named "USD Income", denominated in USD. * open the account register for the "USD Cash" account. * type "tab" twice to go to the "Description" field, and enter a description for a new transaction (e.g. "testing"). * type "tab" to go to the "Transfer" field. Enter Income:Salary, then type "tab" to go to the Increase field. * type "100" and twice tab * the exchange rate window pops up. Enter an exchange rate of 1.0 and "OK". * click on the transaction just created, and click "split" * change "Income:Salary" to "Income:USD Income". Hit "enter" three times to accept the transaction. * click on the same transaction, and click "split". * in the blank line of the split, enter Income:Salary under "Account", tab, and 100 under "Increase". Press enter. * change Imbalance-USD (the line that was just created automatically) to "Assets:Current Assets:Cash in Wallet" under "Account" in the same line. Press enter three times to accept the transaction. * open the account register for the "Cash in Wallet" account. * click on the (only available) transaction. * click "split". the field "Income:Salary" is blank. * open the USD Income account, and split the transaction. the entries are normal. * open the USD Cash account, and split the transaction. the entries are normal. * open the Income:Salary account, and split the transaction. three of the four entries are blank, only Assets:Current Assets:Cash in Wallet shows 100.00. Actual results: Expected results: Does this happen every time? Yes, I think so. Other information: I can attach a file demonstrating the problem. But there's not button to attach a file here. I'll try later in the bug tracker.
Created attachment 83078 [details] gnucash file with the bug in it. Here is it!
Would someone please look at the patch I attached to 335101 last September? It seems to fix this bug too. I think that this bug is a duplicate of 335101, but using multiple currencies instead of a stock purchase. I went through the sequence of steps listed in this bug in gdb tonight and verified that the change attached to 335101 fixes the problem.
Perhaps more insight into how and when: At least part of this bug still exists in GnuCash 2.2.0, and I believe only on transactions where <enter> moves you to another transaction before all of the information has been entered, and then transaction must be edited. Amounts in splits in the originating account look correct, but the secondary account, and all reports are 0.00. Transactions are balanced, however. To reproduce: A. In register preferences " 'Enter' moves to blank transaction " is checked. B. Use a register based on foreign currency. C. Start a new transaction by setting the date back a few days and hit 'Enter' instead of 'tab'. (User entry error) D. Go back to the blank transaction, and without expanding the split window fill in description, pick secondary account, enter currency amount, hit 'enter' key (or menu button) before setting any exchange rate. E. Go to secondary account check results. Notes: This error seems to be is associate with not setting the exchange rate before the initial transaction was saved. If you try to correct the problem in the secondary account or correct by just re-entering the currency amounts it will not correct. To correct you must open the 'Edit' exchange rate on each split item and hit OK, even though the exchange rate in the dialog box displays correctly.
I can report I've got the same problem in 2.2.6, i get the error between an accounts payable entry in one currency and a payment in another account in a different currency.
According to comment 12 in Bug 335101, this was fixed in 2.0.6. I also just checked 2.2.9, and the bug is not present. (If you follow the above steps to reproduce, then an exchange rate window pops up in additional places, and the created transactions look as expected from all views). Are you sure the problem you have in 2.2.6 is the same problem? Did you try following the above steps to see if you can reproduce the effect? If not, perhaps what you are reporting is a different bug. You should describe it in detail.
Re 4/5: I assume, it is specific to account payable and account receivable.
I have also tried this with the current development snapshot (svn r18524) and can't reproduce. Whenever there's a transfer-to account involved that is different from the transfer-from account, the exchange rate window pops up. Regarding comment #3: In step D. I get presented with an exchange rate window before I can leave the transaction. @Geoff: can you give us the exact steps you took that lead to this error ? Then we can verify if this is still a problem in the new version of GnuCash.
*** This bug has been marked as a duplicate of bug 335101 ***
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=410604. Please update any external references or bookmarks.