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

Create default civicrm_financial_account records

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.3.0
    • Fix Version/s: 4.3.0
    • Component/s: Accounting Integration
    • Labels:
      None

      Description

      Please update the tarball for sample data with the following (note first 4 records need to replace existing ones):
      INSERT INTO `civicrm_financial_account` (`id`, `name`, `contact_id`, `financial_account_type_id`, `accounting_code`, `description`, `parent_id`, `is_header_account`, `is_deductible`, `is_tax`, `tax_rate`, `is_reserved`, `is_active`, `is_default`) VALUES
      (1, 'Donations', 1, 3, '4200', 'Default account for donations', NULL, 0, 1, 0, NULL, 0, 1, 0),
      (2, 'Member Dues', 1, 3, '4400', 'Default account for membership sales', NULL, 0, 1, 0, NULL, 0, 1, 0),
      (3, 'Campaign Contribution', 1, 3, '4100', 'Sample account for recording payments to a campaign', NULL, 0, 0, 0, NULL, 0, 1, 0),
      (4, 'Event Fee', 1, 3, '4300', 'Default account for event ticket sales', NULL, 0, 0, 0, NULL, 0, 1, 0),
      (5, 'Banking Fees', 1, 5, '5200', 'Payment processor fees and manually recorded banking fees', NULL, 0, 0, 0, NULL, 0, 1, 0),
      (7, 'Deposit bank account', 1, 1, '1100', 'All manually recorded cash and cheques go to this account', NULL, 0, 0, 0, NULL, NULL, 1, 0),
      (8, 'Accounts Receivable', 1, 1, '1200', 'Amounts to be received later (eg pay later event revenues)', NULL, 0, 0, 0, NULL, NULL, 1, 1),
      (9, 'Accounts Payable', 1, 2, '2200', 'Amounts to be paid out such as grants and refunds', NULL, 0, 0, 0, NULL, NULL, 1, 0),
      (10, 'Checking Account', 1, 1, '1100', 'Bank accounts against which checks to pay grants, refunds, etc are written', NULL, 0, 0, 0, NULL, NULL, 1, 0),
      (11, 'Premiums', 1, 4, '5100', 'Account to record cost of premiums provided to payors', NULL, 0, 0, 0, NULL, NULL, 1, 0),
      (12, 'Premiums inventory', 1, 1, '1375', 'Account representing value of premiums inventory', NULL, 0, 0, 0, NULL, NULL, 1, 0),
      (13, 'Discounts', 1, 3, '4900', 'Contra-revenue account for amounts discounted from sales', NULL, 0, 0, 0, NULL, NULL, 1, 0),
      (14, 'Refunds', 1, 3, '4800', 'Contra-revenue account for amounts refunded', NULL, 0, 0, 0, NULL, NULL, 1, 0);

        Attachments

          Activity

            People

            • Assignee:
              dgg David Greenberg
              Reporter:
              joemurray Joe Murray
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: