tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/4231-investment-report-duplicated-accountInfinite Kind: Discussion 2022-05-05T11:58:13Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-02-17T14:24:14Z2019-02-17T14:24:14ZInvestment Report - Duplicated Account<div><p>I have two Easyshare accounts (RP) and (SP) both holding BT shares. I have just run the Investment Performance report and notice the (RP) account is duplicated? The duplicate (RP) account has no shares but I recognise the income entry as a recent dividend? I also notice the value of the account mirrors that of the (SP) account?</p>
<p>I thought perhaps a rogue account had crept into the system but looking under tools/accounts that is clearly not the case.</p>
<p>I am running build 2019.1 (1855).</p></div>rayplayertag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-02-20T14:21:44Z2019-02-20T14:21:44ZInvestment Report - Duplicated Account<div><p>Hi any thoughts on this please.</p></div>rayplayertag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-02T13:38:38Z2019-03-02T13:38:38ZInvestment Report - Duplicated Account<div><p>Hello Infinite Kind, is anybody there?</p></div>rayplayertag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-11T11:23:39Z2019-03-11T11:23:39ZInvestment Report - Duplicated Account<div><p>Hi Infinite Kind, this is very disappointing - not even an acknowledgment.</p>
<p>I have switched to using the Investment Reports Extension where there are no duplicated accounts - which proves there is an issue with Moneydance. However, the Investments Reports Extension is picking up cash balances that differ from the figures I know are correctly reflected in Moneydance – so using the extension does not resolve.</p>
<p>Something is not right - could my file be corrupted and what is the best way to resolve that?</p>
<p>Would appreciate some help please.</p></div>rayplayertag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-11T13:02:33Z2019-03-11T13:02:33ZInvestment Report - Duplicated Account<div><p>I am not support staff, just a user.</p>
<p>Your first thought two investment account with the same name seems the most likely.<br>
In the Investment Performance report double click on the rogue investment accounts Non-ISA BT Easyshare (RP) to open a transaction window. This may give a clue to what’s going on.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-15T09:47:49Z2019-03-15T09:47:49ZInvestment Report - Duplicated Account<div><p>Hi Derek, thanks for the response and the tip but all it does it open the Non-ISA BT Easyshare (RP) account as you'd expect - proving there is not actually a duplicated account.</p>
<p>I have since concluded this is another 'feature' of MoneyDance reporting which clearly can not be trusted.</p>
<p>.</p></div>rayplayertag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-15T09:55:47Z2019-03-15T09:55:47ZInvestment Report - Duplicated Account<div><p>I am not support staff, just a user.</p>
<p>I am not having any problems with Investment Performance report running 2019.2(1860).<br>
Are you getting the same duplication in any other reports?</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-15T17:43:33Z2019-03-15T17:43:33ZInvestment Report - Duplicated Account<div><p>If I run the account balances report all seems well - no duplicated accounts or values.</p>
<p>However, if I run the portfolio report there is one entry for the Easyshare Account (RP) which correctly states the number of shares and value, but there is an extra line as well with the shares and value from the (SP) account? Which is clearly wrong.</p>
<p>There is also an entry in the report for the Easyshare Account (SP), which is correctly shown.</p></div>rayplayertag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-15T17:59:03Z2019-03-15T17:59:03ZInvestment Report - Duplicated Account<div><p>I am not support staff, just a user.</p>
<p>Try this.<br>
In the Investment Performance report click EDIT - RESET - NONE, then tick the items to be included in the report.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-15T18:02:56Z2019-03-15T18:02:56ZInvestment Report - Duplicated Account<div><p>Hi Derek, appreciate your help - unfortunately no change.</p></div>rayplayertag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-15T18:08:16Z2019-03-15T18:08:16ZInvestment Report - Duplicated Account<div><p>I am not support staff, just a user.</p>
<p>OK give up, this one is for support</p>
<p>SUPPORT CAN YOU STEP IN, Thanks</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-28T10:06:32Z2019-03-28T10:06:32ZInvestment Report - Duplicated Account<div><p>Hi, can I prompt for an update please.</p>
<p>BR’s</p>
<p>Ray</p>
<p>From: Infinite Kind <a href="mailto:tender+de791f6ac4@tenderapp.com">tender+de791f6ac4@tenderapp.com</a><br>
Sent: 17 February 2019 14:26<br>
To: <a href="mailto:rayplayer@btinternet.com">rayplayer@btinternet.com</a><br>
Subject: Your support request has been received by The Infinite Kind</p>
<p><a href="http://infinitekind.com">http://infinitekind.com</a></p>
<p>The Infinite Kind technical support: infinitekind.com/help <a href="http://infinitekind.com/help">http://infinitekind.com/help</a><br>
email: <a href="mailto:support@infinitekind.com">support@infinitekind.com</a></p>
<p>Hello rayplayer!</p>
<p>This is an automated response to let you know that we've received your request:</p>
<p>Investment Report - Duplicated Account</p>
<p>and will respond as quickly as possible. Answers to many common questions can be found in our knowledge base <a href="http://help.infinitekind.com/kb">http://help.infinitekind.com/kb</a> and user guide <a href="http://help.infinitekind.com/kb/user-guides/moneydance-2015-user-guide">http://help.infinitekind.com/kb/user-guides/moneydance-2015-user-guide</a> .</p>
<p>Based on your support request, we think you may find the following articles from our FAQ helpful:</p>
<ul>
<li>Create an Investment Account <a href="http://help.infinitekind.com/kb/investment-accounts/create-an-investment-account">http://help.infinitekind.com/kb/investment-accounts/create-an-investment-account</a></li>
<li>Adding Securities <a href="http://help.infinitekind.com/kb/investment-accounts/adding-securities">http://help.infinitekind.com/kb/investment-accounts/adding-securities</a></li>
<li>Represent Property as Investment <a href="http://help.infinitekind.com/kb/investment-accounts/represent-property-as-investment">http://help.infinitekind.com/kb/investment-accounts/represent-property-as-investment</a></li>
</ul>
<p>We'll send an email to you (at <a href="mailto:rayplayer@btinternet.com">rayplayer@btinternet.com</a>) when we update your support request. Alternatively, you can keep track of this conversation online <a href="http://help.infinitekind.com/discussions/investments/4231-investment-report-duplicated-account">http://help.infinitekind.com/discussions/investments/4231-investment-report-duplicated-account</a> .</p>
<p>Thanks again!</p>
<p>Sincerely,<br>
The Infinite Kind</p>
<p>Be a part of the Community: Blog <a href="http://infinitekind.com/blog">http://infinitekind.com/blog</a> | <a href="http://twitter.com/theinfinitekind">http://twitter.com/theinfinitekind</a> | <a href="http://facebook.com/MoneydanceApp">http://facebook.com/MoneydanceApp</a></p>
<p>You have been sent this message because you recently opened a help request with The Infinite Kind.</p></div>rayplayertag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-28T10:29:52Z2019-03-28T10:31:39ZInvestment Report - Duplicated Account<div><p>I am not support staff, just a user.</p>
<p>Hi rayplayer.</p>
<p>I have posted a link to this thread on Sean’s (the Moneydance’s software developers) Slack site in the hope he will respond to your issue.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-28T14:09:19Z2019-03-28T14:09:19ZInvestment Report - Duplicated Account<div><p>Hi,<br>
(I'm just a user), This won't help you much, but the Investment Perf report is working fine for me... In fact I recently reconciled it back so that I know it's working. So must be a bug, or perhaps there's something 'funny' with your dividend txn..? Out of interest, what happens if you delete the txn and re-run the report? You can then use edit undo to reinstate the txn. Did the duplicate disappear?</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-29T09:51:12Z2019-03-29T09:51:12ZInvestment Report - Duplicated Account<div><p>Hi Rayplayer,</p>
<p>I'm so sorry that nobody from TIK has responded to your message after such a long time.</p>
<p>In Moneydance every investment account has a reference to securities that are managed within that account. This sounds like the Non-ISA BT Easyshare (RP) account and British Telecom security (or maybe just some of the transactions associated with those) have gotten crossed. That is, there are likely transactions in the Non-ISA BT Easyshare (RP, or maybe SP) that reference the security within another investment account. I know of one third party extension that might have caused this to happen.</p>
<p>It is sometimes possible to manually correct, but the fastest way to resolve it would probably be to do a screen sharing session. If that's ok with you could you let me know what dates and times would work for you as well as your time zone?</p>
<p>Thanks,<br>
Sean</p>
<p>--Sean Reilly Developer, The Infinite Kind<br>
<a href="https://infinitekind.com">https://infinitekind.com</a></p></div>Sean Reillytag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-03-30T10:37:52Z2019-03-30T10:37:52ZInvestment Report - Duplicated Account<div><p>Hi Stuart, if I delete the dividend txn and re-run the report the duplicate disappears - I can't see anything wrong with the txn, but from Sean's comments something has gotten crossed.</p>
<p>Hi Sean, many thanks for your response - I'm in the UK and can do a screen share on Monday (1 April) morning or afternoon if that works for you?</p>
<p>Note that I use the Investment Reports extension, and notice that has no duplicated accounts but it shows negative cash balances which are clearly wrong.</p>
<p>BR's</p>
<p>Ray</p></div>rayplayertag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-04-01T10:40:58Z2019-04-01T10:40:58ZInvestment Report - Duplicated Account<div><p>Hi Ray,</p>
<p>OK, let's do a screenshare today then. I'm also in the UK and could do the screenshare this afternoon, so shall we say 1pm? Here's the link to begin the screen sharing session:<br>
<a href="https://get.teamviewer.com/tikhelp">https://get.teamviewer.com/tikhelp</a></p>
<p>If you click that and run the app that auto-downloads then I'll see when you're online and can prompt to begin the connection.</p>
<p>Thanks,<br>
Sean</p></div>Sean Reillytag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-04-02T08:28:03Z2019-04-02T08:28:03ZInvestment Report - Duplicated Account<div><p>I am not support staff, just a user.<br>
Hi rayplayer.</p>
<p>Assuming you had a screen session with Sean would be interest to know if there was a solution to your issue and what that solution was.</p>
<p>Thanks</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-04-02T14:49:06Z2019-04-02T14:49:06ZInvestment Report - Duplicated Account<div><p>Hi Ray,</p>
<p>OK, I've found the problem and confirmed that it was what we discussed during the screen sharing session. It is easy to correct on your side, so no code changes would help on ours (other than adding detection for situations like this). To fix this, do the following:<br>
1. open your Non-ISA BT Easyshare (RP) account 2. make sure the "Register" tab is selected 3. edit the DivXfr transaction on 2019.02.04 4. while editing that transaction, click the popup arrows in the Security field to select the British Telecommunications security. I know it's already selected, but you'll have to reselect it. This was the problem with the data in the file... this transaction was somehow linked with the British Telecom security in the (SP) account rather than the BT security in the (RP) account.</p>
<p>That should get you back on track and I'll add a check to an upcoming version of MD to auto-correct this kind of situation or at least prevent this from happening again. Do you remember how this transaction was entered in the first place? If it was through an extension then it'd be good to check to see if there is a newer version of the extension available that fixes the problem, or maybe avoid that extension in the future.</p>
<p>Thanks,<br>
Sean</p>
<p>--Sean Reilly Developer, The Infinite Kind<br>
<a href="https://infinitekind.com">https://infinitekind.com</a></p></div>Sean Reillytag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-04-02T15:14:11Z2019-04-02T15:14:11ZInvestment Report - Duplicated Account<div><p>Hi Sean, many thanks - I should have mentioned when we spoke but I won't be able to access my PC to do this until Sunday. I will get back to you then - hope that's ok.</p>
<p>BR's</p>
<p>Ray</p>
<p>Get Outlook for Android</p></div>rayplayertag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912019-04-08T09:17:46Z2019-04-08T09:17:46ZInvestment Report - Duplicated Account<div><p>Hi Sean, I have just done as you suggested and it has fixed it, so many thanks.</p>
<p>I've not used an extension to enter transactions in the past so it would have been a manual entry.</p>
<p>Thanks Again</p>
<p>BR's</p>
<p>Ray</p></div>rayplayertag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912022-05-04T12:38:25Z2022-05-04T12:38:25ZInvestment Report - Duplicated Account<div><p>Hi, I'm not sure why but having fixed this issue the Duplicated Account has reappeared. It only came to light as I was investigating anomalies in the reporting - I have tried the same fix that was successful previously but to no avail.</p>
<p>From the above 'there are likely transactions in the Non-ISA BT Easyshare (RP, or maybe SP) that reference the security within another investment account'.</p>
<p>Does anyone know how to identify those transactions and fix?</p>
<p>Regards</p>
<p>Ray</p></div>rayplayertag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912022-05-04T13:24:09Z2022-05-04T13:24:09ZInvestment Report - Duplicated Account<div><p>Ok. If you’ve upgraded your MD version to something more recent, you can install / run the toolbox extension, update mode. Currency/security tools. You can try the ‘ FIX - Non-Hierarchical Security Acct Txns’ option.</p></div>Stuart Beesley (Mr Toolbox)tag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912022-05-05T09:40:13Z2022-05-05T09:40:13ZInvestment Report - Duplicated Account<div><p>Hi Stuart, that worked - it scanned and found a 'Must fix txn DIVIDENDXFR'.</p>
<p>Many Thanks</p>
<p>Ray</p></div>rayplayertag:infinitekind.tenderapp.com,2009-01-14:Comment/469697912022-05-05T10:56:22Z2022-05-05T10:56:22ZInvestment Report - Duplicated Account<div><p>Toolbox 🧰 +1 😃</p></div>Stuart Beesley (Mr Toolbox)