Which product sell prices need to be fixed

What products with stock on hand have sell prices with low GP or unreasonably high or low GP%, even if the product has not sold recently? 

How can my team notice products with crazy sell prices in the normal course of day to day business, without having to running a report?

From the Navigation panel, select Inventory then Products

When the products tab displays, select the "Products with stock levels" list view from the drop down

• • Click on the "View Variants" button and save a view variant with a name of List "Product Price Review"

• The list on the screen will change to some other list view.  This is now the list view behaves when you save a list view.  The system drops off that view and switches to another.  Product list view often switches to "Grouped by category".  Click on the views list above the product browse and select the "Product Price Review" list from the available options.
• Right click on the column headings on your product list then left click on filter editor

* Click on the Text area below of the filter editor and then copy and paste the text below into the filter editor text tab.  Then click on the visual tab, the visual tab should not be grey, then click on the OK button to save the filter

• Now your product list view is showing products with stock on hand and low GP on the default list price.  You need to now add additional sell price fields to your product list view to help you review the prices.
• Right-click on the product list view column header and select "Column Chooser".

• • Then click on the "Add" button
    
    

• Find "default product price level" in the field list.  Then click on the expand arrow to the left of the "default product price level" field.  Then click on the check boxes next to the fields shown on the image below.  Remember to click "Default sell unit, the last field on the picture.  Then click the "Add" button

• All the fields you checked will now appear in the field chooser

• Drag those fields to become the right-hand side headings on your product list view

• Finally, use conditional formatting to colour the exceptions you care about such as high value on hand and low GP.  Note: columns based on DefaultProductPriceLevel cannot be sorted/filtered.

Now to make all of the above worth doing, make an action item to use this report and monitor action taken