Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #11  
Old 09-02-2008, 07:33 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Downloaded Transaction from One Payee not showing

In microsoft.public.money, Alon wrote:

- quote -

> Cal,
> I just noticed this issue again and am wondering what the root cause is.
> What ensures the ID is unique?


It is up to the data provider to make the FITID unique. You should
never have to deal with that.

If the provider were to include the date and amount of the
transactions as part of a hash, that would prevent *that* problem.
The other thing you need to avoid is to not to download the same
transaction with a FITID that Money has seen from that FI before;
that would cause the transaction to be ignored.




- quote -

> Could that fact that I have data going all
> the way back to 2000 in my file be an issue?
> Alon
> "Cal Learner-- MVP" wrote:
> > In microsoft.public.money, Alon wrote:
> > > > So the FITID is supposed to be unique for every single transaction, correct?
> > > Yes.
> > > > I have noted this some problem with 2 or 3 transactions from this same Toys
> > > 'R' Us.
> > > While the same transaction downloaded later should have same FITID,

> > a different transaction should have a different FITID. That's how
> > Money identifies that it has or has not previously seen a
> > transaction.

>
  #10  
Old 09-02-2008, 06:13 PM
Alon :)
Guest
 
Posts: n/a
Default Re: Downloaded Transaction from One Payee not showing

Cal,

I just noticed this issue again and am wondering what the root cause is.
What ensures the ID is unique? Could that fact that I have data going all
the way back to 2000 in my file be an issue?

Alon

"Cal Learner-- MVP" wrote:

- quote -

> In microsoft.public.money, Alon wrote:
> > So the FITID is supposed to be unique for every single transaction, correct?

> Yes.
> > I have noted this some problem with 2 or 3 transactions from this same Toys
> > 'R' Us.

> While the same transaction downloaded later should have same FITID,
> a different transaction should have a different FITID. That's how
> Money identifies that it has or has not previously seen a
> transaction.

  #9  
Old 08-08-2008, 04:42 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Downloaded Transaction from One Payee not showing

In microsoft.public.money, Alon wrote:

- quote -

> So the FITID is supposed to be unique for every single transaction, correct?

Yes.

- quote -

> I have noted this some problem with 2 or 3 transactions from this same Toys
> 'R' Us.


While the same transaction downloaded later should have same FITID,
a different transaction should have a different FITID. That's how
Money identifies that it has or has not previously seen a
transaction.
  #8  
Old 08-08-2008, 04:29 PM
Alon :)
Guest
 
Posts: n/a
Default Re: Downloaded Transaction from One Payee not showing

So the FITID is supposed to be unique for every single transaction, correct?
I have noted this some problem with 2 or 3 transactions from this same Toys
'R' Us.

  #7  
Old 08-08-2008, 04:15 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Downloaded Transaction from One Payee not showing

In microsoft.public.money, Alon wrote:

- quote -

> That worked.... now what?

It proves out the idea that the problem is a previously-used FITID.

The next time you download a new T.R.U. transaction, and it does not
work, compare the FITID with the previously-seen value. It should be
different. If it is not, you could try to report the situation to
the FI in the hopes that they fix if for the future. Yet somehow the
FIs are not as eager to track and fix bugs as you would imagine.

If you are more disillusioned, just enter the missing transaction
into the register by hand.
  #6  
Old 08-08-2008, 03:48 PM
Alon :)
Guest
 
Posts: n/a
Default Re: Downloaded Transaction from One Payee not showing

That worked.... now what?
  #5  
Old 08-08-2008, 02:47 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Downloaded Transaction from One Payee not showing

In microsoft.public.money, Alon wrote:

- quote -

> Here you go
> <STMTTRN> <TRNTYPE> DEBIT
> <DTPOSTED> 20080804190000
> <TRNAMT> -73.24
> <FITID> 3743668119200808040005
> <REFNUM> 1080804F821749000660
> <NAME> POS TOYS R US/9930 ALABAMA S
> <MEMO> 9930 ALABAMA ST REDLANDS 0804 S
> </STMTTRN

I see no problem with that transaction.

If somehow, and this seems very unlikely,
"<FITID> 3743668119200808040005" has been used before for a different
transaction from that FI, that could explain it.

