Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-19438

Entries in financial item not recorded properly when created via offline Membership form

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Critical
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.7.11
    • Fix Version/s: 4.7.13
    • Component/s: None
    • Labels:
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code

      Description

      When CiviCRM is configured for Memcached, data for line items are incorrectly stored.

      To replicate on memcached server;
      Create Offline 'General' Membership and change the total amount under record payment before hitting save button.

      Bug:
      The total amount of financial_trxn is not matched with financial item is not matched.

      Here is the query for reference:
      SELECT
      cc.id contribution_id,
      cc.contribution_status_id,
      cc.total_amount contribution_amount,
      cft.id financial_trxn_id,
      cft.to_financial_account_id,
      cft.from_financial_account_id,
      cfi.financial_account_id item_financial_account_id,
      cft.total_amount trxn_amount,
      cft.trxn_date trxn_date,
      cft.status_id trxn_status_id,
      cfi.id item_id,
      cfi.amount item_amount,
      cfi.status_id item_status,
      cli.*
      FROM civicrm_financial_trxn cft
      INNER JOIN civicrm_entity_financial_trxn ceft ON ceft.financial_trxn_id = cft.id
      INNER JOIN civicrm_financial_item cfi ON cfi.id = ceft.entity_id AND ceft.entity_table = 'civicrm_financial_item'
      INNER JOIN civicrm_line_item cli ON cli.id = cfi.entity_id AND cfi.entity_table = 'civicrm_line_item'
      INNER JOIN civicrm_entity_financial_trxn ceft1 ON ceft1.financial_trxn_id = cft.id AND ceft1.entity_table = 'civicrm_contribution'
      INNER JOIN civicrm_contribution cc ON cc.id = ceft1.entity_id
      WHERE cc.id=26425

        Attachments

          Activity

            People

            • Assignee:
              yashodha Yashodha Chaku
              Reporter:
              pradeep.nayak Pradeep Nayak
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: