#121 ✓resolved
Wai-Sun Chia

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

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.

New-ticket Create new ticket

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

Referenced by

Pages