Community
Showing results for 
Search instead for 
Do you mean 
Reply

Opportunity restructure from 2009 to 2010

Copper Super Contributor
Posts: 122
Country: United Kingdom

Opportunity restructure from 2009 to 2010

I understand the features in Act 2010 and the change in Opportunities One key question - in Act 2009 there was a field we used to reference called ACTUALAMT This seems to have gone now in ACT 2010 - what is the best replacement? TOTALEXTENDEDAMT ? Any other major changes if we are referencing specific fields in SQL (having upgraded from 2009 to 2010) ? Thanks Andy
Andy Kent
Angel Solutions (UK and NZ)
www.angelsolutions.co.uk
Copper Super Contributor
Posts: 122
Country: United Kingdom

Re: Opportunity restructure from 2009 to 2010

Findings so far seeing as I can't find a "change document" anywhere include: TBL_OPPORTUNITY No more STATUS field (which was calculated anyway), in SQL we now use this CASE opp.STATUSNUM WHEN '0' THEN 'Open' WHEN '1' THEN 'Closed - Won' WHEN '2' THEN 'Close- Lost' WHEN '3' THEN 'Inactive' END AS "Status" to recreated no more AMOUNT field, use TOTALEXTENDEDAMT instead? no more DETAILS field - now it's notes/history - more investigation required Hope this is useful to someone else using Act 2010 Andy
Andy Kent
Angel Solutions (UK and NZ)
www.angelsolutions.co.uk