10-09-2012 02:35 PM
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.
10-10-2012 12:03 PM
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.
10-10-2012 12:36 PM
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.
11-21-2012 10:40 AM
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 ...
12-09-2012 04:43 PM
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.
12-15-2012 07:16 AM
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?
2) Is there any overview document of changes made to OLEDB2 in 2013?
12-17-2012 06:36 AM
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.