Show/Hide Toolbars

Jim2® Business Engine Help File

On the ribbon, go to Tools > Options > Stock > Stock Pricing.


The Stock Pricing screen allows the setting of options relating to how stock is handled in the business.




From this screen, the following options can be set, all of which will have a global impact, meaning that every user accessing quotes is affected by what is set up here.




Calculate Tax on

When adding new stock, GST will be calculated on the actual selling price. This is a visual field only and cannot be changed, as all tax must be calculated on the selling price in the Australian taxation system.

Price calculation method

Choose which is the most appropriate method to use to calculate stock selling prices. This is only a default setting and can be altered to another method within each stock record.


Price calculation method


Fixed Price

A fixed price which is not altered by new purchase prices, etc.

Last COGS + Markup

The last COGS (cost of goods sold) of the stock, plus a percentage 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.)

Avg COGS + Markup

The average COGS of the stock on hand plus a percentage markup (see Average COGS example below).

Max COGS + Markup

The maximum COGS of the stock on hand plus a percentage markup (see Maximum COGS example below).

Last COGS + Margin

The last COGS of the stock plus a 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.)

Avg COGS + Margin

The average COGS of the stock on hand, plus a margin (see Avg COGS below).

Max COGS + Margin

The maximum COGS of the stock on hand, plus a margin (see Avg COGS below).

* Maximum COGS of stock on hand example: Buy 2 at a cost of $80 each, then buy a further 2 the same at $100 each, the maximum COGS is $100.

List – Discount

The list price minus a percentage amount (which can also be 0, ie. in a retail situation). When selected, this will show on an invoice report.

Avg PO Cost + markup

The average PO COGS, plus a markup, which changes only at point of purchase – not at point of selling(see Avg PO COGS below.)

Avg PO Cost + Margin

The average PO COGS, plus a margin, which changes only at point of purchase – not at point of selling(see Avg PO COGS below.)


The Last, Avg and Max COGS selections will update automatically within Jim2 when stock is purchased.


Avg PO COGS is strictly the average cost price paid for this stock, including on-costs/landed costs. Jim2 will recalculate this figure each time a purchase order is finished.


The Avg PO COGS field will show the average for all purchase orders.


How it relates to the Buying Tab

This is calculated by multiplying each (Qty x Cost) for each Purchase Order, totalling the amount, then dividing it by the total Qty.




The List Price selection will update when the List Price field is edited within s stock record.


The Fixed Price selection allows entry of a fixed price, which is not changed by purchase orders.


When in the stock record, the pricing method will only be visible in expanded view within the price grid (found by clicking the arrow symbol in the top left-hand corner of the grid).


Special stock has the following price calculation methods:




Special Stock covers stock where costs from the supplier will fluctuate. Special stock is also uniquely purchased for a specific job. The cost of goods will be taken across to the job when the stock is added, hence it uses the Exact COGS rather than the Last COGS.

Round sale price to nearest

This refers to the nearest number of cents to round stock prices to. For example, if dealing in cash transactions, round up or down to the nearest five cents to allow for change to be provided. This rounding is calculated on each price level entry and price break within each stock code. This rounding is not applied to a sub-total of multiple stock – it is applied at an each stock line level. When selecting the method to use for price calculations, remember that this rounding affects how the prices are calculated.

Floor cost markup %

A percentage loading 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.

Use Branch Pricing

If branches are enabled, this allows for setting pricing at a branch level. For example, if there is a branch in Sydney and a branch in Albury, the pricing might need to be different at each branch.

Show/Hide column in grid



Hide extra columns in Stock Prices Grid – Within the stock record, this will hide extra columns in the stock prices grid (tick to show only tax paid prices in stock records, or leave unticked to show both tax free and tax paid).

Hide Custom Price Rows – Within the stock record this will hide custom price rows in the stock prices grid – these are prices that are for a specific customer.


Hide Stock cost – Stock cost can be hidden within stock records, which is useful if there are times where customers may need to see the company pricing structures.

In stock price grid display


Select which price field should be shown in the price grid of the stock record when in collapsed view. This does not apply to the expanded view, found by clicking the arrow symbol in the top left-hand corner of the grid, as both the tax free and tax paid prices are shown in that view.

Stock Promotional Pricing


Default Value


I Call Promotion Pricing

Promotional Pricing

This can be renamed, ie. Bid Pricing or Pricing Agreements, and appears in both the ribbon and the Nav Tree under Stock when selected.



I call a Promotion


This can be renamed, ie. Promo, Bid or Agreement, and will appear in the Promotional Pricing list, and as the actual name:





Show PO Cost for Stock


Tick to display the promotional purchase price for stock when viewing or editing a promotion.

I Use Commission Sessions


Default Value


I use Commission Sessions


Tick to enable Commission Sessions.

Calc commission based on


The default way to base calculated commissions on:

Stock – commission calculated at stock line level

Job – commission calculated at a job total level.

Commission calc method


The default method to calculate commissions on:

Price Inc

Price Ex


Pay to

Account Manager

The default the commission is payable to:

Account Manager



Start Commissions from


Select a date here to filter out jobs with an invoice prior to this date.

Pay on

Date Out

Choose from Date Out or Date Paid.

Fully Paid


Tick to include only fully paid jobs in Commission Session.

Total <>0


Tick to include only jobs with a non-zero value.


Further information