Reconcile Problem

[Ian]

After converting my quicken file to Money I find that the reconcile status of
my transactions are not correct. For example in one account all transactions
were reconciled in Quicken but after converting to Money many ( several
hundred ) transactions are now unreconciled. This means I cannot balance the
account, the start balance calculated by money is incorrect.
Is there a way to change these several hundred transactions to reconciled
without needing to select each one individually?

Thanks.

[Cal Learner]

In microsoft.public.uk.money, Ian wrote:

If you wish to start fresh and declare an account balanced, you can
mark all entries balanced. Select to show only unreconciled
transactions. Sort by date, and go to the oldest transaction.
Hold down Cntl+Shift+M and let auto-repeat work thru the
transactions until none are left showing. Then balance making the
starting and ending balance match the known balance. Choose the
balance date to be the day after your last transaction.

[Ian]

Cal,

Thanks for the feedback. I tried but no success. Could you be more specific
in describing the process?
I display the bank account in question, change the view to show only
unreconciled transactions, sort by date, select the oldest one ( ie left
click the row which then turns yellow ), press cntrl+shift+M but nothing
happens. The selected transaction does not change and no "auto repeat"
happens. I can find no way to select multiple transactions in this register.

What am I doing wrong?

Thanks.

[Cal Learner]

In microsoft.public.uk.money, Ian wrote:

>Cal,
>
>Thanks for the feedback. I tried but no success. Could you be more specific
>in describing the process?
>I display the bank account in question, change the view to show only
>unreconciled transactions, sort by date, select the oldest one ( ie left
>click the row which then turns yellow ), press cntrl+shift+M but nothing
>happens.

Ctrl+shift+M should toggle the status to R (reconciled). When you
depress the M, make sure the Ctrl and Shift keys are already down.
Since you are only displaying the unreconciled transactions, that
transaction should disappear from view.

Also, Sort Increasing.

[Ian]

Cal,

Try as I may I cannot get cntrl+shft+M to work. There is no response at all.
I am using a English / Japanese keyboard (my wife is Japanese), do you think
this may be the cause of the problem? Is there any way to check what Windows
receives when I press this key combination?

[Cal Learner]

In microsoft.public.uk.money, Ian wrote:

>
>Try as I may I cannot get cntrl+shft+M to work. There is no response at all.
>I am using a English / Japanese keyboard (my wife is Japanese), do you think
>this may be the cause of the problem? Is there any way to check what Windows
>receives when I press this key combination?

I don't know about this, but I expect that your suspicion is right.
Perhaps somebody in a group more tuned to the OS would know about
that.

I would probably see if I could do a clean boot and run Money. The
reason I would try this is if there is some software running that
might be intercepting that key combination. In fact, I might try
safe mode, but I don't know if Money will run in safe mode.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;310353
describes selective startup or clean boot. It is referenced by
http://support.microsoft.com/default.aspx?scid=kb;en-us;310560
which describes "How to Troubleshoot By Using the Msconfig Utility
in Windows XP". Perhaps with those you can install without the
problem.

If it is just the keyboard, perhaps you could set up to use a
different keyboard temporarily. I suspect a friend would lend you
one if you don't have one.

Another possibility would be to copy your Money file to a different
computer with the same version of Money installed, do the deed, and
copy the file back. Keep an extra copy or backup in case something
goes wrong.

These are just ideas, not known solutions.

[Ian]

Cal,

Tried safe mode but no change. Will try an OS related newsgroup, any
suggestions?

In the meantime something strange. I used the Find & Replace function to
search for all unreconciled transactions in the bank account. It found and
displayed them ( all 661 of them.... ). I then double clicked one of these
transactions in the result window of find and replace to edit it. In the
resulting window I tried cntrl+shift+M and it worked! The text "Reconciled"
appeared in the box. So it seems in this case my keyboard CAN enter
cntrl+shift+M. Only problem is I then have to do this one at a time which is
extremely tedious and I have several such accounts.

So maybe this is not a keyboard problem after all?

