Household Last Gift Amount field is incorrect with a range of donations

[GoogleCodeExporter]

What steps will reproduce the problem?
1.  Enable Rollup Opps in Triggers in Household Settings
2.  Create a 1-to-1 contact with a household.
3.  Create donation records with close dates in 2010 and 2011.

What is the expected output? What do you see instead?
In Household record, Last Gift Amount should be most recent 2011 donation.  
Instead, it is always the most recent 2010 donation.  If I delete all 2010 
donations, then the last Gift Amount does show the most recent 2011 donation.

Basicially - if all donations are in a single year, then Last Gift Amount calcs 
correctly.  If any donations are in different years, including current year,  
then the field calcs only up to the year previous to the actual last gift date.

What version of the packages are you using?
Households 2.3.10

Please provide any additional information below.
All other rollup fields in HH, contact and account seem to be correct - only HH 
Last Gift Amount is not working properly.

David Cheng
Idealist Consulting
P. 800.889.8675 x 505
F. 800.889.1659
www.idealistconsulting.com
advance your mission

Original issue reported on code.google.com by david.ch...@idealistconsulting.com on 11 Jan 2012 at 1:34

[GoogleCodeExporter]

Yup, looks like an issue with the apex rollups we used to workaround the SOQL 
agg problems. Thanks for submitting

Original comment by kbro...@gmail.com on 13 Jan 2012 at 7:06

• Changed state: Accepted
• Added labels: 2.3.11, Package-Households, Patch, Priority-High, Type-Defect

[GoogleCodeExporter]

I'm seeing this with HH 2.3.10 too, but not quite as consistently as David 
reports here:  "if any donations are in different years, including the current 
year, then the field calcs only up to the year previous to the actual last gift 
date".  

I'm seeing Household records where last gift amount appears to be pulled from a 
donation in 2009 (when there are subsequent donations in 2010 and 2011) and 
another where last gift amount is pulling from a donation back in 2000 (when 
there are subsequent donations in every year since). There must be a pattern 
here, but I can't discern it.

Let me know how I can help.  Thanks!!
Calista Carter
Idealist Consulting
P: 800.889.8675 x 502
F: 800.889.1659
Idealist Consulting
advance your mission

Original comment by cli...@idealistconsulting.com on 16 Jan 2012 at 6:14

[GoogleCodeExporter]

Original comment by kbro...@gmail.com on 18 Jan 2012 at 6:20

• Changed state: Complete-Patch

[GoogleCodeExporter]

Original comment by kbro...@gmail.com on 19 Jan 2012 at 8:45

• Changed state: Fixed