Moving a transaction
As programmed in the former Quicken 2007 for Mac program, can a transaction be moved from one register to another? Please explain how if it can be done or the MD equivalent. Thanks
As programmed in the former Quicken 2007 for Mac program, can a transaction be moved from one register to another? Please explain how if it can be done or the MD equivalent. Thanks
2 Posted by -Kevin N. on 22 Aug, 2011 02:59 PM
Hi hunterbob,
Right click the txn in question, choose Batch Change > Account. Select the Accoun that you want to move the txn to from the drop-down list.
This assumes that you are working from within a regualar account and not from within an income or expense category register.
There are restrictions to Batch Change. It cannot be performed on certain investment transactions.
HTH -Kevin N.
3 Posted by sth on 01 Jan, 2012 06:27 PM
This seems to come up all the time. See http://help.infinitekind.com/discussions/problems/940-moving-invest...
However, the documentation seems to say as above that it doesn't work some of the time (ie there are restrictions). BUT the documentation does not say what those restrictions are. Supposedly moving transactions between two investment accounts is not allowed. I am not sure of the restrictions, I added the security to the destination account but ended up doing it by hand.
I was refactoring an account that had combined two different brokerages for an IRA. To adequately download transactions I needed to break it out into separate accounts. When batch changing the transactions I should simply have been able to change the account and have it add the same security to the destination account.
At worst MD should not just fail silently but tell me, that it can't move it since the security doesn't exist in the destination account, the currencies are different for the two accounts, or that you just can't move a transaction from an investment account.
In the last case the menu item for moving the transaction should not be displayed or should be greyed out. In any case the software should inform me with a meaningful message that moving the transaction is not allowed and why.
Alsot he manual for those who do RTFM does not list the restrictions on moving transactions either. The action item mentioned in the link above does not seem to be on the activity fix list.
Moving transactions should be allowed just as moving securities.
Support Staff 4 Posted by Ben Spencer on 02 Jan, 2012 03:21 PM
You are correct moving transaction from investment accounts is not permitted as this could result in a transaction in investment account A referencing a security held in investment account B.
I agree that the user interface should make this clearer and have filed a ticket in our issue tracking system.
Ben Spencer
Moneydance Support
5 Posted by sth on 02 Jan, 2012 06:54 PM
But if the security has already been added to investment account B then it should reference that security in the new account? Worst case it should automatically add the security to investment account B.
Support Staff 6 Posted by Ben Spencer on 02 Jan, 2012 07:02 PM
Even if the security already exists in account B the transaction will still point at the security in account A.
I agree it would be ideal that when an investment transaction were moved from one account to another it would create the security in the destination account and re-point the transaction to the security in the destination investment account and currently that is not how the system works.
I am sorry that this does not currently meet your needs.
Sincerely
Ben Spencer
Moneydance Support
7 Posted by sth on 02 Jan, 2012 07:13 PM
As I said, I dealt with the problem but it took a bunch more time and typing than it should have. Maybe this "ideal" as you call it should be a "suggestion"? This would certainly be an enhancement for the "move transaction" feature.
Actually I am sort of confused as to why internally a security is different in different accounts?
I was hoping that the ticket in your issue tracking system would be a more substantiative change than just updating the interface, manual and error reporting. If it helps I will start a thread in the suggestions thread?
Support Staff 8 Posted by Ben Spencer on 13 Jan, 2012 01:56 AM
I encourage you to start a thread with a detailed description of the suggestion.
With regard to the confusion about a security in an investment account.
When a security is added to an investment account a sub account is created for that investment account. The currency used on that sub account is the security type. When you buy shares in a security you are essentially making a transfer to the investment sub account for that security.
Ben Spencer
Moneydance Support
9 Posted by Steve J on 27 Jan, 2012 11:29 PM
I have a similar problem, so i figure i'll post it here. I have 10yrs back-data that i transferred over from Quicken for Windows. I did it straight over from the Windows .QIF version. On investment accounts, it decided to blend two similarly named accounts at Ameritrade - an IRA and a regular trading account. Now, i can't go back and move them, it seems, per the attempt at batch txfr, but i also can't edit them. The worst case would be for me to delete the transaction that decided to get populated in my regular account and re-enter in the IRA acct, however when i tried to do so, it wouldn't let me input the transaction. Am i missing something? I thought it was due to older data, but it won't let me input anything in this specific investment acct. ideas/solutions?
10 Posted by -Kevin N. on 27 Jan, 2012 11:42 PM
Hi Steve J.
Since you've already done the hard part of narrowing the problem down to the similarities in the naming of the Ameritrade accounts. Perhaps you could go back into Quicken, rename one of the Ameritrade accounts and then re-do the import into a new MD data file.
HTH -Kevin N.
11 Posted by stevej_usc on 27 Jan, 2012 11:53 PM
i wish that was it, but i can't input new transactions into the accounts. that didn't make sense to me. so yes, i think i could go back and re-import with new names, but that doesn't change the fact that you can't edit old information or i can't create new transactions for an investment account. i try to put a "buy" for new shares, for example, but it forces it back to "xfr" - like all of the transactions to be inputed have that pre-req. is there a way to stop that forced activity in MD?
this is really important and is one of the things stopping me from buying it vs. the trial version i'm on.
12 Posted by -Kevin N. on 28 Jan, 2012 12:07 AM
Hi Steve,
The problem that you are having wherein the 'Buy' Action changes back to 'Xfr' sounds like you haven't added any securities to the investment account.
To Add a security to the account, go to the 'Securities Detail' view of the investment account and click on the 'Add Security' button. In the resulting form, either choose an existing security from the drop down list or click the 'New Security' button. Fill in the particulars of the new security.
After you Add the security to the account the 'Buy' Action will become available in the register and the security will be listed in the drop down list of the 'Security' field.
Again you might just want to give the re-do a try with a different Ameritrade account name.
HTH -Kevin N.
13 Posted by -Kevin N. on 28 Jan, 2012 12:11 AM
Hi Steve,
I forgot to metion that to Edit a txn, highlight it and press ENTER to put the txn into Edit mode.
HTH -Kevin N.
14 Posted by stevej_usc on 28 Jan, 2012 12:31 AM
ha! i hope i knew that step in advance! though i'm sure you get all types on these boards. thanks - i'll try the "add security" and see what transpires...
thx for quick response.
15 Posted by stevej_usc on 01 Feb, 2012 12:01 AM
i have a problem on the import from a .qif file for windows quicken. i did the download as one full transfer from quicken into a new file. however, the main banking account i use only imported data since 2007. so the last 10 years before that just disappeared and then were thrown separately onto a batch dump of data, i think, with all the same date. Any idea how better to make this transfer work? do i have to individually download each .qif for each account?
16 Posted by -Kevin N. on 01 Feb, 2012 12:43 AM
Hi Steve,
Is it possible that when you imported the .QIF file that you set a different 'Date Format' on the 'Import QIF File' form?
Look to this Knowledge base article of possilbe problems of imoporting .QIF files.
http://help.infinitekind.com/kb/importing-from-quicken-or-ms-money/...
HTH -Kevin N.
17 Posted by stevej_usc on 08 Feb, 2012 08:18 PM
I have completed the migration from quicken to moneydance, and there are a few issues with securities that i hope you have a quick fix for. There are some names that weren't exact, but are the same security, and mapped over as similar names. I would like to simply have moneydance recognize that the two securities within the same 401k account are the same, and thus combine them (two examples: one is "MidCap Value", one is "Mid Cap Value"; more challenging one was listed as a number 108A, vs. Amana Growth", say. I didn't know how to map them until after the import was complete and i don't want to have to go back and delete the transactions and delete the securities to reimport an .ofx or .qif of partial data. Is there a "find and replace" or similar method for the securities that works quickly?
18 Posted by sth on 08 Feb, 2012 09:18 PM
Steve, you can do a find for "MidCap Value", select all and then do a batch change to "Mid Cap Value"? Then delete the security "MidCap Value". I don't have it open at the moment to check this but it should work.
THere is a "Find and Replace" extension that may also do their but I haven't played with that much.
Make sure that you delete the correct one! :-)
19 Posted by -Kevin N. on 08 Feb, 2012 09:53 PM
Hi Steve,
I don't think Batch Change is available as a means to change a security.
I'm afraid that there may not be an easy or automated way to correct this matter.
What you can try is to, access the account in question.
Type, MidCap Value into the 'Search' field in the upper right-hand corner.
This should segregate all of the MidCap Value entries.
Go through each entry and change the 'Security' field to Mid Cap Value.
If this is the only account that holds MidCap Value entries, you should now be able to safely delete the MidCap Value security.
If when you go to delete MidCap Value, you recieve a warning that there are existing txns, then you'll need to do some further investigation as to where they reside.
HTH -Kevin N.