Cost Tab

Back Top Previous Next

The Cost tab depends on the selling price calculation as to what cost it picks up. For example, using List – Percent it will pick up either the vendor estimated cost or last cost, depending on the most recent date.

 

So, if the selling price calculation is Last Cost or List, it will pick up either Last Cost or Estimated Cost (most recent). If the selling price is Avg Cost plus it will pick up Avg COGS etc.

 

Info

Note: The Cost tab can be hidden via Tools > Security and unticking Show stock cost in stock grids and lists.

 

costsec

 

If the Vendor tab on the stock record is being regularly updated, it will use that cost – it may be worthwhile investigating eBusiness Connect to automate this process. Contact support@happen.biz for more information.

 

The Cost tab shows the expected cost of the stock being quoted, and the related vendor/supplier. The information is automatically added to this tab from the Vendor tab on the stock code (if populated) as stock is added to the quote.

 

quote cost tab

 

Info

Note: If Multi-Company is in use, costs are calculated from the cost of stock across all companies.

 

Price calculation method

Jim2 matches the price level (see Pricing tab in stock) with the current customer. If Jim2 finds a price level match, it will look at the Price Calc Method:

If Price Calc Method is Avg COGS + Markup or Avg COGS + Margin, Jim2 will get the Average COG Value.

If Price Calc Method is Max COGS + Markup or Max COGS + Margin, Jim2 will get the Max COG Value

If Price Calc Method is Est. Cost + Markup or Est. Cost + Margin, Jim2 will get the Vendor Estimated Cost (from the Vendors tab on the stock record).

 

All other values for Price Calc Method mean that Jim2 will get the Last COG Value.

 

The fields in the stock grid are explained below.

 

Grid Fields

Explanation

Date

The date the stock was entered.

Initials

User's initials.

Location

Branch (if branches are enabled).

Stock Code

This is the stock code being quoted.

Description

This is the stock description, automatically populated after the stock code has been entered.

Unit

Unit type.

Qty

This is the quantity of the stock being quoted on.

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).

Disc %

The discount provided, if any.

Tax

The tax code in use, eg. G for GST – the tax code is set up within the stock record.

Rec.

Recommended stock. Tick for yes, leave blank for no.

Hide

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

Total

Total price of the stock line.

The fields below always display amounts in the home currency. The Comm fields will only show if Commission Sessions have been enabled in Options.

Vendor

Enter a preferred vendor in this field if required. This is particularly useful as this information will flow though to jobs and auto created purchase orders. See Purchase Details below for further information on the Vendor and Markup % fields.

Markup %

The markup percentage (see a detailed explanation here).

Cost

This field is populated from the stock code, and would normally be the last cost (this can vary depending on the price level on the stock record). However, if a vendor is entered in the Vendor field, this amount can be changed.

Cost Total

The cost price multiplied by the quantity.

Total Ex.

The total price excluding GST.

Comm Floor

Used when calculating commission based on profit. If a commission floor cost is entered, profit calculations will use this value rather than the actual cost, eg. for cost $1000, actual cost $945, profit based on $1000.

Comm %

Percent of commission to be paid depending on commission method, ie. Price Inc, Price Ex or Profit.

Comm Extra

A flat dollar amount paid per stock sold, ie. for $100 for every 10 jackets sold.

 

The fields at the bottom right of the form are explained below.

 

Footer Fields

Explanation

SubTotal $

The total price, ex. GST, that stock will be sold for.

Cost Total $

The total price that was paid (or will pay) for this stock, ex. GST.

Profit $ (%)

Profit is shown as a percentage (in brackets), and as a dollar value in the field.

 

Purchase details

Purchase details are added in one of three ways: manually added to a quote, automatically added or updated via a promotion.

 

purchasedetails

 

The purchase details are used when creating a purchase order using the Auto Create Purchase Order function, and allow for pre-setting both the preferred vendor and cost (buy price). The cost value is also used for calculating the quote profit figures.

 

The purchase details show the source of the details (promotion, manually entered, etc.) and the source reference. The cost price is colour coded to indicate the source, and hovering over the Cost cell will display the details.

 

Purchase Source

Colour

Description

Manually Entered

Yellow

Cost price has been manually entered.

Promotion

Orange

Cost price based on a promotion.

 

Purchase details can flow through the entire sale process as follows:

Added to a quote when quoting the customer and sourcing buy details from the vendor.

Added to a job once the quote is accepted by the customer using Create Job.

Added to the purchase order from the job via Auto Create Purchase Order.

 

Commission details

Commission details are either manually added to a job/quote or automatically added or updated via a promotion. These fields will not appear unless Commission Sessions has been enabled in Options.

 

commissiondetails

 

The values that make up commission details are:

 

Field

Description

Comm Floor

This is the cost (in the home currency) that commission calculations will be based on.

Comm %

The percentage of commission to be paid based on the commission calculated method used.

Comm Extra

This is an additional amount (in the home currency) or a flat $ figure that will be paid as commission.

 

The commission details allow for pre-setting the commission values to use in a Commission Session, and are entirely optional.

 

The commission details show the source of the details (promotion, manually entered, etc.) and the source reference. The commission details are colour coded to indicate the source, and hovering over the cell will display the details.

 

Purchase Source

Colour

Description

Manually Entered

Yellow

Commission details have been manually entered.

Promotion

Orange

Commission details are based on a promotion.

Stock

Grey

Commission details are based on stock.

Commission Session

White

Commission details are based on entries in a Commission Session.

 

Commission Details can flow through the entire sale process as follows:

Added to a quote when quoting the customer.

Added to a job once the quote is accepted by the customer using Create Job.

Used in Commission Sessions when the job is invoiced.

 

Further information

Quote Cost Tab

Quote Footer

Quote Text Tab

Quote Invoice Details Tab

Quote Linked Jobs Tab