In addition to what Dick suggested you can use the age-old divide and
conquer process:

In a COPY of your data file, delete half of the accounts (be sure to include
Closed accounts) and see if the problem can be reproduced, if it still can,
in another COPY delete the other have and try to reproduce. If it still
fails, try deleting ALL accounts and create a new one to confirm if it
works. If it works in that instance it may actually be two or more accounts
with problems, so you may need to widdle it down a few accounts at a time.
If deleting all accounts and working in a new file still fails, then it may
be investment specific.
Repeat with half of the accounts that still reproduced the problem until you
narrow it down to a specific account.
Then repeat at the transaction level to identify which specific transaction.

-Mark


"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:etTT4UD%23EHA.4028[at]TK2MSFTNGP15.phx.gbl...
- quote -

You could open a support case, but it probably won't get far.

I'd go transaction and investment transaction reports customized to open the
aperture to all accounts, all dates to see if any of them bomb. If any do,
you can narrow down from there.

Do you have any older progressive backups? If so, you can test in those and
maybe narrow down to a recent window of time where the problem crept in.

You might also try some MoneyLink account transaction and investment
transaction extractions. Who knows what you might find.

The problem with deleting unused investments is that they are never really
deleted. I'm not sure of a way around this.

Have you tried Salv?

I'm running out of ideas. Sorry.

"Tom" <tom[at]nospam.com> wrote in message
news:um5phLD%23EHA.2804[at]TK2MSFTNGP15.phx.gbl...
- quote -

In microsoft.public.money, Tom wrote:

- quote -

Archive is unlikely to help and does not affect investment accounts

- quote -

While it is unlikely to help, try your salv.exe/StandardFileRepair
with perhaps level 1, level 2, and level 1 again. Rarely that can
help.

You could consider QIF export/import. If you choose to do so, to
avoid transfers from turning into two separate transactions, it
is important to import the QIFs into the new file all at once.
This is done by selecting using Ctrl+<click> to highlight all of
the files you want included. Further, before doing the import,
the QIF files containing the investment cash accounts
should be named something alphanumerically higher than the
investment transactions of the account. So you could have
"Merrill" and "Merrill Cash", but you would not want "Merrill Inv"
and "Merrill Cash". "_Merrill Inv" and "Merrill Cash" would be
good. So one way around this is to export investment accounts to
files who's name starts with an underscore.



- quote -

Perhaps.

