+ Start a Discussion
Vj@88Vj@88 

Cannot query standard field 'subtotal' on standard Object 'QuoteLineItem' through SOQL

Not able to query the standard field 'subtotal' from quoteLineItem. 
Query: select subtotal from quotelineitem where id = 'xxxxx'
Error:No such column 'subtotal' on entity 'QuoteLineItem'. If you are attempting to use a custom field, be sure to append the '__c'

Can anyone help me on this?
Best Answer chosen by Vj@88
Balaji BondarBalaji Bondar
Hi Vj,

Please make sure that profile with which you are queying do have the field access.Subtotal is querable field on quoteLineItem.

All Answers

Balaji BondarBalaji Bondar
Hi Vj,

Please make sure that profile with which you are queying do have the field access.Subtotal is querable field on quoteLineItem.
This was selected as the best answer
Vj@88Vj@88
Thanks Balaji!!
Someone changed the fieldlevel security for that field. Resolved now.