For an experiment, you could make a copy of your OFX file (new
name), and change "<FITID> 3743668119200808040005" into
"<FITID> 3743668119200808040005A". Then File-> Import that modified
OFX file into a test copy of your *.mny file. See if Money accepted
that transaction as a new transaction.


  #4  
Old 08-08-2008, 02:25 PM
Alon :)
Guest
 
Posts: n/a
Default Re: Downloaded Transaction from One Payee not showing

Here you go

<STMTTRN<TRNTYPE> DEBIT
<DTPOSTED> 20080804190000
<TRNAMT> -73.24
<FITID> 3743668119200808040005
<REFNUM> 1080804F821749000660
<NAME> POS TOYS R US/9930 ALABAMA S
<MEMO> 9930 ALABAMA ST REDLANDS 0804 S
</STMTTRN
  #3  
Old 08-08-2008, 01:04 AM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Downloaded Transaction from One Payee not showing

In microsoft.public.money, Alon wrote:

- quote -

> To Review does not have any entries. I am using Windows XP. I am
> downloading from a website. I am using Money 2007 Deluxe.
> File-> Import-> DownloadStatement results in the same problem.


Seems odd. I wonder if somehow the <FITID> for those is some
non-unique string that has been used previously. That is a long
shot. The same <FITID> should never be used for different
transactions.

You could try copying one of the problem transactions from the OFX
into a reply from <STMTTRN> to </STMTTRN> as in this example:


<STMTTRN<TRNTYPE> DEBIT
<DTPOSTED> 20080703170000
<TRNAMT> -25.73
<FITID> 85160835M0701
<SIC> 5300
<NAME> AJAX ROCK RENTAL
</STMTTRN


  #2  
Old 08-07-2008, 07:35 PM
Alon :)
Guest
 
Posts: n/a
Default Re: Downloaded Transaction from One Payee not showing

To Review does not have any entries. I am using Windows XP. I am
downloading from a website. I am using Money 2007 Deluxe.
File-> Import-> DownloadStatement results in the same problem.


  #1  
Old 08-07-2008, 05:13 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Downloaded Transaction from One Payee not showing

In microsoft.public.money, Alon wrote:

- quote -

> Recently I noticed that when I download my back statement that transactions
> from Toys "R" Us are not showing up in my register. I have check the ofx
> file and the transaction is there. I have not noticed this behavior with any
> other Payees. I have tried deleting Toys "R" Us from the payee list, but it
> has not helped. Any ideas?


On your AccountList, does the ToReview column have any
entries that say TransactionsToRead?

What OS are you using?

How are you downloading? Web site or what? And if Web Site
can you save the file to disk and File-> Import-> DownloadStatement?

What version of Money are you using?
 
Old 08-07-2008, 05:01 PM
Alon :)
Guest
 
Posts: n/a
Default RE: Downloaded Transaction from One Payee not showing

bump, any help?
  #-1  
Old 08-04-2008, 11:48 PM
Alon :)
Guest
 
Posts: n/a
Default Downloaded Transaction from One Payee not showing

Recently I noticed that when I download my back statement that transactions
from Toys "R" Us are not showing up in my register. I have check the ofx
file and the transaction is there. I have not noticed this behavior with any
other Payees. I have tried deleting Toys "R" Us from the payee list, but it
has not helped. Any ideas?
 

Tags
downloaded, payee, showing, transaction
Similar Threads
Thread Forum Replies Last Post
Downloaded Transactions not matching correctly, non-downloaded transactions showing up with 'E' status when they shouldn't
johndog: I recently did the cure-all of 'Remove all bills data' and I've regularly repaired my file. But I'm still seeing an issue of data not matching, and...
Microsoft Money 7 02-03-2007 07:00 PM
Downloaded transactions not showing in Money
Dave M: I am running MS Money 2003 Standard Edition V11 update 1 and when I download account transactions from my bank one account shows 17 transactions...
Microsoft Money 6 09-07-2005 12:51 AM
Downloaded statements not showing
Dave Jacquemotte: Using Money 2002. I have downloaded a statement from an account I have recently opened. I have downloaded other accounts from same bank without a...
Microsoft Money 2 09-16-2003 08:39 PM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 03:38 AM.