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 CiviContribute (Moderator: Donald Lobo) »
  • How/where are accounting batch records flagged during processing
Pages: [1]

Author Topic: How/where are accounting batch records flagged during processing  (Read 329 times)

cckozie

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: 7.34
  • MySQL version: 5.1
  • PHP version: 5
How/where are accounting batch records flagged during processing
January 22, 2015, 01:51:39 pm
I am trying to understand where and how transactions (contributions and/or the associated financial trxn) are flagged when they are added to a batch and then when that batch is exported.

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: How/where are accounting batch records flagged during processing
January 23, 2015, 07:50:23 am
When you assign records to an accounting batch, the table `civicrm_entity_batch` gets updated.

Try the SQL:  SELECT * FROM `civicrm_entity_batch` to see what is going on with your batches. The status of the batch itself (open, closed, exported, etc) is in the table "civicrm_batch"
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

cckozie

  • I’m new here
  • *
  • Posts: 4
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: 7.34
  • MySQL version: 5.1
  • PHP version: 5
Re: How/where are accounting batch records flagged during processing
January 23, 2015, 08:38:32 am
Thanks for the info.
I have seen the civicrm_batch and civicrm_entity_batch getting updated during the process. What I'm trying to understand is how the system knows that once a record has been added to a batch, it should no longer be displayed in the list of transactions that can be assigned to another batch. I was expecting that there would be a status change or something flagged in civicrm_financial_trxn, but haven't found that to be the case.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • How/where are accounting batch records flagged during processing

This forum was archived on 2017-11-26.