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.

 

stockpricingoptions

 

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.

 

Field

Explanation

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

Explanation

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.

 

avgpocogs

 

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:

 

specpricecalc

 

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

showhide

 

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

inpricegrid
 

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

Option

Default Value

Explanation

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.

 

promoinnav

I call a Promotion

Promotion

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

 

promoname

 

promoname1

Show PO Cost for Stock

Ticked

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

I Use Commission Sessions

Option

Default Value

Explanation

I use Commission Sessions

Unticked

Tick to enable Commission Sessions.

Calc commission based on

Stock

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

Profit

The default method to calculate commissions on:

Price Inc

Price Ex

Profit.

Pay to

Account Manager

The default the commission is payable to:

Account Manager

Name

Other.

Start Commissions from

(blank)

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

Unticked

Tick to include only fully paid jobs in Commission Session.

Total <>0

Unticked

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

 

Further information