Quote Stock Grid

Back Top Previous Next

The third section of the Quote form contains a grid that is used to record and automatically price any stock being quoted to the customer. Price calculations are determined by the price levels, price breaks and tax requirements, as set in the customer's cardfile, as well as the stock mark-up calculation, that is set in each stock record.

 

The initial view of the grid is the:

 

Standard view

quotestockstd

 

However, by clicking the arrow arrow symbol at the top left of the grid, change to the:

 

Expanded view

quotestockexp

 

The stock lines within the grid can be reordered:

 

Movestocklines

 

The stock grid area can be expanded by clicking and dragging the horizontal dots up and down. Double clicking the dots will hide the stock grid completely. Double click again to show.

 

Hidegrid

Whilst this shows an expense order, the process is the same for all objects

 

The fields within the stock grid are described below.

 

Field

Explanation/Purpose

Notes

Date

The date the stock line was added to the quote.

Only shown in expanded view.

Initials

The initials of the user who added the stock.

Only shown in expanded view.

Location

The location of the stock when quoted.

Only shown in expanded view.

Status

Allows selection of status for that particular stock line.


Stock Code

The stock code will identify the product or service being ordered. Selections can be made from the Stock Select screen – stock records via the ellipsis [...] drop down list beside this field.


Description

The description of the stock code from the stock record is automatically placed in this field. If there are multiple measures for this stock, it will use the description appropriate for that measure.


Unit

The unit measure to use to sell for that stock code is selected.


Qty

Quantity quoted.


Qty Avail.

This will show the current available quantity for that stock. You can right click within the grid to show quantity available on the fly to see what is available to sell right now. Once selected the first column will change to a green background.

This must be set up in Tools > Options > Quote first.

Price Ex.

This is the price of the goods tax free (excluding GST).


Price Inc.

This is the price of the goods including tax (including GST) – the tax code is set up within the stock record.


Disc %

Discount provided, if any.

Only shown in expanded view.

Tax

Tax code.


Rec.

Recommended stock – tick for yes, leave blank for no.

This allows flagging stock as recommended at a line level. When printing the quote, include both the total of the recommended options as well as extras. Very useful when used in conjunction with Kitting.

 

If left unticked, the value will drop down into the Optional Extras field on the quote report.

Hide

When printing the quote, this provides the option of hiding individual quote lines or prices.

If a black box shows in the Hide box, this will hide the pricing but still show the stock.

Total

Total price of that stock line.


Vendor

If the price for this line of stock is obtained from a particular vendor for the quote, record that vendor in this field. It will also automatically populate if there is a Vendor in the Cost tab.

Only shown in expanded view.

 

Info

Note: This field is manually populated, except when Promotional Pricing is used – in that case it will populate from the Promotion.

Markup %

(this may also be called GP%)

This is the difference between cost and sell prices as a percentage. Determine this percentage by entering the price and letting Jim2 calculate the margin, or enter the cost and a percentage (say, 10% margin) and let Jim2 calculate the price.

The field, and actual figures displayed, depend on the Show Profit Percent as .. choice, made in Tools > Options > Job.

 

Sell details

sell details

 

Sell details are automatically added or updated when adding stock to a quote, or when recalculating the selling price. The sell details show the source of the selling price (price level, promotion, project, etc.) and the source reference. The selling price is colour coded to indicate the source, and hovering over a sell price cell will display the details.

 

Sell Source

Colour

Description

Price Level

White

Sell price is as per price level set on Quote header.

Different Price Level

Pink

Sell price is based on a price level different to the price level set on Quote header.

Customer Specific

Green

Sell price is as per the customer-specific price on the related stock.

Manually Entered

Yellow

Sell price has been manually entered.

Promotion

Orange

Sell price based on a promotion.

Project

Purple

Sell price is based on the price level of the related project.

Min Sale

Red

Sell price is set to the stock’s minimum sell price level.

 

Within the stock grid, search all columns and rows by pressing Ctrl+S. This will bring up the Locate value screen, where select which field to search by entering the text to search for in the Value field.

 

locate value quote

 

Other operations can be performed by right clicking in the grid and choosing one of the following.

 

Right Click Option

Explanation/Usage

Add New

Will add a new line.

Delete

Will delete the line including the stock that has been added to the quote.

View Stock

Is a hyperlink and will move to that particular stock record.

Show Attributes

This will show attributes of the stock, if attributes are enabled.

Recalculate Current Stock Price

This will recalculate the value of the stock selected in the grid.

Recalculate All Stock Prices

This will recalculate the value of all the stock in the grid.

Grid Columns...

 

quote stock grid

This sets up the grid columns that will be displayed for either this user or all users. In expanded view, all grid columns are displayed by default. In collapsed view, the following columns are not shown:

Date

Initials

Location

Disc %

Vendor

 

Add or remove grid columns by ticking the box, then clicking Apply. Click OK and a message will appear offering to update all users to the new layout as well.

 

update layout

 

Upon saving, all columns will be shown. Click on the arrow at top left of the grid in either Edit or View mode to view only the columns required.

 

gridcols

 

Further Information

Quotes Security

Quotes at a Glance

Quote Comment grid

Quote Footer

Quote Header

Quote list

Quote list Header

Quote Options

Quote Preview Pane

Quote Reports

Quote Status

Quote Stock Availability

Quote Stock Grid

 

How to

Add a Document to a Quote

Add a Quote

Add Stock to a Quote

Create a Job from a Quote

Create a Quote from a Previous or Similar Quote

Create a Template for Recurring Quotes

Create a quote list

Personalise Quotes

Print a Quote

Use comments to Track the Progress of a Quote

View or Edit a Quote