Opportunity Products not sorting nor in order

My Quotes look somewhat good except the order of the Opportunity Products in the table. No matter the order on the Salesforce Opportunity Products page the quote puts the line items in a different order. As you can see it makes it look jumbled. I have a "Family" category (Staff, Glassware, hors d'oeuvres, liquor) but I can't make it populate to the Quote.

How can I sort the hors d'oeuvres from the staff from the liquor in the quote? I could use the Family field (pick-list) as the determiner as to the grouping. It would look better probably if each Family had their own table (list & price of staff; list & price of hors d'oeuvres; etc.) on the same sheet of the quote, but I have no idea how to sort based upon Family. Does anyone know?

Here is the code that produces the jumbled Quote that I am using without any sorting or grouping by Family:

<apex:page standardController="Opportunity" showHeader="false" renderas="pdf">

<table border="0" cellspacing="0" cellpadding="0" width="100%" id="table1">
<tr>
 <td>
 <img src='{!URLFOR($Resource.Logo4567687)}' title="logo" />
 </td>
 <td align="right">
 Quote for: <apex:OutputField value="{!Opportunity.Date_Taken__c}"/> 
 
 Sloan Professional Services, LLC 
 
 563 West 139th Street 
 New York, New York 10031 
 (646) 678-0380 New York 
 (310) 710-6668 Los Angeles 
 
 </td>

</tr>

<hr/>

</table>
<table border="0" cellspacing="0" cellpadding="0" width="115%" id="table1">
<tr>
 <td align="center">Quote valid through: <apex:OutputField value="{!Opportunity.CloseDate}"/> 
 Proposed by: {!Opportunity.Owner.FirstName} {!Opportunity.Owner.LastName}
 </td>
</tr>
</table>
 
<hr/>
Client Information

<table border="0" width="100%" id="table2">
<tr>
 <td align="center">
 {!Opportunity.Name}'s Event 
   <apex:OutputField value="{!Opportunity.Event_Start_Date__c}"/> from {!Opportunity.Event_Start_Time__c} to {!Opportunity.Event_End_Time__c} 
 at 
 {!Opportunity.Event_Location__c} 
 </td>
 </tr>
<tr>
 <td>
 Bill To: 
Karlie Lahm 
{!Opportunity.Account.Name} 
 {!Opportunity.Account.BillingStreet} 
 {!Opportunity.Account.BillingCity}, {!Opportunity.Account.BillingState} {!Opportunity.Account.BillingPostalCode} 
 {!Opportunity.Account.Phone} 
 
 </td>
 </tr>
</table>
 
<hr/>
Products
<table border="0" width="100%" id="table4">
<tr>
 <td bgcolor="#ffffcc">Product</td>
 <td bgcolor="#ffffcc">Product</td>
 <td bgcolor="#ffffcc">Quantity</td>
 <td bgcolor="#ffffcc">Description</td>
 <td bgcolor="#ffffcc">Unit Price</td>
 <td bgcolor="#ffffcc">Total Price</td>
</tr>
<tr>
 <apex:repeat value="{!Opportunity.OpportunityLineItems}" var="line">
 <tr>
 <td>{!line.PricebookEntry.Name}</td>
 <td>{!line.Quantity}</td>
 <td>{!line.Product_Description__c}</td>
 <td><apex:OutputField value="{!line.UnitPrice}"/></td>
 <td><apex:OutputField value="{!line.Line_Item_Total__c}"/></td>
 </tr>
 </apex:repeat>
</tr>
<tr>
 <td bgcolor="#ffffcc" align="right" colspan="7">
 Total: <apex:OutputField value="{!Opportunity.Total_Event_Price__c}"/></td>
</tr>
</table>
 
<hr/>
Terms and Conditions
<table border="0" width="100%" id="table3">

<tr>
 <td>

 Start date: <apex:OutputField value="{!Opportunity.Date_Taken__c}"/> 
 Contract End date: <apex:OutputField value="{!Opportunity.CloseDate}"/> 
 
 </td>
 </tr>

<tr>

 <td>
 Payment Method:<apex:OutputField value="{!Opportunity.Method_of_Payment__c}"/> 
 Remainder Due: <apex:OutputField value="{!Opportunity.Final_Payment_Due__c}"/> 
 

 </td>


</tr>
 
 <td>{!Opportunity.Contract_Narrative__c}
 
 
 To reserve staff and/or products for your event you must pay a deposit of 80%
 of the total event fee. Full payment for the staff is due no later than 24 hours
after your event. An adjusted invoice based upon actual hours and participation will be presented within 24 hours of the event end. Cancellation of the event will forfeit
 the entire deposit. Payment via credit card is also acceptable. Please make all checks out to Sloan Professional Services, LLC.
 
 </td>
</table>
 
<hr/>
</apex:page>

Thank you,
Brett

August 31, 2010
·
Answer
·
Like
0
·
Follow
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Opportunity Products not sorting nor in order

You need to sign in to do that.