Search our Help.

Price List Enquiry

Follow

About Price List Enquiry

The Price List Enquiry screen enables you to view all your products and all their prices (including price tiers).

You can also filter transaction by;

  • product,
  • product group, or
  • supplier.

You can also export a report to PDF for a crisp and clear report.  Otherwise, you can export to Excel to review more and analyze.
In addition, from this page, you can also view the Last Cost of all products.

 

Functional descriptions

 
 

 

Header filter descriptions

Product Code: Filter used to display a unique product code for the nominated line.
Product Description: Filter used to display a unique product description for the nominated line.
Product Group: Filter used to display a unique product group for the nominated line.
Supplier Code:  Filter used to displays a unique supplier code for the nominated supplier.
Supplier Name: Filter used to displays the name of the supplier for the specified line.

 

Grid columns descriptions

Code: Displays a unique code for the nominated line.
Description: Displays a unique description for the nominated line.
Purchase Price: Displays a purchase price for the nominated line.
Sell Price: Displays a sell price for the nominated line.
Last Cost: Displays the last cost for the nominated line.
Tier (1 - 10): Displays the tier (between 1 - 10) for the nominated line.  Price tiers on a product is different product levels for a product. For example, you could have the one price for retail, one for wholesale etc.

 

Hidden column descriptions

The following describes the three hidden columns.

Average Land Costs: Displays the average landed cost for the nominated line. It is the result of Stock Value divided by Stock on Hand.
Last Cost: Displays the Last Cost for the nominated line. This is a calculated field and will be the cost on the latest purchase order.
Product Group: Displays the product group for the nominated line.

 

Using the custom grid

Depending on what sort of information you require, you can enter the relevant criteria and then click Run at the top on the banner. You can also export what you see to several different formats such as pdf, xls and .xlsx using the Export button on the banner. Using the tool bar above the grid, you can do several other things to the information shown in the grid.

These are described as follows:

  • Group By Column(s):

To group by a desired column you simply need to drag and drop it into toolbar above the grid. As soon as you drop it the grid will group everything based on that column. You can group by as many columns as you like and expand all or collapse all the groups under the More menu.

  • Create Multiple Views:

To set up multiple views of this report you just need to click New on the toolbar and give it a name after making any customizations. You can create as many views as you like and also choose a default which will be displayed when you first click on the report.

  • Customize Columns Shown:

Using the Hidden Columns button you can choose what columns are shown on the grid and where. To add or remove a column, simply drag and drop the columns you like to and from the Hidden columns box.

 

How to filter transactions

To filter,

  1. Select the filters you want to search by product, product group or supplier.
  2. Press Run
Was this article helpful?
0 out of 0 found this helpful