Stock Main: Cost and Selling Prices

How do you want to calculate the selling price.

Option 1.

Use Group Pricing.

The mark-up will be determined by the inventory group. Set the minimum and maximum markup under Stock Items >Stock (Inventory) Groups.

If you want to set 'Use Group Pricing' as the default setting, go to Stock > Stock Options and select the New Defaults tab

Option 2.

Fixed

Deselect the

Check the Fixed option.

Type in the selling prices. Note first choose if you want to use Exclusive or Inclusive prices.

Option 3.

Markup on Cost.

Type in the minimum and maximum markup and then click on Spread Automatically or you can type in each markup.

Option 4.

Special prices.

Specify the dates and the selling price.

If you want to allow discounts on special prices, then you must allow it in the invoice options.

Option 5

Volume Discount.

If Volume Discount is enabled then it will override Price Levels (Buy X Get Y).

To add Volume Discount, click on the button (green plus sign) next to volume discount and fill in the fields.

For example, if you use volume discounts and the discount is configured so that if you sell 5 or more beers, you get a 15% discount. If you now sell a six-pack (6 beers), no discount is granted unless the Volume Discount: Use each quantity option is checked.

See also

Discount Rules

Adding different units

The Multiple Units of Measure enables you to define various units used to stock, purchase, and sell inventory items.

Example: A single beer a six pack (6 beers) and a crate must have different selling prices each with it's own barcode and the buying unit is a crate (24 beers). The cost of a single beer is $5.00

Add units and set the buying unit.

Step 1

Add all your units, e.g. crate, box, etc.  and specify the unit quantity for each unit.

Click the Next to

The 'each' will now be replaced with 'new unit'. Change the unit name now to Crate and the Unit Quantity to 24.

Repeat Step 1 for the Six pack.

Step 2.

Change the Buying Units to Crate (). The Supplier List Price will now change to the crates cost, in this instance $5 x 24 = $120

Test: Change the Show Prices For to each () and check that now reflects $5

Do the same for six pack and crate and make sure that the Cost Price For Price Calculations change to $30 ($5 x 6) and $120 ($5 x 24) respectively.

Remember - The Supplier List Price always reflects the buying units.

Change the selling prices for the different units.

Example: Single, Six Pack and Crate.

Step 1

Deselect

Step 2

Choose between

If fixed then choose how you want to put the prices in namely Exclusive or Inclusive

Step 3

In Show Prices For choose the unit and then put in the markups or the $ value. Repeat it for each unit.

Set the barcodes for the different units, example six pack or crate.

Go to the General Tab and click on the 3 dots () (next to the barcode button )

The form below will now open.

Type in the six pack's barcode and choose the unit. In this case six pack and do the same for crate.

If the units of measurement differs.

Example you buy tiles per box but sell per square meter.

Problem: The client wants 8 sq.m of tiles. You sell only in full boxes.

Step 1

Go to Stock > Stock Options and select Change Unit Calc Qty

Step 2

Create a unit for e.g. box with a unit quantity of 1.44

Each box have 4 tiles of 600mm x 600mm = 1.44 sq.m. per box

Don't forget to enter the units first, followed by the list price. If you do it the other way around, then the supplier list price will change.

Step 3

Create a new unit with name, for e.g. Sq.M. with a unit quantity  of 1

Step 4

Set the selling unit to Box and the buying unit to Box (Note both units are Box)

Step 5

On the invoice or quote, right-click on a header, select column chooser and drag the Qty Input column to the invoice form.

See image 1 & 2 Below

Step 6

Type the squares the client wants in the Qty Each Column, for e.g 8 sq.m. and press enter, the quantity will now change to 8.64 sq.m. because you only sell in full boxes. The Quantity | F12 column will display 6 boxes (8 sq.m / 0.36 sq.m (tile size) (6 boxes because you only sell full boxes)