Vendor cost prices

Cost prices in Demand Planner are used in purchase orders and analytics. By adding them to your products you enable profits and margins to be calculated in the Inventory KPIs report and the correct prices to be used when generating purchase orders.

Please note: Cost prices should be stored and updated in Brightpearl's back-office. This data will be synced with Demand Planner.

View cost prices in Demand Planner

You can view cost prices for products in the various reports in Demand Planner, such as the Replenishment report or Inventory KPI report, and also on the Vendor > Variant page. Click the gear icon at the top of the page and ensure that 'Cost price' is selected.

When the cost price metric is added to reports, the price displayed will reflect the value in the price list belonging to the product's primary supplier, converted into your base currency if necessary.

The cost compare metric shows each cost price from all vendors associated with the SKU, in the vendor's currency.

Tiered pricing

When your supplier offers discounts based on bulk purchasing, you can use tiered pricing to control the price breaks. Go to the Vendors page, select a Vendor then click on Variants. Enable the 'Tier Prices' column using the gear icon on the right side to see price breaks.

mceclip0.png

The prices should also be managed within the back-office, read more about configuring price breaks in Brightpearl here. The prices will then be synced with Demand Planner.

Profits and margins

The profit and margin metrics use the actual Cost of Goods Sold (COGS) taken from the goods movement in Brightpearl to work out the profit amount and margin percentage. In other words, if the items have shipped, the FIFO cost is used. If not shipped, then the cost price list is used. Read more here.

Have more questions? Submit a request