Dick: I agree with you completely on your first statement; unfortunately, I
just don't know what else to do at this point. Yes, I have VMware so I
installed MS Money 2005 in a virtual machine (so I could play with the
file); upgraded it; then went thru everything. I even went so far as to
completely delete the entire investment account itself and the individual
investments I was using and then recreate everything from scratch. Still had
the exact same problem. So even deleting and recreating the entire account
doesn't seem to work. And I can't just delete all of my investments, since I
have years and years of them and it would be a nightmare to recreate
everything (which is why I really don't want to rebuild my entire file!)

I don't know what else to try. If I knew what kind of transaction or
whatever might cause this error to occur I could look for it, but as it is I
don't even know what to look for. Again, it would be really nice of
Microsoft if they actually gave us a useful error message rather than
'Transaction cannot be entered' - that doesn't tell me anything.

I guess the only thing I can do is go thru things, looking for anything that
looks 'odd'. I may archive all transaction earlier than 1/1/2000 anyway,
since we moved then and those transactions are kinda useless (and maybe that
would get rid of whatever is causing the issue). Other than that I don't
know what else to do.... maybe I should file an issue report with Microsoft?

Tom


"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:OzogFNB%23EHA.1260[at]TK2MSFTNGP12.phx.gbl...
- quote -

I think that doing anything that leaves a "cannot be entered" problem
floating about in your file is not a good thing.

There are probably things you can do short of rebuilding the entire file.
Did you try the account deletion thing I proposed? You can even try it in a
copy of your file just to see if it solves anything.

You might also rename the investment that causes the problem. Or delete the
original buy and then delete the investment definition. Try to sneak up on
it...

"Tom" <tom[at]nospam.com> wrote in message
news:uJLaH3A%23EHA.1260[at]TK2MSFTNGP12.phx.gbl...
- quote -

Dick: Well, I tried setting up a completely new file, with just a fake
checking account and then added a CD account. There it works perfectly. So
yes, something is screwed up within my file - what, I don't know. Everything
looks fine. I did a full 'repair' on the file, and as before, all it did was
increase the size of my file 20MB - the CD stuff still doesn't work. No
matter what I do, trying to do a Redeem or Renew CD simply doesn't work with
my file. And I really don't want to go thru the process of trying to rebuild
my file from scratch, since I have at least 7 years of data in there!

I have come up with one way to do this, although it is stupid. Basically, I
delete and recreate the account as a regular investment account. Then I add
the CDs as 'Other' investments, and basically treat it as a money market
type of investment. I will then have to manually do what the CD wizard would
do; i.e. Transfer money in; 'Buy' the CD with a new investment (labeled
something like 'My CD #4235 6/04') and buy it as $xxxx at $1 each. Then,
when it is due for renewal, I 'Reinvest Interest' at whatever, then 'Sell'
it for the base amount + interest, then turn around and 'Buy' a new
investment labeled something like 'My CD $4235 6/05'. Then, of course, when
I actually redeem it, I would 'Sell' the investment + interest, and then
transfer that money out of the investment's Cash account to whereever I
wanted it.

Stupid, I know, but I think this would at least get me up and running and
past this idiotic error message. What do you think?

Tom

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:uG3%23g8$9EHA.3592[at]TK2MSFTNGP09.phx.gbl...
- quote -

I'm thinking this is probably not a CD Investment problem, per se. That
error message usually indicates somehow Money has munged up its own file.
(Also not a good thing, but it'll do this pretty much anywhere it wants when
it gets a mind to do it.) See http://umpmfaq.info/faqdb.php?q=104. In your
case, I'd probably just try to delete the Investment Account and have
another go at it. I might also try setting up the basic cases in a test file
just to see how it all works before having a go in my main file. Good luck.

"Tom" <tom[at]nospam.com> wrote in message
news:eZ3BEc$9EHA.3368[at]TK2MSFTNGP10.phx.gbl...
- quote -

Dick: I got around to looking at this again.... I am really getting
frustrated with how Money handles CDs.

OK, anyway, so I decided to just delete the CD and start over from scratch.
So I got rid of the transactions, then deleted the CD investment account. I
set up a new investment account, and transferred the money into it's related
Cash account; then I did a BUY to buy a new CD, dating it back to 2002 when
I actually purchased the CD. Even added a new investment itself for the CD
(like New CD 9 Months). Then I immediately added another transaction for
'Renew CD' dating it to 2003 when I did renew the CD. I put in the amount of
the CD, then added in the interest. Still, no matter WHAT I do, I end up
with this same stupid error, 'This transaction cannot be entered'. This is
on a new investment account, with only two transactions! I am at my witts
end, it just seems that Money cannot handle this at all.

I don't know if it is something with my file, or with Money's settings, or
what, but do you have any other ideas as to how to get this to work? I
cashed in one of my CDs (the interest was just too puny) but I can't even
tranfer the money out of it because nothing I do will let me work with this
investment account. Any additional advice appreciated. Thanks.

Tom

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:%23pdEVN07EHA.1564[at]TK2MSFTNGP09.phx.gbl...
- quote -

The increase in file size is probably temporary until the next compacting
cycle. I'm not sure that treating interest one way or the other will cause
this problem. Good luck sorting this out.

"Tom" <tom[at]nospam.com> wrote in message
news:%23WU50yz7EHA.3416[at]TK2MSFTNGP09.phx.gbl...
- quote -

Dick: Well, I tried doing the file repair (the full standard one) but all it
did was increase the size of my data file by 20MB.... Otherwise, I still get
the message.

I think I am going to have to delete the CDs and then redo them, and just
put the interest at the end when I renew them. That may be the problem, I
never did a 'renew CD', I just added the interest and kept it going. Maybe
that is the issue, who knows with Money 2005???

I'm going to ask another question regarding rebuilding my file, but I'll do
that in another message.

Tom

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:uk5ja5t7EHA.2700[at]TK2MSFTNGP14.phx.gbl...
- quote -

CDs have been a non-subject for years and all of a sudden they are a hot
topic. Must be a reflection of the state of the market or something.

The "Design Intent of Money", apparently, is that CDs are each treated as a
unique Investment bought with a Buy transaction and held in an Investment
Account with an Associated Investment Cash Account. Interest can be recorded
at the end when you enter a Redeem CD transaction or when you use the macro
"transaction" Renew CD. Or you can record it on the fly with Reinvest
Interest. If you do this, then you will have to account for the original
purchase value plus all of the reinvested interest as the "quantity" of the
investment you ultimately redeem or renew. I think recording interest every
month or only at the end is personal option; however I've never actually
invested in a CD in Money. (But I did stay at a Holiday Inn Express last
night...)

See these threads for more:
http://groups-beta.google.com/groups...dr=m&lr=&hl=en

Play around with it--maybe in a new file you create just to play--and work
on the file repair and let us know how it goes.

"Tom" <tom[at]nospam.com> wrote in message
news:eumiyWt7EHA.3376[at]TK2MSFTNGP12.phx.gbl...
- quote -

Dick: I'll try repairing my file and see if that helps (as per the faq).

However, it is possible I haven't recorded or been recording activity to
these CDs propery. Exactly how should we use Money with Certificates of
Deposit? How should we set up the account? What about interest? (record it
monthly or what) And renewal of the CD? And finally cashing in of the CD?
There is NOTHING that I can find in the Money help files that describes this
fully. Maybe I have been doing it wrong or something.

Tom

"Dick Watson" <littlegreengecko[at]mind-enufalready-spring.com> wrote in
message news:OOXTTor7EHA.3756[at]TK2MSFTNGP14.phx.gbl...
- quote -

Indeed that's the true joy of that message. It tells you something it
doesn't want to do. Not a hint why, nor what you might be able to do about
it. It's been that way for years. You'd think the programmers could make it
do something useful there. You'd be wrong.

See http://umpmfaq.info/faqdb.php?cat=14.

"Tom" <tom[at]nospam.com> wrote in message
news:ehaJ1Or7EHA.3616[at]TK2MSFTNGP11.phx.gbl...
- quote -

I have an investment account that I use to track two Certificate of Deposits
that I own. I have cashed in one of them and have renewed the other one.
When I attempt to enter a REDEEM CD activity, it always tells me ' This
transaction cannot be entered'. That's it - no other explaination! I am not
sure what I am doing wrong nor what to do next. I had set up this
investmenet account a couple of years ago, and I think I set it up with no
cash account (interest was automatically being reinvested into the CD).

Any ideas as to why I cannot redeem one of my CDs? This error message means
nothing....

Tom