Trouble with two names for a security -- can't sell all

Posted by Patrick Nolan on September 4, 2007, 6:54 pm

Please log in for more thread options

I'm using Quicken Basic 2007 on Windows. I have an account which contains
a single mutual fund. It has monthly transactions dating back for several
years. Until last spring, about the time I updated to Quicken 2007, the
transactions had descriptions like "4.567 shares of Woohoo Fund @ 12.345".
Then the description changed to "4.567 shares of SEC_1 @ 12.345". I thought
it was a harmless annoyance until recently.

I sold off that fund completely. I tried to record this in Quicken by a
Shares Sold transaction, transferring the resulting cash to a new account.
When I click the box to sell all the shares in the account, it fills in
a number which is much smaller than the actual total (which is shown at
the bottom of the window). It turns out that this number is the total
number of shares added in the "CTL_1" transactions. It can't sell the
"Woohoo Fund" shares.

I tried a bunch of things. I filled in the correct number by hand, but
it told me that I was creating a short position. I tried to edit the
SEC_1 transactions to change the security name, but it wouldn't let me.
I tried to add new transactions to replace the existing ones, but
SEC_1 was the only choice for the security name. I ran a Sold Shares
transaction for the amount it would let me sell, then tried to sell
the rest, but it again told me I was selling short. It appears that the
selling thingie just doesn't recognize the existence of most of the
shares.

I reported this to Intuit by e-mail. Their response was that it must
be a corrumpted data file. That doesn't seem likely, but I went
through their file recovery and validation procedures. They didn't
show any sign of corruption. I think it's a bug.

Does this sound familiar to anyone?

Posted by John Pollard on September 4, 2007, 8:00 pm

Please log in for more thread options

Patrick Nolan wrote:

> I'm using Quicken Basic 2007 on Windows. I have an account

> which

> contains a single mutual fund. It has monthly transactions

> dating

> back for several years. Until last spring, about the time I

> updated

> to Quicken 2007, the transactions had descriptions like "4.567

> shares

> of Woohoo Fund @ 12.345". Then the description changed to

> "4.567

> shares of SEC_1 @ 12.345". I thought it was a harmless

> annoyance

> until recently.

> I sold off that fund completely. I tried to record this in

> Quicken

> by a Shares Sold transaction, transferring the resulting cash

> to a

> new account. When I click the box to sell all the shares in

> the

> account, it fills in

> a number which is much smaller than the actual total (which is

> shown

> at

> the bottom of the window). It turns out that this number is

> the total

> number of shares added in the "CTL_1" transactions. It can't

> sell the

> "Woohoo Fund" shares.

> I tried a bunch of things. I filled in the correct number by

> hand,

> but

> it told me that I was creating a short position. I tried to

> edit the

> SEC_1 transactions to change the security name, but it

> wouldn't let

> me.

> I tried to add new transactions to replace the existing ones,

> but

> SEC_1 was the only choice for the security name. I ran a Sold

> Shares

> transaction for the amount it would let me sell, then tried to

> sell

> the rest, but it again told me I was selling short. It

> appears that

> the selling thingie just doesn't recognize the existence of

> most of

> the

> shares.

> I reported this to Intuit by e-mail. Their response was that

> it must

> be a corrumpted data file. That doesn't seem likely, but I

> went

> through their file recovery and validation procedures. They

> didn't

> show any sign of corruption. I think it's a bug.

> Does this sound familiar to anyone?

I think the problem did stem from corruption ... but is
aggravated by the use of a Single Mutual Fund account.

Go to the Summary tab of the account and click "Yes" next to the
Account Attribute named "Single Mutual Fund?" to change the
account to be able to hold multiple securities.

Then I suspect you can sell all shares of both securities in two
separate transactions, or change the name of "SEC_1" to "Wahoo"
in all the transactions where it occurs, then create one sell
transaction for Wahoo.

--
John Pollard
First initial underscore Last name at mchsi dot com
Please reply to newsgroup

Posted by Patrick Nolan on September 5, 2007, 12:45 am

Please log in for more thread options

> Patrick Nolan wrote:

>> I'm using Quicken Basic 2007 on Windows. I have an account

>> which

>> contains a single mutual fund. It has monthly transactions

>> dating

>> back for several years. Until last spring, about the time I

>> updated

>> to Quicken 2007, the transactions had descriptions like "4.567

>> shares

>> of Woohoo Fund @ 12.345". Then the description changed to

>> "4.567

>> shares of SEC_1 @ 12.345". I thought it was a harmless

>> annoyance

>> until recently.

>> I sold off that fund completely. I tried to record this in

>> Quicken

>> by a Shares Sold transaction, transferring the resulting cash

>> to a

>> new account. When I click the box to sell all the shares in

>> the

>> account, it fills in

>> a number which is much smaller than the actual total (which is

>> shown

>> at

>> the bottom of the window). It turns out that this number is

>> the total

>> number of shares added in the "CTL_1" transactions. It can't

>> sell the

>> "Woohoo Fund" shares.

>> I tried a bunch of things. I filled in the correct number by

>> hand,

>> but

>> it told me that I was creating a short position. I tried to

>> edit the

>> SEC_1 transactions to change the security name, but it

>> wouldn't let

>> me.

>> I tried to add new transactions to replace the existing ones,

>> but

>> SEC_1 was the only choice for the security name. I ran a Sold

>> Shares

>> transaction for the amount it would let me sell, then tried to

>> sell

>> the rest, but it again told me I was selling short. It

>> appears that

>> the selling thingie just doesn't recognize the existence of

>> most of

>> the

>> shares.

>> I reported this to Intuit by e-mail. Their response was that

>> it must

>> be a corrumpted data file. That doesn't seem likely, but I

>> went

>> through their file recovery and validation procedures. They

>> didn't

>> show any sign of corruption. I think it's a bug.

>> Does this sound familiar to anyone?

> I think the problem did stem from corruption ... but is

> aggravated by the use of a Single Mutual Fund account.

> Go to the Summary tab of the account and click "Yes" next to the

> Account Attribute named "Single Mutual Fund?" to change the

> account to be able to hold multiple securities.

> Then I suspect you can sell all shares of both securities in two

> separate transactions, or change the name of "SEC_1" to "Wahoo"

> in all the transactions where it occurs, then create one sell

> transaction for Wahoo.

Thanks. Your first solution did the job.