tag:infinitekind.tenderapp.com,2009-01-14:/discussions/online-banking/26085-downloaded-investment-transactions-not-visibleInfinite Kind: Discussion 2023-04-11T13:52:30Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/584383622023-03-30T20:15:35Z2023-03-30T20:15:35ZDownloaded investment transactions not visible?<div><p>So I did the usual, clear console, download transactions, copy console. It looks like the OFX download mostly worked but with one error:<br></p>
<pre>
<code>Exception in thread "AWT-EventQueue-0" java.lang.IllegalArgumentException: Cannot set rate for Boeing Common Stock to non-positive or NaN value: 0.0
at com.infinitekind.moneydance.model.CurrencyType.setRate(CurrencyType.java:424)
at com.infinitekind.moneydance.online.OnlineTxnMerger$TxnMatch.record(OnlineTxnMerger.java:1214)
at com.infinitekind.moneydance.online.OnlineTxnMerger.addOnlineTxnWithoutMerging(OnlineTxnMerger.java:363)
at com.infinitekind.moneydance.online.OnlineTxnMerger.mergeTransactionsIntoRegister(OnlineTxnMerger.java:161)
at com.moneydance.apps.md.view.gui.DefaultOnlineUIProxy.lambda$autoAddDownloadedTxns$1(DefaultOnlineUIProxy.java:523)
at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
at java.base/java.security.AccessController.doPrivileged(Unknown Source)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)</code>
</pre>
I'm wondering if this is why the transactions aren't displayed after downloading.</div>Tedtag:infinitekind.tenderapp.com,2009-01-14:Comment/584383622023-04-01T17:30:49Z2023-04-01T17:31:00ZDownloaded investment transactions not visible?<div><p>I suspect they're not showing up because of the exception.</p>
<p>I get the same issue on an Edward Jones account with the log below. Just prior to updating to the 2023 version I was using the 2022.6 Toolbox extension which warned me about duplicate securities. It's one of those security that's identified in the log below. I haven't yet figured out how to fix the rate, nor resolve the duplicates.</p>
<pre>
<code>it took 0.063 seconds to eliminate 0 duplicates from 9 downloaded transactions
Exception in thread "AWT-EventQueue-0" java.lang.IllegalArgumentException: Cannot set rate for INSDBNK09 to non-positive or NaN value: 0.0
at com.infinitekind.moneydance.model.CurrencyType.setRate(CurrencyType.java:424)
at com.infinitekind.moneydance.online.OnlineTxnMerger$TxnMatch.record(OnlineTxnMerger.java:1214)
at com.infinitekind.moneydance.online.OnlineTxnMerger.addOnlineTxnWithoutMerging(OnlineTxnMerger.java:363)
at com.infinitekind.moneydance.online.OnlineTxnMerger.mergeTransactionsIntoRegister(OnlineTxnMerger.java:161)
at com.moneydance.apps.md.view.gui.DefaultOnlineUIProxy.lambda$autoAddDownloadedTxns$1(DefaultOnlineUIProxy.java:523)
at java.desktop/java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.desktop/java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
at java.desktop/java.awt.EventQueue$4.run(Unknown Source)
at java.base/java.security.AccessController.doPrivileged(Unknown Source)
at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
at java.desktop/java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.desktop/java.awt.EventDispatchThread.run(Unknown Source)</code>
</pre></div>pabigottag:infinitekind.tenderapp.com,2009-01-14:Comment/584383622023-04-01T18:57:59Z2023-04-01T18:57:59ZDownloaded investment transactions not visible?<div><p>To be honest, it sounds like you are downloading a rate of 0 from the bank?</p>
<p>Have you checked tools/securities for and zeros there?</p>
<p>What exact toolbox message are you getting about duplicates? The normal start point for those is the securities menu, merge duplicate securities.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/584383622023-04-01T19:21:21Z2023-04-01T19:27:27ZDownloaded investment transactions not visible?<div><p>At the moment there doesn't appear to be a version of Toolbox that works with 2023. I get a VERSION INCOMPATABILITY: QUIT pop-up with it now, which prevents doing anything else with the extension. (I have 1057.)</p>
<p>The fundamental problem seems to be the exception when the rate is zero, which is likely a bug unrelated to the Toolbox extension.</p></div>pabigottag:infinitekind.tenderapp.com,2009-01-14:Comment/584383622023-04-01T19:58:13Z2023-04-01T19:58:13ZDownloaded investment transactions not visible?<div><p>Yes. It’s unrelated to toolbox.</p>
<p>Get latest toolbox preview from<br>
<a href="https://yogi1967.github.io/MoneydancePythonScripts/">https://yogi1967.github.io/MoneydancePythonScripts/</a></p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/584383622023-04-02T13:09:13Z2023-04-02T13:09:13ZDownloaded investment transactions not visible?<div><p>Update.. Uninstall and reinstall toolbox from extensions menu and you will get latest MD2023 version (despite what the screen/version says)...</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/584383622023-04-02T14:03:12Z2023-04-02T14:03:22ZDownloaded investment transactions not visible?<div><p>Thanks; the reinstalled toolbox works and I've cleared its issues.</p>
<p>This leaves the apparent bug of throwing on a zero rate as the cause of the hidden unconfirmed downloaded transactions. Hopefully that'll be fixed for 2023.2 soon.</p></div>pabigottag:infinitekind.tenderapp.com,2009-01-14:Comment/584383622023-04-02T14:10:46Z2023-04-02T14:10:46ZDownloaded investment transactions not visible?<div><p>What happens if you try this on MD2022.6(4097)?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/584383622023-04-02T21:40:32Z2023-04-02T21:40:32ZDownloaded investment transactions not visible?<div><p>I reported it to the developer and he says that he’s now fixed it.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/584383622023-04-02T23:09:24Z2023-04-02T23:09:24ZDownloaded investment transactions not visible?<div><p>Sorry it took me so long to respond. I haven't opened Toolbox yet with the new version, so <em>my</em> issue isn't a Toolbox issue AFAIK. When I mention duplicates, I'm talking about the new(ish) message while downloading OFX, something like "12 transactions downloaded (after 0 duplicates removed) for account XYZ." I've updated to the new MD and the latest Toolbox in case it comes into play. I still have a message in this one account stating that unconfirmed transactions are waiting to be confirmed when there's no blue dot and no visible transactions. It's not a split screen issue because that isn't available (as far as I can see) with an investment account. The other Fidelity accounts are downloading without issue; it's just this one. I suppose I'll manually enter the transactions and see if I can use Toolbox to reset or delete the currently hidden OFX transactions.</p></div>Tedtag:infinitekind.tenderapp.com,2009-01-14:Comment/584383622023-04-03T00:18:28Z2023-04-03T00:18:28ZDownloaded investment transactions not visible?<div><p>just as user</p>
<p>a new preview should be out soon (probably tomorrow) - you should check to see if it addresses your issue.</p></div>dtdtag:infinitekind.tenderapp.com,2009-01-14:Comment/584383622023-04-11T13:50:39Z2023-04-11T13:50:39ZDownloaded investment transactions not visible?<div><p>The new preview worked after I reset the sync date. Then I wound up entering the transactions manually anyway because I decided it was faster to enter 5 manual transactions than to learn the Toolbox method of moving investments from one account to another. I plan to read the documentation and be ready to use the Toolbox next time I have an investment account transfer, because they usually involve a lot more securities.</p></div>Ted