Home > SI 2016 Documentation > User Guide > Reports > Additional Reports > Proposals Sorted by Priority

Proposals Sorted by Priority

Table of contents

Video

 

Details

 

By default, the Proposal reports in SI 2016 sort alphabetically by Manufacturer. If you want Items to display in a particular order, you will need to use the customized Proposals attached to this page or create your own report, details of customization are in the video.

 

These reports were set up to use Custom Field 1 to indicate the priority of sorting Items and it is set to sort ascending. You can use numbers or letters to choose your sort order.

 

The screen shot below shows the default alphabetical sort order:

 

File:SIX_Guide/008_Reports/Additional_Reports/Proposals_Sorted_by_Priority/default_sort_order.jpg

Steps

 

  1. Download and import the attached file. It contains SI 2016 Proposal reports based off of the stock Proposals that ship with SI 2016. These custom reports have the words "(By Priority)" after them.

 

 

  1. Within your Project, assign the Products a number or letter in Custom Field 1. In this example, I used letters to determine the sort order. Of course this can also be done in your Catalog rather than having to do this on a per project basis. Please make sure to enter a letter on every line item otherwise the items with no letters assigned to them will be placed above the sorted items. You may use "Z" (without the quotes) for the items that do not need to be sorted. If you run out of letters, you can use a sequence similar to AA, AB, ... AZ, BA, BB, ... 

 

custom field 1.png

 

  1. When you run any of the "By Priority" reports, the Items in the report will now be sorted in the order you have chosen:

 

sorted by priority.png

Last modified
08:34, 2 Feb 2016

Tags

This page has no custom tags.

Classifications

This page has no classifications.