Cost and Selling Prices

Top  Previous  Next

Go to Stock Items > Main Form and select the Cost and Selling Prices Tab

Hover the mouse over the different fields on the form. If the cursor changes to a hand (Hand_Cursor) , click to get more information.

Stock Age For PricingBuying CurrencyDefault WarehouseWebAtribute / Feature ...Supplier OverheadSpreadVolume DiscountGreen PlusBuying And Selling UnintsUnitsSpecialCost price for price calculationsFixedGroup PricingPrices 1 to 10Show On InvoiceSuppliers List PricePricing MethodCost of SalesLast Purchase CostAverage CostComponent TabAdditional info TabGeneral TabStock_Cost

 

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 graphic

Check the Fixed option. graphic

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

graphic

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.

graphic

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 next to volume discount and fill in the fields.

See also

Discount Rules

 

Adding different units

graphic

 

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 graphic Next to graphic

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 (graphic). 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 (graphic) and check that graphic 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 graphic

 

Step 2

Choose between graphic

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.

graphic

 

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


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

The form below will now open.

graphic

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

graphic

Step 3

Create a next 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, right click on a header, select column chooser and drag the Qty Each 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)

 

 

Image 1 - Column Chooser

Column_chooser

 

Image 2 - Invoice

Invoice_diff_measure

See also Discount Rules

Suppliers List Price does not Update

Please note that the Supplier List Price will only be updated for that specific Supplier. For example, say the preferred supplier is Midas and the suppliers' list price is $18, you now created a GRN for that item, but you received the item from another supplier, for e.g. Rectron. The supplier list price for Midas will remain $18, but the supplier list price of Rectron will be updated, that is to say if Rectron was added under Other Suppliers on the Main Inventory form.

 

http://bit.ly/SiCostAndSellingPrices