Item Price

Item Price records store the buying and selling prices for items. Prices can vary by price list, date range, and minimum quantity.

Creating an Item Price

  1. Go to Stock > Item Price and click New.
  2. Select the Item Code.
  3. Choose the Price List this price applies to.
  4. Enter the Rate (unit price).
  5. Optionally set:

- Valid From and Valid To: Effective date range

- Minimum Qty: Minimum order quantity for this price

- Customer/Supplier: Party-specific pricing

- Currency: If different from the price list currency

- Unit: UOM (if different from default)

  1. Click Save.

Price Types

Price List Purpose
Standard Buying Default purchase cost
Standard Selling Default sale price
Wholesale Bulk pricing for resellers
VIP Premium customer pricing
Export International pricing
Employee Staff discount pricing

Multiple Prices Per Item

An item can have multiple prices:

  • Different price lists for different markets
  • Quantity-based pricing (higher quantities, lower price)
  • Customer/supplier-specific negotiated rates
  • Seasonal pricing with valid-from/to dates

Price in Transactions

When adding an item to a transaction:

  1. The system checks the transaction's price list.
  2. It finds the matching Item Price record.
  3. If a Pricing Rule applies, it adjusts the price.
  4. The user can manually override the price (if permissions allow).

Importing Prices

Use the Data Import tool to import item prices from Excel or CSV files for bulk updates.