Answers.Body: <p>There's been some changes to support php 7.4 which doesn't have money_format() and also some work towards locales. Most likely that's the cause. I'd open a lab ticket.</p>
  <p>I'd guess this line needs to be changed to match the other changes that have happened:</p>
  <p><a href="https://github.com/civicrm/civicrm-core/blob/33307b5a0da280c63ed0d8fa1f8a3e899a217ad0/CRM/Financial/BAO/ExportFormat/IIF.php#L354" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/blob/33307b5a0da280c63ed0d8fa1f8a3e899a217ad0/CRM/Financial/BAO/ExportFormat/IIF.php#L354</a></p>
  <p>Like this example: <a href="https://github.com/civicrm/civicrm-core/pull/19602/files" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/pull/19602/files</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-17T16:49:22.683Z
Answers.LastActivityDate: 2021-02-17T16:49:22.683Z
Answers.UserDisplayName: Demerit
Answers.Body: <p>It seemed at first this was due to a customization, and was not able to be replicated on dmaster. We have changed this output file however to better support the right number of digits for the localized currency, and appropriate rounding. Eventually problem was isolated to new code that runs when php-intl library is available, and fix merged into 5.34.</p>
  <p>See <a href="https://lab.civicrm.org/dev/financial/-/issues/166" rel="nofollow noreferrer">https://lab.civicrm.org/dev/financial/-/issues/166</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-25T17:40:02.633Z
Answers.Text: Actually, this is incorrect.  The result still occurs even with the removal of the customization. The issue is still open, and some people have replicated it in some fashion.
Answers.UserDisplayName: Logan Bear
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-23T19:55:17.867Z
Answers.LastActivityDate: 2021-03-04T22:02:41.250Z
Answers.LastEditDate: 2021-03-04T22:02:41.250Z
Answers.UserDisplayName: Joe Murray
Body: <p>How does the IIF export from Accounting Batches get its information to determine the format of the amounts?  Batches created before 5.34 export simple value amounts:</p>
  <pre><code>12.00
  -12.00
  </code></pre>
  <p>Batches after the upgrade to 5.34 adds a dollar sign to the amount:</p>
  <pre><code>$12.00
  -$12.00
  </code></pre>
  <p>I can't get these files imported without loading them into Excel and changing the formatting.  How can I get the amounts to return to the earlier format?  What changed in Civi to cause this?</p>
  
Tags: <accounting><quickbooks>
Title: When did IIF amount formats change and how can I get it back to old format?
ThreadText: # When did IIF amount formats change and how can I get it back to old format?
  
  (Asked by: username_0 on 2021-02-17)
  
  How does the IIF export from Accounting Batches get its information to determine the format of the amounts? Batches created before 5.34 export simple value amounts:
  
  ```
  12.00
  -12.00
  
  ```
  
  Batches after the upgrade to 5.34 adds a dollar sign to the amount:
  
  ```
  $12.00
  -$12.00
  
  ```
  
  I can't get these files imported without loading them into Excel and changing the formatting. How can I get the amounts to return to the earlier format? What changed in Civi to cause this?
  
  **Tags:** accounting, quickbooks
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2021-02-17. Score: 2
  
  There's been some changes to support php 7.4 which doesn't have money\_format() and also some work towards locales. Most likely that's the cause. I'd open a lab ticket.
  
  I'd guess this line needs to be changed to match the other changes that have happened:
  
  <https://github.com/civicrm/civicrm-core/blob/33307b5a0da280c63ed0d8fa1f8a3e899a217ad0/CRM/Financial/BAO/ExportFormat/IIF.php#L354>
  
  Like this example: <https://github.com/civicrm/civicrm-core/pull/19602/files>
  
  
  ---
  
  ### Answer by username_2 on 2021-02-23. Score: 0
  
  It seemed at first this was due to a customization, and was not able to be replicated on dmaster. We have changed this output file however to better support the right number of digits for the localized currency, and appropriate rounding. Eventually problem was isolated to new code that runs when php-intl library is available, and fix merged into 5.34.
  
  See <https://lab.civicrm.org/dev/financial/-/issues/166>
  
  > **Comments:**
  > **username_0**: Actually, this is incorrect.  The result still occurs even with the removal of the customization. The issue is still open, and some people have replicated it in some fashion.  
  
  ---
  
  