duplicate securties - need to be merged - i think

Blair's Avatar

Blair

28 Sep, 2023 08:26 PM

how to merge securities with duplicates

  1. 1 Posted by Stuart Beesley ... on 28 Sep, 2023 09:05 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Toolbox extension. Install. Then select ‘toolbox merge duplicate securities’ on the extensions menu.

  2. 2 Posted by Blair on 29 Sep, 2023 12:24 PM

    Blair's Avatar

    It does not work... see the attached error message

  3. 3 Posted by Stuart Beesley ... on 29 Sep, 2023 01:18 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    As it says, you have data issues. Have you tried running the fix it suggested?

    Toolbox. Update mode. Transaction tools.
    FIX - Non-Hierarchical Security Acct Txns (& detect Orphans)

    Then when your data issues are fixed, try again.

    BACKUP FIRST

  4. 4 Posted by Blair on 29 Sep, 2023 01:35 PM

    Blair's Avatar

    Where is this menu option?

  5. 5 Posted by Stuart Beesley ... on 29 Sep, 2023 01:47 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Have you launched the toolbox extension from the extensions menu?

  6. Support Staff 6 Posted by Maddy on 29 Sep, 2023 01:51 PM

    Maddy's Avatar

    You should navigate to Extensions->Manage Extensions->Install Toolbox
    Launch the Toolbox and select Update Mode
    Choose MENU: Transactions tools, finally choose the ‘ FIX - Non-Hierarchical Security Acct Txns (& detect Orphans) option.
    You should accept the disclaimer and follow the instruction on your screen.
    Finally, restart Moneydance.

    --
    Maddy, Infinite Kind Support

  7. 7 Posted by Blair on 29 Sep, 2023 01:54 PM

    Blair's Avatar

    No luck. i did this. just restarted md. not end of world. just trying to
    clean data.

    On Fri, Sep 29, 2023 at 9:51 AM Maddy <[email blocked]>
    wrote:

  8. Support Staff 8 Posted by Maddy on 29 Sep, 2023 02:14 PM

    Maddy's Avatar

    After running the fix in post 6 of this thread, have you tried this:

    Launch the Toolbox and select Update Mode
    Choose the MENU: Currency and Security tools, finally you can try the ‘FIX: Detect & Merge/fix duplicate securities within same Investment accounts'.

    You should accept the disclaimer and follow the instruction on your screen

    Finally, restart Moneydance.

    Please keep us posted on your progress, Thank you!

    --
    Maddy, Infinite Kind Support

  9. 9 Posted by Blair on 29 Sep, 2023 02:19 PM

    Blair's Avatar

    Ok. I think the issue is the securities may be in different accounts.

  10. 10 Posted by Stuart Beesley ... on 29 Sep, 2023 03:10 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    So yes, you have duplicate securities. Are these the ones you wanted to merge in your original thread? You can now run the merge duplicate securities feature.

  11. 11 Posted by Blair on 29 Sep, 2023 03:20 PM

    Blair's Avatar

    Correct.

  12. 12 Posted by Stuart Beesley ... on 29 Sep, 2023 03:25 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    👍

  13. System closed this discussion on 29 Dec, 2023 03:30 PM.

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