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

Export Batch to IIF has Wrong Date Format

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Minor
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.6.11
    • Fix Version/s: 4.7.9
    • Component/s: CiviContribute
    • Labels:
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code

      Description

      When exporting a batch of contributions to IIF, the date format is in YYYY/MM/DD format even though CiviCRM is configured to use MM/DD/YYYY as Quickbooks expects. For example

      TRNS GENERAL JOURNAL 2016/01/12 Bank MyGroup 75.00 Check
      SPL 1 GENERAL JOURNAL 2016/01/12 Program Income:Membership Dues John Doe -75.00 Contribution Amount Check
      ENDTRNS

      The file shows 2016/01/12 when Quickbooks expects 01/12/2016

        Attachments

          Activity

            People

            • Assignee:
              yashodha Yashodha Chaku
              Reporter:
              kentx6 Ken Vaughn
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 4 days
                4d
                Remaining:
                Remaining Estimate - 4 days
                4d
                Logged:
                Time Spent - Not Specified
                Not Specified