You need to sign in to do that
Don't have an account?
Custom Field missing in Excel Connector from OpportunityLineItem
This is really strange.
I have a custom Text(25) field called 'Authorised By' (Authorised_By__c) on my Opportunity Product object. This field appears in the Salesforce Page Layouts and is editable.
Using the connector however, when i Describe the OpportunityLineItem object, this field does not appear.
Please note that:
I am using API version 16.
I have logged In and Out since the field was created
I am using the most recent version of the Connector and Office Toolkit.
Another Text Field called Opportunity_Product_Code__c does appear.
Security settings allow me to view and edit this field.
Has anyone ever heard of this happening? I know this issue has appeared before, however the issue is usually related to API version or something simple and fixable.
I left it overnight and this morning the issue has resolved itself.
All Answers
I left it overnight and this morning the issue has resolved itself.
The indexing Salesforce uses often lags, and new records/fields can take a while to be indexed (ie, be searchable).
That is probably what happened, and waiting overnight gave it time to get it indexed.
One possible alternative is that you needed to close out Excel completely after logging out. I'm not as certain if that is needed, but I have noticed that leaving Excel running seems to keep some of the connector's information stored even through a logout.