Error "INVALID_FIELDinvalid field for query" on Select Billing account page

[Manojna]

When a custom formula field is added in the fieldset, Billing Accounts(Zuora__fields_for_select_billing_account_compon) of the Billing account object,error

"Server Exception: fns:INVALID_FIELDinvalid field for query:" is thrown on the Select Billing account page

[Manojna · Accepted solution]

During Quote creation process, while displaying Billing account fields,they are queried from corresponding Zuora tenant with an API call and hence is thrown because of the missing custom field in Zuora.

To avoid this, There is a Quote configuration setting, "Get Billing Accounts From 360"  which can be turned on

Below is the more information on the same

• Select to obtain Billing Account information directly from Zuora 360 in Salesforce.

• We recommend that you have Real-time Sync enabled when using this setting to always have the most up-to-date Billing Account data.

• If you have a custom field on the Billing Account object, enable this setting to avoid an error from the corresponding custom field missing in Zuora

KC for reference - https://knowledgecenter.zuora.com/CA_Commerce/C_Zuora_Quotes/CB_Zuora_Quotes_Configuration_Settings/...