[GNC] gnucash-user Digest, Vol 199, Issue 18

ornd25 at tutanota.com ornd25 at tutanota.com
Tue Oct 8 20:18:02 EDT 2019


"I think you have found the bug in the import and export of stocktransactions. I recently exportedsome dummy stock transactions and theinformation in the exported CSV records appears to be correct. I am workingmy way through the CSV import process and documenting it as I go withexamples for the guideand I hadn't made it to doing the stock transactions as yet. I have jumped ahead and reimported  stock purchase and stock saletransactions with no errors at all.I created a dummy dividend reinvestmenttransaction for a stock and exported it in the GnuCash Export Format andthen reimported it. On reimporting it created a miscellaneous transaction tothe imbalance account for 3.45.   The price on export was 14+17238/34483 butwhen reimported the price is recorded as 13+17238/34483 accounting for thisdifference. This appears to be some problem with importing prices expressedas a whole number + a fractional part.The transaction recorded before export in the stock account register  was                                                                          Shares       Price                      Debit      CreditAsset:Investments:Brokerage:Stock:Acme              6.8966      14+17238/34483   100Income:Dividend                                                                                                              100After reimporting after deleting the transaction exported it reappears as                                                                          Shares       Price                      Debit      CreditAsset:Investments:Brokerage:Stock:Acme              6.8966      13+17238/34483   96.55Imbalance                                                                                                          3.45Income:Dividend                                                                                                              100                                                                                            1and there is a spurious line with a 1 in the price column - no account andno values in the debit and credit columns.If I edit the 96.55 to 100 and then tab to the next line and ask for theprice to be recalculated when the dialogue to rebalance the transactioncomes up then the price is restored to its original value and a secondimbalance line with a credit of 3.45 is created to balance the debit whichstill exists although ithe Imbalance account does not appear in the accountcolumn for that line (it is assigned to the Imbalance account when the editis closed). If I then close the edit on the transaction by clicking onanother transaction or at the bottom of the register it closes and whenreopened the Imbalance entries have disappeared as expected. Deleting the Imbalance entries in the editor can be tricky as you can't select the two matching entries simultaneously and delete them together andthe minute you delete one GnuCash recalulates the other because thetransaction is imbalanced. This is a quirk of the transaction edit operationas it does not currently check if there is an existing split to an Imbalanceaccount which could be cancelled out (or its balance changed) by the newlycreated balancing split. I didn't have a dummy mutual fund setup in the dummy books I am currentlyusing to develop the documentation but the stock import should be the sameand is likely experiencing  the same problem. If you open the CSV file in atext editor and find the line you can check if the price recorded on exportis the same after being reimported to see if the problem is the same. If itis you could report it as a bug at bugs.gnucash .orgDavid Cousens"
David, I got a similar spurious entry (your 3.45, above) only if I had not deleted the TransactionID or Price formula, either or both, because I deleted them at the same time. After deleting them I just got the extra line in my original post.

I will write up the bug on Bugzilla as I phrased in in my OP, and I will also mention the spurious amount briefly. Please add anything to it you wish.



More information about the gnucash-user mailing list