Correction of Information from Sold Security

John William Digby's Avatar

John William Digby

22 Aug, 2023 04:37 AM

First Problem: Looking in my Investment account I noticed an investment that I have sold has the incorrect information. Not a big issue but when trying to correct it in the 'Register View' under 'Security Heading' I cannot correct it obviously because I no longer have that security in the register. Is it possible to correct that?
Second Problem: Just want to know the correct way about doing a 'Scheme Of Arrangement' takeover.. I want to keep all the information / history for what might be needed for taxation time. The company has had several name changes, and that is something I now find I should have recorded correctly. Currently TSN have being absorbed into EXL with shareholders in TSN given 1.1225 in EXL (Elixinol) for every share held in TSN. What would be the best way to do this update and therefore being able retain history

  1. 1 Posted by Stuart Beesley ... on 22 Aug, 2023 04:49 AM

    Stuart Beesley (Mr Toolbox)'s Avatar
    1. You can change the information on a txn even after you sell it, so this is not the problem. The screenshot is grey indicating the txn is not selected.. Have you tried double clicking the txn to edit?

    2. Do you want to keep the security in the same investment account? If yes, it sounds like you need to:
      a) use tools/securities and edit / change the name
      b) in the same place enter a 'split' (bottom of same window) for 1.1225 to 1 on the correct date.

    The only other option is to sell the security and buy it back as the new security.

    But others may have other views

  2. 2 Posted by John Digby on 22 Aug, 2023 06:57 AM

    John Digby's Avatar

    Hi Stuart
    Thanks for the reply.
    Yes have double clicked on the text to try and edit but because the stock
    is no longer in the portfolio (being sold) it is not in the drop down list.
    It would have been grey because of using the snipping tool.
    The second question, if I change the name,will that apply from the
    purchased date, or from change name date? I can see where to do all that
    but I was trying to keep history as well. I guess if not I could add
    details somewhere as a comment.

  3. 3 Posted by Stuart Beesley ... on 22 Aug, 2023 07:02 AM

    Stuart Beesley (Mr Toolbox)'s Avatar
    1. Selling the security does not remove it from the account.. It sounds like you are trying to reference a security that has never been in the account? Click Securities Tab, top right, actions, add security to account. Is it there?

    2. If you change the name then the name is changed - it's as if it's always been the new name.. It's just the name, impacts nothing else. However, the split will effect from the date you provide.

  4. 4 Posted by John Digby on 22 Aug, 2023 09:18 AM

    John Digby's Avatar

    Hi
    Thanks again, there is something happening.
    We have two Investment accounts. One is in joint names and the other in my
    name made up of four securities.
    On the Opening Home Page - Summary page it shows both Investment accounts.
    When I select the joint account where both these issues relate to and
    follow your suggest;

    Securities Detail

    Actions

    Add Security

    (It only has the securities of my single account?)

    If I follow the same procedure for the single account and click on Add
    Security , I get all the securities of the Joint Account. It seems
    somewhere we have a problem, Housten? Although what is not in that list is
    the security Inghams that was sold, where the line issue is that I am
    trying to correct.

  5. 5 Posted by Stuart Beesley ... on 22 Aug, 2023 09:34 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Install/run toolbox extension. When you run it, is there a popup with warnings?

  6. 6 Posted by John Digby on 22 Aug, 2023 09:51 AM

    John Digby's Avatar

    I will try that. First thing in the morning. Thanks for your help.

  7. 7 Posted by Stuart Beesley ... on 22 Aug, 2023 11:02 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    👍 my guess is that you have cross linked / non-heirarchical txns. If so, it will tell you. Run the fix.

  8. 8 Posted by John Digby on 22 Aug, 2023 09:06 PM

    John Digby's Avatar

    Yes
    We have a warning " ERROR - Cross-linked (or Orphaned)security txn(s)
    detected.. Review Console!"
    >> Run 'FIX: Non- Hierarchical Security Acct Txns (& detect Orphans)'...
    What is the next step?

  9. 9 Posted by Stuart Beesley ... on 22 Aug, 2023 09:34 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Tick update mode (top menu bar).
    Then click transactions button. And click the fix option as named above.

  10. 10 Posted by John Digby on 22 Aug, 2023 11:04 PM

    John Digby's Avatar

    Hi
    Have run the fix, but it doesn't appear to have worked. We still have
    different stock for the different accounts and also we now have a security
    in the 'Add New Security" drop down list TOOLBOX: FIX NON HIERARCHICAL
    SECURITY ACCT TXNS??

  11. 11 Posted by Stuart Beesley ... on 23 Aug, 2023 05:43 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    The fix has done its Job. It's just that this may or may not been your problem. What would be very helpful if you provided the detail of the messages that you were presented with when the fix was running? What did it say? Please upload the log that was displayed at the end.

    However, I am making a guess, given the toolbox fix, that you manually clicked the Actions/Remove security from account previously whilst there were transactions in the account for that security. This would have damaged your transactions.

    Q1: What txns in the account have the new 'toolbox' security shown against them?

    Q2: Can you try adding the missing security to the account again now?

    Q3: Can you try editing the txn again?

    Q4: After this, grab help/console and upload the contents here...

  12. 12 Posted by John Digby on 23 Aug, 2023 06:08 AM

    John Digby's Avatar

    Okay
    Where do I download the Log from?
    Q2 If I try adding the missing security I only have the option from the
    Single Account nothing for the Joint Account
    Q3. ? Not sure what you mean there.

  13. 13 Posted by Stuart Beesley ... on 23 Aug, 2023 06:34 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    The log is gone.. If you didn't read it or capture then that info is lost now.

    Q1: ??
    Q3: Can you try editing the transaction again - which was your original problem?

    OK, You are going to have to start seeing screenshots that demonstrate the issue - and also screenshots that show what you are trying to do working elsewhere.

  14. 14 Posted by John Digby on 24 Aug, 2023 06:01 AM

    John Digby's Avatar

    Hi
    Moneydance 02 is a screenshot of the Joint Account although when you click
    on 'Securities Detail' then 'Action ' 'New Security' what shows in the
    Security Details Drop Down is the Securities from the *Single Account.*
    Moneydance 03 is a screenshot of the single account although when you click
    on 'Securities Detail' then 'Action ' 'New Security' what shows in the
    Security Details Drop Down is the Securities from the *Joint Account*
    So what I tried to correct the original entry in the Joint account but only
    Single Account securities are available.

  15. 15 Posted by Stuart Beesley ... on 24 Aug, 2023 07:27 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    OK, I think you are misunderstanding what you are seeing when you select actions/add security. In the dropdown box you see securities, from the tool/securities (master) screen, that are NOT already in that account.

    Thus, if you have securities A, B, C in tools/securities; and Accounts X, Y, Z.

    In Account X you hold Security A
    In Account Z you hold Security B

    If you then go into account X, actions, add security, in the dropdown box you will only see securities B & C

    In Account Z, add securities, you will only see A & C.

    If this is in effect what you are seeing, then it would seem nothing is wrong.

    Try this. Actions/Remove Security. In the dropdown box do you see the security you think is missing in the remove dropdown box? (Do not actually click the remove).

    Then as a second test.. Toolbox. Menu Current and Security tools, DIAG: Can I delete a Security (where used).. Select the security you think is missing.. What does the report say?

  16. 16 Posted by John Digby on 24 Aug, 2023 08:01 AM

    John Digby's Avatar

    Hi
    Thank you for your patience. Yes I can see and understand what you are
    saying in the first part of your reply. It would be like saying I wish to
    Add security into B Account from A Account.
    I do have a couple of securities that have been sold but are still showing
    in the 'Security Prices ' manual entry drop box so that would be the way to
    Remove Security Action - Remove Security. Although as per your second part
    of your reply that would depend on the message after clicking on Proceed.
    The screen shot I have attached is one of those securities.
    I do appreciate the time you have taken with this. My original issue was
    trying to correct a line entry in the Register View. Bearing in mind the
    shares were sold and I suspect I must have used 'Removed Security' and
    that would be why it is not in any drop down list?

  17. 17 Posted by Stuart Beesley ... on 24 Aug, 2023 08:11 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Can you email me. I think direct contact would be easier...:
    ...

  18. 18 Posted by Stuart Beesley ... on 28 Aug, 2023 09:06 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    For anyone watching… The issue was that Actions/Remove Security was used in an investment account even though there were existing transactions for this security. This would have removed the security from those txns and then removed it from the account. As the security was not used elsewhere, this also deleted it from tools/security master also.

    NOTE: the resulting txns will be damaged. Records of buy/sells will be broken. Dividends will be ok, but will show no security.

    So, the basic fix is to:
    - run toolbox to fix non-hierarchal transactions.
    - add the security back to tools/securities and then add it back to the account. Then edit the txns and assign the security back to the txns (or recreate them).

    NEVER REMOVE A SECURITY from an investment account when there are transactions referencing that security, even if you have ‘sold’ the balance to zero.

    NOTE: recent versions of MD now block this action..

  19. System closed this discussion on 27 Nov, 2023 09:10 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac