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 »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Any Churches using CiciCRM?
Pages: 1 [2]

Author Topic: Any Churches using CiciCRM?  (Read 6001 times)

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Any Churches using CiciCRM?
February 25, 2010, 01:04:53 pm
Yeah, I was originally or the opinion that contributions were payments but after reading responses to previous discussions I changed my mind. The main reason is that payments should never be pending. They are either paid or they don't exist. Even a bounced cheque is a completed payment following shortly thereafter by a completed negative payment.

In essence memberships, events & pledge are all frameworks to describe the payment one commits to make (and the business rules around them). Contributions are the commitments themselves (I would have two types:

1)  recurring - contributions are created in CiviCRM once the business rules (e.g. recurring contribution, pledge, membership say they should be paid
2) single - so a big pledge of say $2000 to be paid as and when might show up as one contribution but have many payments over time accrue. I presume the pledge module would describe how that would be followed up.)

There is already a table where some payments are stored: civicrm_financial_trxn and it already has  a potentially many to one relationship with a contribution.

I guess what I feel should happen is that the contribution record would record what people intend to pay and the aggregate of the financial_trxns is what they have actually paid. Once the aggregate matches the intention the contribution would be confirmed. An admin user would also be able to confirm a contribution that is not fully paid and at that point would have the option of changing the contribution amount to match the amount actually paid.

For me agreeing where contributions fit in the financials is a crucial first step to developing any data model.


http://wiki.civicrm.org/confluence/display/CRM/Finance+and+Accounting
http://civicrm.org/taxonomy/term/25
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

FatherShawn

  • Ask me questions
  • ****
  • Posts: 372
  • Karma: 25
    • C3 Design
  • CiviCRM version: 4.2.11
  • CMS version: Drupal 7.23
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
Re: Any Churches using CiciCRM?
March 01, 2010, 05:18:20 pm
Well, Eileen, you have a much clearer view of the sql structure than I do at this point.  I don't have a perspective on which tables we should use.  I'm bridging off your earlier point:

Quote from: Eileen on February 22, 2010, 03:28:15 pm
I'm making this comparison not because the functionality I'm describing exists but because I think the requirements are the same and if many seemingly different issues have a similar solution it increases the chance of getting resources behind that solution

It made me realize that we could abstract all of the commit now, pay later, interactions into one object or type:

Quote from: FatherShawn on February 25, 2010, 12:28:38 pm
multi_payment
Properties
  • type (pledge, event)
  • id
  • related_contact
  • amount
  • related_contributions
Methods
  • Balance: loop through related_contributions and subtract sum from amount

I would convert all Pay-Later Contributions to Pledges as I don't see any difference.

Once we agree on the conceptual leap of a multi-payment object with related payments, we can figure out the storage structure that takes the least effort to effect.
Lead Developer, C3 Design.
Twitter: @FatherShawn

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Any Churches using CiciCRM?
March 03, 2010, 06:27:20 pm
Just tying the link in circles:
discussion related to this thread is also here
http://civicrm.org/node/619
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Pages: 1 [2]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • Any Churches using CiciCRM?

This forum was archived on 2017-11-26.