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. If using floor cost markup %, a percentage loading is added to the actual cost of stock in order to increase the visible last cost. This compensates for handling costs, etc. in order to reflect the real cost of this stock

 

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: If Multi-Company is in use, costs are calculated from the cost of stock across all companies.

 

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.

 

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.

 

Info

Note: The cost is only estimated until the job is invoiced, unless a purchase order is linked to a job and the purchase order is finished.

 

jobcosttab

 

On the Cost tab, there are extra fields added to the job tab's expanded view. These extra fields relate to the cost price of goods and/or services. In the footer area the Tax $ and Total $ amounts are replaced with fields which show the total cost price and profit related to the job.

 

jobcostfield

 

The Cost tab's fields are explained below. See Purchase Details further below for information on the Vendor and Manual Cost fields.

 

Parts Grid

Description

Date

This is the date the stock is entered on the job.

Initials

Initials of the person adding the job/stock.

Status

Choose a status at line level here. A message will appear asking if the job status is to be changed as well. Choosing No will leave the job status as is.

 

jobstatustab

 

The statuses chosen from here are based on what is set up in Status.

PO#

Linked purchase order number for this stock line.

 

Note: This purchase order number cannot be added or changed. It will automatically populate on auto create PO.

PO Due

This displays the due date of the linked purchase order at line level, or purchase order header due date, if not set at line level on the purchase order.

Stock Code

Enter a stock code here, or select the ellipsis [...] which will bring up the Stock Select screen for searching.

Description

The description will default here from the stock code. This information can be amended or added to.

Unit

The unit measure. A default unit measure will appear here. Choose from the drop down down arrow to use a different unit measure. This is based on what unit measures are set up on the stock code.

Order

Enter the quantity required for the job.

Supply

Enter the quantity to be supplied.

B.Ord

If the quantity supplied is more than is available, this field will autofill with the back order quantity.

Qty Pick

Only appears for Advanced Warehouse Management.

Price Ex.

Price excluding GST.

Price Inc.

Price including GST.

Disc%

Enter a discount as a percentage here.

Tax

Select the correct tax code (normally G).

Total

Total price for this line.

Est. Cost

The estimated cost for all of the goods and/or services used, excluding tax.

Cost Total $

The total cost for all of the goods and/or services used, excluding tax.

Markup %

or
Margin %

The difference between the cost price of a stock or service and its selling price, displayed as a percentage. Choice as set up in Tools >Options > Jobs.

 

markup

 

Margin

Margin is sales minus the cost of goods sold. For example, if a product sells for $100 and costs $70 to manufacture, its margin is $30. Or, stated as a percentage, the margin percentage is 30% (calculated as the margin divided by sales).

Markup

Markup is the amount by which the cost of a product is increased in order to derive the selling price. For example, a markup of $30 from $70 yields a selling price of $100. Or, stated as a percentage, the markup percentage is 42.9% (calculated as the markup amount divided by the product cost).

Total

The total cost of all units of stock or service, excluding tax.

The following fields display amounts in the home currency. The Comm fields will only appear if Commission Sessions are enabled in Options.

Vendor

The vendor the cost price was sourced from, and who a purchase will be created for when using auto create purchase order.

Manual Cost

The cost price that is used in job profit calculations. This will be used when using Auto Create purchase order.

Estimated Cost

The estimated cost price of each line of stock or service, excluding tax.

Cost Total

The total cost price of each line of stock or service, excluding tax.

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. For example: cost $1,000, actual cost $945, profit is based on $1,000 floor cost.

Comm %

Percentage of commission to be paid, depending on commission method: price inc, price ex, or profit.

Comm Extra

A flat dollar amount paid per stock sold. For example, $100 for every XYZ sold.

Note: Commission components can be combined. For example 10% commission of profit based on floor cost plus an extra $10.

 

Info

In Jim2, cost prices are always displayed to four decimal places.

 

Purchase details

Purchase details are manually or automatically added to a quote (from the stock code Vendors tab), 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 job profit figures. When a job is invoiced, the actual cost values are used.

 

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 coloured cell will display the details.

 

Purchase Source

Colour

Description

Manually Entered

Yellow

Cost price has been manually entered.

Promotion

Mustard

The 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 clicking Create Job (in the footer)

added to the purchase order from the job via auto create purchase order (right click in the grid).

 

Commission details

Commission details are added manually or automatically to a job, or updated via a promotion.

 

commissiondetails

 

The values that make up commission details are (all in home currency only):

 

Field

Description

Comm Floor

This is the cost that commission calculations will be based on.

Comm %

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

Comm Extra

This is an additional amount or a flat dollar 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 optional.

 

These 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

Mustard

Commission details are based on a promotion.

Stock

Grey

Commission details are based on what is entered in the stock record.

Commission Session

White

Commission details are based on what is entered 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 clicking Create Job (bottom left of screen).

Used in Commission Sessions when the job is invoiced.

 

Within the stock grid, search all columns and rows by selecting Ctrl+S. This will bring up the Locate value screen, where the field to search can be entered, along with entering text in the Value field.

 

locatevaluescreen

 

Further information

Document tab

Invoice Details Tab

Job Footer

Job Tab

Labour Tab

Linked Jobs/Quotes Tab

Promotional Pricing Tab

Stats Tab

Tasks Tab