+ Start a Discussion
dmondmon 

Sort Order field name for Quote Line Items?

Anyone know what the field name is used to store the sort order for quote line items?

The equivalent for opp line items is called "SortOrder"

 

I want to query and order by this field....

 

thanks in advance,

dale

ClintLeeClintLee

There is a field named LineNumber on the line item.  It's auto-generated so sorting it in ascending order should put the line items in order of creation.

 

Hope that helps,

 

~ Clint

mms16mms16

What is a user clicks 'sort' and changes the order of the line items.

 

We desparately need to be able to extract the sort order (NOT the 'lineItemNumber' or 'Creation Date order') for quote line items from SFDC to our accounting system using Boomi.

 

By defualt Boomi extracts the lines based on 'lineItemNumber' (aka 'Creation Date order'), but the reps may have changed the order. SFDC needs to expose to the API the current sort order so that the sequence of quote lines can be replicated externally.

 

Additionally, is there an easy way to disable line item sorting on quotes and ops?

Rodrigo Sakakibara (Dev)Rodrigo Sakakibara (Dev)

If you sort the lines, the information is stored in the field "SortOrder", see data of example below...

User-added image

Regards,

Rodrigo Sakakibara

jbardetjbardet
Is there any way to use the QuoteLineItem's sort order in a pageblocktable using standard controller for quotelineitems? I have a page that is an ehnanced version of the "Edit All" button found on Quote Line Item's relatest list from Quote page, so users need and expect the VF page to display the Quote Lines in the same order as they saw on the related list.