Are you sure cntrl+shift+M works in the account window?? Maybe this advice
is for a previous version of Money and the current version does not support
it?

[Cal Learner]

In microsoft.public.uk.money, Ian wrote:

>
>
>Tried safe mode but no change. Will try an OS related newsgroup, any
>suggestions?
>
>In the meantime something strange. I used the Find & Replace function to
>search for all unreconciled transactions in the bank account. It found and
>displayed them ( all 661 of them.... ). I then double clicked one of these
>transactions in the result window of find and replace to edit it. In the
>resulting window I tried cntrl+shift+M and it worked! The text "Reconciled"
>appeared in the box. So it seems in this case my keyboard CAN enter
>cntrl+shift+M. Only problem is I then have to do this one at a time which is
>extremely tedious and I have several such accounts.
>
>So maybe this is not a keyboard problem after all?

That would appear to be the case. It would also seem to make it less
likely it was an OS-related problem.

>
>Are you sure cntrl+shift+M works in the account window?? Maybe this advice
>is for a previous version of Money and the current version does not support
>it?

One thing you might try: in the account register you can toggle
between single-line and multi-line with Ctrl+T.

Could it be that that would shake something loose? I am just taking
a stab.

Regarding version, I doubt this would be a version-related
difference, or others would have commented that Ctrl+Shift+M does
not toggle the Reconciled status for them either.

[Ian]

Cal,

Starting to get desperate! Removed my Japanese 106 keyboard and replaced it
( and the driver ) with a standard US 101 keyboard. Removed all traces of
Japanese input from the language settings. Still cntrl+shift+M does not work.
Also cntrl T does not work to toggle between multi and single line in the
account register.

Some contrl key combos work eg if I press cntrl H the find and replace
window pops up.....

Is there some global OS setting or Money setting which changes the way the
cntrl key works?

Are you really really sure these key combos work in the UK Money 2005 (
v14)?????

[Cal Learner]

In microsoft.public.uk.money, Ian wrote:

>
>
>Starting to get desperate! Removed my Japanese 106 keyboard and replaced it
>( and the driver ) with a standard US 101 keyboard. Removed all traces of
>Japanese input from the language settings. Still cntrl+shift+M does not work.
>Also cntrl T does not work to toggle between multi and single line in the
>account register.
>
>Some contrl key combos work eg if I press cntrl H the find and replace
>window pops up.....
>
>Is there some global OS setting or Money setting which changes the way the
>cntrl key works?
>
>Are you really really sure these key combos work in the UK Money 2005 (
>v14)?????

Please confirm that in the upper-right of the register window (under
the help (?) icon, it says "Advanced Register" and not "Essential
Register".

[Ian]

Hi Cal,

Yes, "Advanced Register" is displayed.

[Glyn Simpson, MVP]

Both of the key combinations definitely work in UK Money 2005. The only
thing I can think of is that to provide Japanese input, you might use a
Cntl-Shift key combination on a Qwerty keyboard (not sute though, never
tried). If the version of Windows is a Japanese one, then something at a
lower level might be taking those combinations before Money has the chance
to handle them

--
Glyn Simpson, Microsoft MVP - Money
http://money.mvps.org

Check http://money.mvps.org/faq/default.aspx for tips and fixes for MS
Money.
To send Microsoft your product wishes see http://money.mvps.org/wishes.aspx

I do not respond to any unsolicited email regarding Money

"Ian" <I...@discussions.microsoft.com> wrote in message
news:62FA14E0-927E-4E6D...@microsoft.com...

[Ian]

Glyn,

Thanks for the confirmation.
I am using English Windows XP with a Japanese 106 key keyboard and a
Japanese IME installed. I guess somehow this combination is causing the
problem although I have used this combination for at least a year with no
problems.
However I do see many control key combinations are actually working in Money
including some control+shift key combinations. So not all key combinations
are filtered out. But cntrl+shft+M and cntrl T do NOT work. It could be the
IME uses these key combinations for something but I can find no information
on this and the IME configuration does not seem to mention these keys.

Is there maybe a Japanese IME expert in Microsoft who could advise on this???