CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Reports not showing all contributions
Pages: [1]

Author Topic: Reports not showing all contributions  (Read 1079 times)

wordsetc

  • I’m new here
  • *
  • Posts: 16
  • Karma: 1
Reports not showing all contributions
December 01, 2012, 10:45:42 am
I'm using CiviCRM ver 4.1.3 on drupal 6. When running reports it's not pulling in all membership contributions or event fees. And, some of the contributions are included, but they don't have a "receive date." Our treasurer is asking me for an accounting, and I'm not getting a complete one.

My first tip something was wrong was when I did the "bookkeeping transactions" report and saw that the "Receive date" was blank for a bunch of entries. I looked at several of them, and I couldn't see anything amiss (or consistent between them). Then, in that process, I found at least one person who had made 4 payments and only 2 of them showed up at all in the "bookkeeping transactions" report (which I had run with NO sort criteria, so it should have pulled everything.

Thanks,
Tina

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Reports not showing all contributions
December 01, 2012, 04:23:28 pm

can u check and ensure that the skipped contributions are not "test" contributions

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

wordsetc

  • I’m new here
  • *
  • Posts: 16
  • Karma: 1
Re: Reports not showing all contributions
December 01, 2012, 07:36:10 pm
No, I'm missing some actual payments because I just happened to see one person's entry of event payments, two of them, and only one shows in all my reports.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Reports not showing all contributions
December 02, 2012, 10:39:44 am

u'll need to debug this and help out. u'll need to check your mysql query log and see why the query is not picking up the other payment

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

wordsetc

  • I’m new here
  • *
  • Posts: 16
  • Karma: 1
Re: Reports not showing all contributions
December 05, 2012, 06:31:17 am
This will sound dumb, but I don't know where my mysql logs are??

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Reports not showing all contributions
December 05, 2012, 01:20:33 pm

check with your hosting provider and/or sysadmin and/or do a web search

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • Reports not showing all contributions

This forum was archived on 2017-11-26.