Pricing - Supplier Prices

Overview

Used to record the default Supplier Prices for Materials, Components and Outwork Services.

Fields

• Active - The Status of the Supplier Price

• Supplier

• Reference

• VAT Type

• VAT - Exc or Inc VAT

• Unit Price 

• / - The quantity that the Unit Price applies to - eg. for products with small unit prices, you might add a Price / 1000 instead.

• Fixed Price

• CUR - Currency

• RoE - The Rate of Exchange to the local currency. This will be displayed as RoE / or RoE X depending on your currency settings.

• RoE Override - When checked, you are able to override the RoE, for instance, to hedge the exchange rate when calculating prices in a fluctuating currency. 

• Total Unit - The Unit Price for 1 item in Local Currency, excluding VAT, converted to the Base Unit and Adj % applied.

• Total Fixed - The Fixed Price in Local Currency, excluding VAT, converted to the Base Unit and Adj % applied.

The following fields refer to the last purchase - see the Transaction Setting below that determines the Transaction it is extracted from.

• Last Date - the date of the last purchase

• Last Price (ZAR) - the last Unit Price in the local currency - ZAR depicts the local currency in this example.

• Last Price (CUR) - the last Unit Price in the currency that was used

• Last CUR - The Currency of the last purchase

• Last RoE - The Rate of Exchange used in the last purchase

• Var (ZAR) - The difference between the current price and the last price in the local currency - ZAR depicts the local currency in this example.

Actions

The Actions can be applied to multi-selected Supplier Prices

• Batch Updates - Select a field and add a value. Click the Update button to update the multi-selected records.

• Update to last Purchase Price - Updates the multi-selected records from the last Purchase Order - includes Price, Currency, VAT Type, Adjustment

• Delete Supplier Prices

Updating Supplier Prices

General Setting > Items & Inventory > Setup - Cost Updates - Update options include:

• Supplier Price (Matching Supplier, Currency and Unit) - The matching Supplier, Currency and Unit is updated to the Transaction Amount

• Supplier Price  (Matching Supplier) - The matching Supplier is updated to the Transaction Currency, Unit and Amount.

• Supplier Price (All Suppliers and Prices) - All the Suppliers and Prices linked to the Item are updated to the Transaction Supplier, Currency, RoE, Unit and Amount. This setting should only be used when one Supplier Price is linked to an Item.

Settings

Transaction Types > Pricing > Default: Use in Pricing > Supplier Prices > Last Purchase (Y/N) - used to select which transactions are used to select the last purchase price.