Answers.Body: <p>I think its because the financial type you used while creating contribution don't have 'Accounts Receivable Account is' and 'Expense Account is' account attached to it. </p>
  
  <p>To check you can navigate to Administer >> CiviContribute >> Financial type.</p>
  
  <p>Besides Financial type click on 'Accounts'</p>
  
  <p><a href="https://i.sstatic.net/P5gkm.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/P5gkm.png" alt="enter image description here"></a></p>
  
  <p>Check if you can see 'Accounts Receivable Account is' and 'Expense Account is'in the list</p>
  
  <p><a href="https://i.sstatic.net/vh3Bz.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/vh3Bz.png" alt="enter image description here"></a></p>
  
  <p>If not then click on 'Assign Account' button and then create a 'Accounts Receivable Account is' and 'Expense Account is' account</p>
  
  <p><a href="https://i.sstatic.net/VRIgG.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/VRIgG.png" alt="enter image description here"></a></p>
  
  <p>Cheers</p>
  
  <p>Pradeep</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-25T17:11:07.990Z
Answers.Text: Thanks. The financial types involved in the error only had an 'Income Account Is' designation. I added  an 'Accounts Receivable Account is' entry pointing to 'Accounts Receivable' as you suggested. Also made sure the Payment Method I was employing also designates the 'Accounts Receivable' Financial Account.  I still get the same yellow box error, but the log now registers a slightly different fault: (I'll paste it into a new reply, too long for this comments field)
Answers.UserDisplayName: cfritze64
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-25T17:13:13.130Z
Answers.Text: Can you post the error?
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-25T17:13:36.900Z
Answers.Text: /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/DAO.php(1396): CRM_Core_DAO::composeQuery("\n        SELECT GROUP_CONCAT(fa.`name`) as financial_account,\n          ft....", (Array:2), TRUE)
  #4 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(4089): CRM_Core_DAO::executeQuery("\n        SELECT GROUP_CONCAT(fa.`name`) as financial_account,\n          ft....", (Array:2))
Answers.UserDisplayName: cfritze64
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-25T17:15:33.087Z
Answers.Text: You also need to configure 'Expense Account is'
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-25T17:17:18.043Z
Answers.Text: Have updated my answer
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-25T17:21:14.393Z
Answers.Text: Superb. I made this change to the financial types that were throwing the error, and all are viewable editable deletable as before. Many thanks. And a last question: Is this a configuration I should expect to review after each upgrade cycle, or did it stem  from some prior gremlin in our install?
Answers.UserDisplayName: cfritze64
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-25T17:24:00.227Z
Answers.Text: not after each upgrade. A financial type should have 4 types as shown in above image by default to function properly.
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-04-25T16:51:01.950Z
Answers.LastActivityDate: 2019-04-25T17:16:47.667Z
Answers.LastEditDate: 2019-04-25T17:16:47.667Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>Recently did an upgrade to all parts of our Civi install. Our build is run fully on a local machine (localhost) on an XAMPP stack, now updated to drupal 7 and latest production CivCRM version.</p>
  
  <p>I'm having trouble viewing, editing, or deleting some contributions. It seems new ones that I enter where FinancialType doesn't equal Check are not behaving well. If I try to view, edit, or delete them, I get a yellow box error</p>
  
  <p>One of parameters (value: ) is not of the type Integer</p>
  
  <p>This affects new contributions I enter and ones that are dated prior to the software upgrades. The error log for the most recent occurrence is pasted below. Thanks for any assistance!</p>
  
  <pre><code>Apr 25 09:20:21  [info] $Fatal Error Details = Array
  (
      [message] =&gt; One of parameters  (value: ) is not of the type Integer
      [code] =&gt; 
  )
  
  
  Apr 25 09:20:21  [info] $backTrace = #0 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/Error.php(381): CRM_Core_Error::backtrace("backTrace", TRUE)
  #1 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/Type.php(554): CRM_Core_Error::fatal("One of parameters  (value: ) is not of the type Integer")
  #2 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/DAO.php(1518): CRM_Utils_Type::validate("", "Integer")
  #3 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/DAO.php(1396): CRM_Core_DAO::composeQuery("SELECT ft.id, ft.total_amount FROM civicrm_financial_trxn ft INNER JOIN civic...", (Array:2), TRUE)
  #4 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/BAO/FinancialTrxn.php(98): CRM_Core_DAO::executeQuery("SELECT ft.id, ft.total_amount FROM civicrm_financial_trxn ft INNER JOIN civic...", (Array:2))
  #5 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(4030): CRM_Core_BAO_FinancialTrxn::getBalanceTrxnAmt("64601")
  #6 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Contribute/Form/AbstractEditPayment.php(741): CRM_Contribute_BAO_Contribution::getPaymentInfo("64601", NULL, TRUE)
  #7 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution.php(248): CRM_Contribute_Form_AbstractEditPayment-&gt;assignPaymentInfoBlock()
  #8 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/Form.php(585): CRM_Contribute_Form_Contribution-&gt;preProcess()
  #9 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form-&gt;buildForm()
  #10 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display-&gt;perform(Object(CRM_Contribute_Form_Contribution), "display")
  #11 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller-&gt;handle(Object(CRM_Contribute_Form_Contribution), "display")
  #12 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page-&gt;handle("display")
  #13 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Contribute/Page/Tab.php(323): CRM_Core_Controller-&gt;run()
  #14 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Contribute/Page/Tab.php(374): CRM_Contribute_Page_Tab-&gt;edit()
  #15 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(309): CRM_Contribute_Page_Tab-&gt;run((Array:4), NULL)
  #16 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
  #17 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
  #18 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:4))
  #19 /Applications/XAMPP/xamppfiles/htdocs/drupal/includes/menu.inc(527): civicrm_invoke("contact", "view", "contribution")
  #20 /Applications/XAMPP/xamppfiles/htdocs/drupal/index.php(21): menu_execute_active_handler()
  #21 {main}
  </code></pre>
  
Tags: <civicontribute><error>
Title: Error viewing/editing/deleting contributions, error log included
ThreadText: # Error viewing/editing/deleting contributions, error log included
  
  (Asked by: username_0 on 2019-04-25)
  
  Recently did an upgrade to all parts of our Civi install. Our build is run fully on a local machine (localhost) on an XAMPP stack, now updated to drupal 7 and latest production CivCRM version.
  
  I'm having trouble viewing, editing, or deleting some contributions. It seems new ones that I enter where FinancialType doesn't equal Check are not behaving well. If I try to view, edit, or delete them, I get a yellow box error
  
  One of parameters (value: ) is not of the type Integer
  
  This affects new contributions I enter and ones that are dated prior to the software upgrades. The error log for the most recent occurrence is pasted below. Thanks for any assistance!
  
  ```
  Apr 25 09:20:21  [info] $Fatal Error Details = Array
  (
      [message] => One of parameters  (value: ) is not of the type Integer
      [code] => 
  )
  
  Apr 25 09:20:21  [info] $backTrace = #0 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/Error.php(381): CRM_Core_Error::backtrace("backTrace", TRUE)
  #1 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Utils/Type.php(554): CRM_Core_Error::fatal("One of parameters  (value: ) is not of the type Integer")
  #2 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/DAO.php(1518): CRM_Utils_Type::validate("", "Integer")
  #3 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/DAO.php(1396): CRM_Core_DAO::composeQuery("SELECT ft.id, ft.total_amount FROM civicrm_financial_trxn ft INNER JOIN civic...", (Array:2), TRUE)
  #4 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/BAO/FinancialTrxn.php(98): CRM_Core_DAO::executeQuery("SELECT ft.id, ft.total_amount FROM civicrm_financial_trxn ft INNER JOIN civic...", (Array:2))
  #5 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(4030): CRM_Core_BAO_FinancialTrxn::getBalanceTrxnAmt("64601")
  #6 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Contribute/Form/AbstractEditPayment.php(741): CRM_Contribute_BAO_Contribution::getPaymentInfo("64601", NULL, TRUE)
  #7 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Contribute/Form/Contribution.php(248): CRM_Contribute_Form_AbstractEditPayment->assignPaymentInfoBlock()
  #8 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/Form.php(585): CRM_Contribute_Form_Contribution->preProcess()
  #9 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
  #10 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contribute_Form_Contribution), "display")
  #11 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contribute_Form_Contribution), "display")
  #12 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
  #13 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Contribute/Page/Tab.php(323): CRM_Core_Controller->run()
  #14 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Contribute/Page/Tab.php(374): CRM_Contribute_Page_Tab->edit()
  #15 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(309): CRM_Contribute_Page_Tab->run((Array:4), NULL)
  #16 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(84): CRM_Core_Invoke::runItem((Array:13))
  #17 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
  #18 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/drupal/civicrm.module(445): CRM_Core_Invoke::invoke((Array:4))
  #19 /Applications/XAMPP/xamppfiles/htdocs/drupal/includes/menu.inc(527): civicrm_invoke("contact", "view", "contribution")
  #20 /Applications/XAMPP/xamppfiles/htdocs/drupal/index.php(21): menu_execute_active_handler()
  #21 {main}
  
  ```
  
  **Tags:** civicontribute, error
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-04-25. Score: 2 | Accepted answer
  
  I think its because the financial type you used while creating contribution don't have 'Accounts Receivable Account is' and 'Expense Account is' account attached to it.
  
  To check you can navigate to Administer >> CiviContribute >> Financial type.
  
  Besides Financial type click on 'Accounts'
  
  [![enter image description here](https://i.sstatic.net/P5gkm.png)](https://i.sstatic.net/P5gkm.png)
  
  Check if you can see 'Accounts Receivable Account is' and 'Expense Account is'in the list
  
  [![enter image description here](https://i.sstatic.net/vh3Bz.png)](https://i.sstatic.net/vh3Bz.png)
  
  If not then click on 'Assign Account' button and then create a 'Accounts Receivable Account is' and 'Expense Account is' account
  
  [![enter image description here](https://i.sstatic.net/VRIgG.png)](https://i.sstatic.net/VRIgG.png)
  
  Cheers
  
  username_1
  
  > **Comments:**
  > **username_0**: Thanks. The financial types involved in the error only had an 'Income Account Is' designation. I added  an 'Accounts Receivable Account is' entry pointing to 'Accounts Receivable' as you suggested. Also made sure the Payment Method I was employing also designates the 'Accounts Receivable' Financial Account.  I still get the same yellow box error, but the log now registers a slightly different fault: (I'll paste it into a new reply, too long for this comments field)  
  > **username_1**: Can you post the error?  
  > **username_0**: /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Core/DAO.php(1396): CRM_Core_DAO::composeQuery("\n        SELECT GROUP_CONCAT(fa.`name`) as financial_account,\n          ft....", (Array:2), TRUE) #4 /Applications/XAMPP/xamppfiles/htdocs/drupal/sites/all/modules/civicrm/CRM/Contribute/BAO/Contribution.php(4089): CRM_Core_DAO::executeQuery("\n        SELECT GROUP_CONCAT(fa.`name`) as financial_account,\n          ft....", (Array:2))  
  > **username_1**: You also need to configure 'Expense Account is'  
  > **username_1**: Have updated my answer  
  > **username_0**: Superb. I made this change to the financial types that were throwing the error, and all are viewable editable deletable as before. Many thanks. And a last question: Is this a configuration I should expect to review after each upgrade cycle, or did it stem  from some prior gremlin in our install?  
  > **username_1**: not after each upgrade. A financial type should have 4 types as shown in above image by default to function properly.  
  
  ---
  
  