• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 9 views
  • Users 0 members are here
Related

phantom contribution row

Dale Aucoin
$organization

I have a row in t_contribution that for some reason is not showing in the constituent's record.

In my experience this can happen if the gift has a value that is not matched in a reference table (like a campaign_no that doesn't reference an actual campaign in t_campaign) but that is not the case here.  I've checked all of those.

I also double checked to make sure I wasn't looking at "filtered" gifts in the constituent's record.

I even double checked to make sure none of the values (campaign/appeal/etc) were control grouped.

Any ideas are welcome.

Thanks!
Dale 

Parents
  • $organization

    What about the Fund_no? Does it still exist in t_fund? Also take a look on the constituent record/contribution tab to make sure you don't have the date range active.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dale Aucoin
    Sent: Wednesday, May 30, 2012 2:11 PM
    To: Martin A. Jones
    Subject: [Tessitura Technical Forum] phantom contribution row

     

    I have a row in t_contribution that for some reason is not showing in the constituent's record.

    In my experience this can happen if the gift has a value that is not matched in a reference table (like a campaign_no that doesn't reference an actual campaign in t_campaign) but that is not the case here.  I've checked all of those.

    I also double checked to make sure I wasn't looking at "filtered" gifts in the constituent's record.

    I even double checked to make sure none of the values (campaign/appeal/etc) were control grouped.

    Any ideas are welcome.

    Thanks!
    Dale 




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization

    What about the Fund_no? Does it still exist in t_fund? Also take a look on the constituent record/contribution tab to make sure you don't have the date range active.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dale Aucoin
    Sent: Wednesday, May 30, 2012 2:11 PM
    To: Martin A. Jones
    Subject: [Tessitura Technical Forum] phantom contribution row

     

    I have a row in t_contribution that for some reason is not showing in the constituent's record.

    In my experience this can happen if the gift has a value that is not matched in a reference table (like a campaign_no that doesn't reference an actual campaign in t_campaign) but that is not the case here.  I've checked all of those.

    I also double checked to make sure I wasn't looking at "filtered" gifts in the constituent's record.

    I even double checked to make sure none of the values (campaign/appeal/etc) were control grouped.

    Any ideas are welcome.

    Thanks!
    Dale 




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children