Closed amount for an opportunity doesn't reflect in campaign summary
Reported by Wai-Sun Chia | November 5th, 2009 @ 12:15 AM | in 0.9.8 "Lasker"
Opportunity id=8 is closed with 100% probability at $1000 and is linked to campaign_id=4.
But campaign_id=4, the revenue field is NULL!
mysql> select id,campaign_id,name,probability,amount from opportunities;
+----+-------------+-----------------------+-------------+----------+
| id | campaign_id | name | probability | amount |
+----+-------------+-----------------------+-------------+----------+
| 1 | 1 | foo opportunity | NULL | NULL |
| 2 | NULL | bar opportunity | NULL | NULL |
| 3 | 1 | baz opportunity | NULL | NULL |
| 4 | 2 | foo opportunity | NULL | NULL |
| 5 | NULL | bar opportunity | NULL | NULL |
| 6 | 3 | Teamworks Opportunity | 50 | 10000.00 |
| 7 | NULL | aaaaaa | NULL | NULL |
| 8 | 4 | foo opportunity | 100 | 1000.00 |
+----+-------------+-----------------------+-------------+----------+
8 rows in set (0.01 sec)
mysql> select id, name, leads_count,revenue from campaigns;
+----+---------------------+-------------+---------+
| id | name | leads_count | revenue |
+----+---------------------+-------------+---------+
| 1 | foo campaign | 0 | NULL |
| 2 | foo | 0 | NULL |
| 3 | Fly FM Advertisment | 0 | NULL |
| 4 | foo campaign | 1 | NULL |
| 5 | bar campaign | 0 | NULL |
+----+---------------------+-------------+---------+
5 rows in set (0.00 sec)
Comments and changes to this ticket
-
Mike Dvorkin November 6th, 2009 @ 02:33 PM
- State changed from new to resolved
(from [7050314e81d1c1128f57059182619d76fc90fca8]) Adjust total campaign revenue when related opportunity is won (LH #121) [#121 state:resolved] http://github.com/michaeldv/fat_free_crm/commit/7050314e81d1c1128f5...
-
Mike Dvorkin November 6th, 2009 @ 05:39 PM
- State changed from resolved to open
(from [5416f33b75d3e221af770199cfbffaf5f09bca34]) Refresh campaign sidebar when updating related opportunity [#121 state:open] http://github.com/michaeldv/fat_free_crm/commit/5416f33b75d3e221af7...
-
Mike Dvorkin November 6th, 2009 @ 08:30 PM
(from [45b33154013d4c776bcbea40b6eddabf6502b649]) Refactoring; update campaign summary when rejecting or converting related lead [#121 state:open] http://github.com/michaeldv/fat_free_crm/commit/45b33154013d4c776bc...
-
Mike Dvorkin November 6th, 2009 @ 08:30 PM
(from [7b507a060a1ce6cddfa13727c705dd6dabd87567]) Display newly created opportunity when converting lead from campaign page [#121 state:open] http://github.com/michaeldv/fat_free_crm/commit/7b507a060a1ce6cddfa...
-
Mike Dvorkin November 8th, 2009 @ 03:24 PM
- State changed from open to resolved
- Milestone changed from Feature Requests to 0.9.7 "Steinitz"
-
Mike Dvorkin January 12th, 2010 @ 08:51 PM
- Milestone changed from 0.9.7 "Steinitz" to 0.9.8 "Lasker"
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป
Ruby on Rails CRM platform for Web 2.0 and beyond
People watching this ticket
Attachments
Tags
Referenced by
- 121 Closed amount for an opportunity doesn't reflect in campaign summary (from [7050314e81d1c1128f57059182619d76fc90fca8]) Adjust ...
- 121 Closed amount for an opportunity doesn't reflect in campaign summary (from [7050314e81d1c1128f57059182619d76fc90fca8]) Adjust ...
- 121 Closed amount for an opportunity doesn't reflect in campaign summary (from [5416f33b75d3e221af770199cfbffaf5f09bca34]) Refresh...
- 121 Closed amount for an opportunity doesn't reflect in campaign summary (from [45b33154013d4c776bcbea40b6eddabf6502b649]) Refacto...
- 121 Closed amount for an opportunity doesn't reflect in campaign summary (from [7b507a060a1ce6cddfa13727c705dd6dabd87567]) Display...