Act! 2012 upgrade now Opportunity Status Reports as a number

[jmall221]

Upgraded to 2012, when reporting on opportunities the status is listed as number 0 through 3 instead of Open, Closed Won, Closed Lost, or Inactive.  Is there a fix for this?

[ghollister]

Hello jmall221,
Welcome to the Sage ACT! Community. Some questions:
- What version, including Hot Fix #, of ACT! do you have?
- Are you using a default report, a default report that you have edited, or a custom report?
- If using an edited/custom report, does the same thing show i the default Opportunity reports?

[jmall221]

Sage ACT! Premium 2012 Version 14.1.108.0

SP1

Standard reports.

Thank you

[ghollister]

This may have to do with the field being used for status. Edit the report template and make sure the field being used is Status Name, not Status. The standard reports I'm seeing have this by default, but yours may not.

[ghollister]

Also, you said this happened after the 2012 upgrade. Can you specify if that was upgrading to 2012 from an earlier version, or upgrading your existing 2012 installation to Service Pack 1?

[jmall221]

It was an issue in the template. Thank you.

We upgrade to 2012 from 2009.

[ghollister]

Glad to hear you got it resolved. I'll test the upgrade to see if this is an issue with the standard templates, and report it if needed. Thank you for posting.