CiviCRM 4.6.8 and WP4.3 I have Memberships setup with a main membership and chapter memberships. When a person buys a Main Membership and Chapter Membership with one payment I can not report on the Chapter Member only. It gives me the amount for the full payment. When I look at the detail I can see the items for the payment. How can I report on just the Chapter payment? I can get just the Chapters but it shows the full payment. Again, I need just the Chapter amount.
2
-
Gary - are you using a Price Set?– petednz - fuzion ♦Commented Sep 9, 2015 at 22:17
-
Yes.. using a Price Set.– Gary ZimmermanCommented Sep 14, 2015 at 15:14
Add a comment
|
1 Answer
If you are using price set then you might find this blog and the extended reports extension useful
answered Sep 9, 2015 at 22:20
-
+1 for the Extended Reports extension, this will give you what you need. This allows reporting (though not searching) based on the line items rather than the contribution. There's also a rumor that the Botanical Society has an extension that allows searching on the line items... Commented Sep 11, 2015 at 0:42
-
Ok. Already have the Extended Report Ext loaded and the Export to Excel loaded. I WILL dig deeper. Commented Sep 14, 2015 at 15:51
-
I can not get the field called "Item" The Extended Report shows Qty Unit Price, Total Price but I can not find the Item. Any way to get the Item listed in the report? Commented Sep 14, 2015 at 16:46
-
I AM WILLING TO PAY SOMEONE BECAUSE I HAVE TO GET THIS DONE! Please email me directly if you can help! Along with above here's what I have and then need. HAVE: I do use a price set. Once the Membership(s) are created and you go into the Individual Contact Membership Tab and Edit the membership and then edit the Related Payments at the top I will see the two line items with the Item, Qty, Unit Price, Total Price. I MUST be able to search on the Line Item Des Commented Sep 18, 2015 at 13:52
-
A sample of my data is "Chapter Dues - Pennsylvania-Delaware" Using the Extended Reports Extension I can get the numerical values ok but the Item Description is not available. Is there a way to create a custom SQL Query somewhere for this? I NEED a report that gives me all Chapter Dues filtered by Receive date and Price. Commented Sep 18, 2015 at 14:02