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

Partially Paid Contributions in Accounting Batches - Need Additional Filter/Column for Differentiation

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 4.5.6
    • Fix Version/s: Unscheduled
    • Component/s: Accounting Integration
    • Labels:
      None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Needs Funding

      Description

      I recreated the following scenario in the demo site:

      1. Registered a contact for an event with a status of partially paid and entered a partial payment contribution (http://d45.demo.civicrm.org/civicrm/contact/view?reset=1&cid=215), screen shot of event registration attached as "event_registration1"
      2. Created a test batch (Test3 Partially Paid Event Contributions in Accounting Batches) and was presented with two contributions in status of "Completed" - one for the full amount of $60, and one for the partially paid amount of $30 - this causes confusion for users because what it looks like to them are two completed contributions totaling $90, and until the batch is closed and exported it is not clear that the $60 is actually being debited to AR - some suggestions to avoid this confusion:
      a. Keep the $60 contribution in a status of "Partially Paid" until the remaining balance is paid off - this will allow users who are on a cash basis to filter only the completed transactions that they are interested in, and for those who are on an accrual basis, the difference between partially paid and completed is irrelevant as they both need to be batched, BUT
      b. Once the balance is paid off, marking the $60 contribution as completed will still cause confusion for those on a cash basis as it will continue to appear in the accounting batch area until it is batched, so adding an additional filter for "Debit Account" will allow users on a cash basis to filter out items being debited to AR so that there is no confusion, and adding a column for "Debit Account" in the accounting batch screen will allow users to see where items are being debited to BEFORE the batch is closed and exported, which would be a good data integrity measure for all users regardless of the accounting method being used.

      Let me know if you have any questions,
      Tamar

        Attachments

          Activity

            People

            • Assignee:
              joemurray Joe Murray
              Reporter:
              tamar Tamar Meir
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: