Hi; I am a Lighting vendor and i give my quotations for Lights on a room wise basis.  I have created a extra column for the rooms.

In the quotation, the same light fixtures would be given in different rooms.

When i convert the quote to sales order, i want to get all the same items to be in a consolidated list, so that it is easier to get the total qty of the items and proceed with the PO and the invoicing later on.

How is this problem overcome.