Answers.Body: <p>UPDATE: As of version 4.6.4, the code below is merged into core.  Use the Contribution and Membership Details report.</p>
  
  <p>This was such a good question I decided to dig into the code.</p>
  
  <p>I used <code>grep</code> to search the Reports folder for the word "Premium" - and found that the only report that includes premium info right now is the Contribution and Membership Details report (found in the "Membership Reports" section).  That report shows the Premium and Premium Option, but not the fulfilled date.  However, it's only three lines of code to add if you use this report as your base.</p>
  
  <p>Create a PHP override directory - there's documentation that shows you how - and copy the ContributionDetail.php file into the appropriate place in the folder.  Then find the section that reads:</p>
  
  <pre><code>  'civicrm_contribution_product' =&gt; array(
      'dao' =&gt; 'CRM_Contribute_DAO_ContributionProduct',
      'fields' =&gt; array(
        'product_id' =&gt; array(
          'no_display' =&gt; TRUE,
        ),
        'product_option' =&gt; array(
          'title' =&gt; ts('Premium Option'),
        ),
        'contribution_id' =&gt; array(
          'no_display' =&gt; TRUE,
        ),
      ),
    ),
  </code></pre>
  
  <p>Change it to read:</p>
  
  <pre><code>  'civicrm_contribution_product' =&gt; array(
      'dao' =&gt; 'CRM_Contribute_DAO_ContributionProduct',
      'fields' =&gt; array(
        'product_id' =&gt; array(
          'no_display' =&gt; TRUE,
        ),
        'product_option' =&gt; array(
          'title' =&gt; ts('Premium Option'),
        ),
        'fulfilled_date' =&gt; array(
          'title' =&gt; ts('Premium Fulfilled Date'),
        ),
        'contribution_id' =&gt; array(
          'no_display' =&gt; TRUE,
        ),
      ),
    ),
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-22T01:52:51.900Z
Answers.Text: This would make a nice pull request :)
Answers.UserDisplayName: Coleman
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-06-07T18:17:07.500Z
Answers.Text: Just submitted this as a pull request: https://github.com/civicrm/civicrm-core/pull/5972.  Note that I found another fix to apply during testing - and hopefully this will be in CiviCRM 4.6.4+.
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-21T03:40:14.683Z
Answers.LastActivityDate: 2015-06-17T19:38:56.103Z
Answers.LastEditDate: 2015-06-17T19:38:56.103Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>Membership in our organization currently includes a T-Shirt which is implemented as a "Premium" on the contribution page.  Members must pick up their T-Shirt in person, so I'm looking for a way to report (create a list) on the fulfillment status of all current members.  </p>
  
  <p>There is a field for fulfillment date on the Contribution Detail page, but I can't seem to find this as a field in any of the available reports.</p>
  
  <p>Any suggestions would be appreciated.</p>
  
  <p><img src="https://i.sstatic.net/0Ng15.jpg" alt="enter image description here"></p>
  
Tags: <civicontribute><civireport><premiums>
Title: Reporting on Premium Fulfillment
ThreadText: # Reporting on Premium Fulfillment
  
  (Asked by: username_0 on 2015-05-20)
  
  Membership in our organization currently includes a T-Shirt which is implemented as a "Premium" on the contribution page. Members must pick up their T-Shirt in person, so I'm looking for a way to report (create a list) on the fulfillment status of all current members.
  
  There is a field for fulfillment date on the Contribution Detail page, but I can't seem to find this as a field in any of the available reports.
  
  Any suggestions would be appreciated.
  
  ![enter image description here](https://i.sstatic.net/0Ng15.jpg)
  
  **Tags:** civicontribute, civireport, premiums
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-05-21. Score: 4
  
  UPDATE: As of version 4.6.4, the code below is merged into core.  Use the Contribution and Membership Details report.
  This was such a good question I decided to dig into the code.
  I used grep to search the Reports folder for the word "Premium" - and found that the only report that includes premium info right now is the Contribution and Membership Details report (found in the "Membership Reports" section).  That report shows the Premium and Premium Option, but not the fulfilled date.  However, it's only three lines of code to add if you use this report as your base.
  Create a PHP override directory - there's documentation that shows you how - and copy the ContributionDetail.php file into the appropriate place in the folder.  Then find the section that reads:
    'civicrm_contribution_product' => array(
      'dao' => 'CRM_Contribute_DAO_ContributionProduct',
      'fields' => array(
        'product_id' => array(
          'no_display' => TRUE,
        ),
        'product_option' => array(
          'title' => ts('Premium Option'),
        ),
        'contribution_id' => array(
          'no_display' => TRUE,
        ),
      ),
    ),
  
  Change it to read:
    'civicrm_contribution_product' => array(
      'dao' => 'CRM_Contribute_DAO_ContributionProduct',
      'fields' => array(
        'product_id' => array(
          'no_display' => TRUE,
        ),
        'product_option' => array(
          'title' => ts('Premium Option'),
        ),
        'fulfilled_date' => array(
          'title' => ts('Premium Fulfilled Date'),
        ),
        'contribution_id' => array(
          'no_display' => TRUE,
        ),
      ),
    ),
  
  > **Comments:**
  > **username_2**: This would make a nice pull request :)  
  > **username_1**: Just submitted this as a pull request: https://github.com/civicrm/civicrm-core/pull/5972.  Note that I found another fix to apply during testing - and hopefully this will be in CiviCRM 4.6.4+.  
  
  ---
  
  