Pricing - Supplier Prices
Overview
This report shows the default Supplier Prices for Materials, Components and Outsourced Services.
Supplier prices refer to the prices charged by suppliers for goods or services acquired from them.
Settings
Transaction Settings
The following settings can be added to Purchase Orders:
Note
The defaults are the values for new databases, new users and new Transaction Types. Your database may have different values.
| Setting | Description | Default |
|---|---|---|
| Pricing > Use in Pricing > Supplier Prices > Last Purchase | Checkbox. If checked, the price is updated. | Unchecked |
List View
Buttons Explained
| Button | Description |
|---|---|
| View | Generates a list of Supplier Prices based on the selected Filters. |
| Save | Saves any changes or refreshes the view. |
| Actions |
|
| Output | Generates Price Lists. |
| Menu |
|
Filters Explained
| Filter | Description |
|---|---|
| Category | Select a specific Category or All Categories. |
| Supplier | Select a specific Supplier or All Suppliers. |
| Active | Checkbox. Checkmark = Only Active Supplier Prices appear. |
Fields Explained
Info
Fields marked in blue (✎) can be edited.
| Field | Description |
|---|---|
| Field Chooser (*) | Add or remove columns. |
| ID | A system-generated number for the supplier price. |
| Category | The item's category. |
| Status (Item) | The item's status. |
| Status (Price) | The status of the price. |
| Subcategory | The item's Subcategory. |
| Description | The item's user-defined description. |
| Code | The item's user-defined code. |
| Reference | The item's user-defined reference. |
| Type | The item's type (e.g. material, service, assembly). |
| Supplier | The name of the Supplier selected under Supplier Prices in the Item's Costing & Pricing tab. If there is more than one supplier, the supplier with the highest unit cost appears. |
| Supplier Reference | The Supplier's unique Reference (e.g. Code) entered under Supplier Prices in the Item's Costing & Pricing tab. |
| Fixed Price | The Fixed Price filled in under Supplier Prices on the Item's Costing & Pricing tab converted to the Base Unit. |
| VAT Type | The VAT Type selected for the supplier price. |
| VAT | Whether the price Includes (Inc) or Excludes (Exc) VAT. |
| Unit Price (CUR) | The Unit Price entered under Supplier Prices on the Item's Costing & Pricing tab converted to the Base Unit. |
| / | The Quantity included in the Unit Price (e.g. for products with small unit prices, you could add a price for 100 items instead of a price for one item). |
| Unit | A code describing the Unit. |
| CUR | The price's Currency. |
| RoE Override | A checkbox. Checkmark = You can override the Rate of Exchange. |
| RoE X | The current Rate of Exchange which equals one for local prices. This field appears as RoE / or RoE X depending on the Currency Settings. |
| Cost Adj % | The percentage that must be added to the Cost Price as set on the Pricing section of the Item's Costing & Pricing tab. |
| Adj % | The percentage that must be added to the supplier price as set on the Supplier Prices section of the Item's Costing & Pricing tab. |
| Total Fixed | The Fixed Cost as per the Pricing section in the Item's Costing & Pricing tab. (Fixed Price + Adj% = Supplier Price + Cost Adj % = Fixed Cost.) |
| Cost Price | The Total Cost Price on the Pricing section of the Item's Costing & Pricing tab. (Unit Price + Adj% = Supplier Price + Cost Adj%.) |
| Unit Price (ZAR) | The Total Unit Price on the Supplier Price section of the Item's Costing & Pricing tab. (Supplier's Unit Price + Adj %.) |
| Unit | A code describing the item's Base Unit. |
| Last Date | The Last Date on which the price was used. |
| Last RoE | The last Rate of Exchange that was used. |
| Last Price (CUR) | The Last Unit Price. |
| Last CUR | The Last Currency for which the price was used. |
| Last Price (ZAR) | The Last Unit Price in Local Currency where ZAR = Local Currency. |
| Var (ZAR) | The difference between the Unit Price on the Item's Costing & Pricing tab (Column: Unit Price ZAR) and the Unit Price on the Last Purchase Order). |
| Updated | The Date on which the item was last updated. |
| Updated by | The User who last updated the item. |
| Menu (...) | A submenu that can also be accessed by right-clicking the line.
|