Answers.Body: <p>As you know, financial types can either be deductible or non-deductible. Before the advent of price sets, to record a partially deductible contribution you would use a deductible financial type and then enter in the non-deductible amount. After the advent of price sets, if the overall financial type of a price set is non-deductible, the system will automatically populate the non-deductible amount field for the full amount of the contribution, regardless of whether the individual price field options are configured with deductible financial types. </p>
  
  <p><strong>What this means is that currently, the system only tracks a non-deductible amount on the contribution level, not on the line item level. The field in the line item table is either a legacy field or a place holder for future use, but it is not something that is currently being populated by the system.</strong></p>
  
  <p>The demo site is down so I am unable to verify what built in tax tokens are available, but for our clients we instruct them to use a deductible financial type for the price set - in this way, our line-item based tokens will allocate each line item's deductible amount according to the financial type of the price field option.</p>
  
  <p>Hope this helps,
  Tamar</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-07T14:51:18.820Z
Answers.Text: As noted in my original posting, I had already checked to see if I had the overall Financial Type was set as deductible. It was. I have the Financial Type "Donation" (Tax-deductible) and the Price Fields listed below that.  It does not seem to carry down into the individual price field options. Any other ideas?
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-07T21:35:52.927Z
Answers.Text: Hi Carl, I was affirming your knowledge of this fact and have edited my response to include a bit more clarity.
Answers.UserDisplayName: Tamar Meir - Cividesk
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-14T23:45:21.740Z
Answers.Text: Is this a bug that should be reported?
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-14T23:54:53.813Z
Answers.Text: In my opinion, it is not a bug, but rather lack of functionality - what you are looking for is tracking a deductible amount on the line item level where currently the system is only tracking it on a contribution level basis.
Answers.UserDisplayName: Tamar Meir - Cividesk
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-10-05T16:58:05.100Z
Answers.LastActivityDate: 2016-10-07T21:34:31.823Z
Answers.LastEditDate: 2016-10-07T21:34:31.823Z
Answers.UserDisplayName: Tamar Meir - Cividesk
Body: <p>We use price fields/line items for all of our contributions.  I noticed that on the line_item table the column deductible_amount is not filling in.  I checked and Price Fields do not seem to have an option for "Is Tax-deductible".  Financial Types do have the check box.</p>
  
  <p>My set up is
  Financial Types:</p>
  
  <ul><li>Donation (tax-deductible is checked)</li> 
  <li>Tuition</li>
  <li>Reimbursement</li></ul>
  
  <p>Line Items under Donation:</p>
  
  <ul><li>General Fund</li>
  <li>Capital Improvement</li>
  <li>Staff Salaries</li>
  <li>Other __________________</li></ul>
  
  <p>What do I do to have it fill in the tax-deductible amount in the line item table?</p>
  
Tags: <php><price-sets>
Title: Column deductible_amount not getting filled in on table civicrm_line_item
ThreadText: # Column deductible_amount not getting filled in on table civicrm_line_item
  
  (Asked by: username_0 on 2016-10-03)
  
  We use price fields/line items for all of our contributions. I noticed that on the line\_item table the column deductible\_amount is not filling in. I checked and Price Fields do not seem to have an option for "Is Tax-deductible". Financial Types do have the check box.
  
  My set up is
  Financial Types:
  
  * Donation (tax-deductible is checked)
  * Tuition
  * Reimbursement
  
  Line Items under Donation:
  
  * General Fund
  * Capital Improvement
  * Staff Salaries
  * Other \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
  
  What do I do to have it fill in the tax-deductible amount in the line item table?
  
  **Tags:** php, price-sets
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-10-05. Score: 1
  
  As you know, financial types can either be deductible or non-deductible. Before the advent of price sets, to record a partially deductible contribution you would use a deductible financial type and then enter in the non-deductible amount. After the advent of price sets, if the overall financial type of a price set is non-deductible, the system will automatically populate the non-deductible amount field for the full amount of the contribution, regardless of whether the individual price field options are configured with deductible financial types.
  
  **What this means is that currently, the system only tracks a non-deductible amount on the contribution level, not on the line item level. The field in the line item table is either a legacy field or a place holder for future use, but it is not something that is currently being populated by the system.**
  
  The demo site is down so I am unable to verify what built in tax tokens are available, but for our clients we instruct them to use a deductible financial type for the price set - in this way, our line-item based tokens will allocate each line item's deductible amount according to the financial type of the price field option.
  
  Hope this helps,
  username_1
  
  > **Comments:**
  > **username_0**: As noted in my original posting, I had already checked to see if I had the overall Financial Type was set as deductible. It was. I have the Financial Type "Donation" (Tax-deductible) and the Price Fields listed below that.  It does not seem to carry down into the individual price field options. Any other ideas?  
  > **username_1**: Hi Carl, I was affirming your knowledge of this fact and have edited my response to include a bit more clarity.  
  > **username_0**: Is this a bug that should be reported?  
  > **username_1**: In my opinion, it is not a bug, but rather lack of functionality - what you are looking for is tracking a deductible amount on the line item level where currently the system is only tracking it on a contribution level basis.  
  
  ---
  
  