ACT! 2013, Opportunity.Status removed from OLEDB2?

[RobEisler]

Hello,

It appears that in 2013, the Opportunity.Status field is no longer available through the 2.0 data provider. Is this correct? This change will break any existing reports using this field. In addition, the field Opportunity.StatusNum is available, but I don't see a way to retrieve the status names through the provider, and the statusnum by itself would not be useful for end users.

Thanks,

- Rob

[mwood]

This issue has already been reported and is being tracked by ID number 100773. 

I do have a query you can run that will make the column show back up, if you need this please contact me via PM and I'll be more than happy to pass it along.

If anyone else is encountering problems with this particular issue please speak up in this thread and I'll try to make the case to have it included in the next hotfix and/or service pack.

[jimdurkin]

Me - hand up high!

Impact Report Design uses OLE2. exclusively. 

-- Jim Durkin

[mwood]

Thanks Jim.

Don't rmeember if this was one of the issues you reported to me but I've definetly included you and your customers in the case to have it included. 

[KristenA]

Me too! Just found a bunch of broken queries as a result.

[rharper]

From memory, I glance at the sql tables in 2013 in Sales opps,  I think what they have done I think in the back in of SQL is to change the Statusnum which had  1, 2, 3  to indicate won/lost/inactive, and now but the words  to won, lost inactive in a field...

OLEDB2 query will break, If some one can chack that ...

[gedger]

Hi.

me too!

If there is a temp fix I'ld love to get it.

I'm holding off updating our many databases/offices to 2013 until resolved as without STATUS, many of our custom tools & reports are useless.

[mwood]

There is a fix. Send me a private message and I'll send the query along with the instructions.

[gedger]

That worked. thankyou.

Now I have the same problem with dozens of queries that the product_subtotal field no longer present in opportunity table. 

1) It looks like 'product_subtotal' is now just 'total'  correct?

frustrating. 

2) Is there any overview document of changes made to OLEDB2 in 2013?

[mwood]

Yes, Product_Subtotal is Total. I don't recall which version this changed in but I believe it was prior to 2011. 

There is a functional change document that accompanies the SDK but I don't believe any similar document exists for the reporting provider unfortunately.