Embedded Files
Overview
Overview
The Selling Prices interface gives users an overview of cost and selling prices and lets users update the prices from the interface.
Information on prices:
Cost Prices can be calculated using a costing, supplier price, or manually updated. Cost prices can be automatically adjusted to cover additional costs (e.g. handling or landed costs).
Selling Prices can be calculated manually or automatically updated based on a cost price, supplier price, or costing and applying a mark-up.
Prices are assigned to a Unit and Currency. Only one price per unit and currency is allowed.
When prices are manually updated, the Cost Adj % and Sell Adj % fields are calculated based on the entered cost-and-selling-price amounts. Any amounts typed into those fields are overwritten by the calculation results.
When costs or prices are automatically updated, the percentages typed into the Cost Adj % and Sell Adj % fields are applied to calculate the cost and selling prices.
Navigation Example: Main Menu > Items > Pricing > Menu (button) > Selling Prices
Table of Contents
List View
List View
Buttons Explained
Buttons Explained
View: Generates a list of Sell Prices based on the selected Filters.
Save: Saves any changes or refreshes the view.
Actions:
Batch Updates: Updates are applied to all the selected records when the Update (button) is clicked. Batch Update options when no Price List is selected are:
Cost Price by %: Changes the percentage added to the Cost Price (e.g. to cover handling, breakage, shrinkage, landing costs) to the percentage typed in the block.
Selling Price by MU% :
Recalculates the Selling Price by marking up the Cost Price by the percentage typed in the block (Cost Price + Markup % = Selling Price).
Rounds the Selling Price by the integer typed in the second block (leave blank for no rounding).
Only affects Selling Prices set to manually update.
Selling Price by GM% :
Recalculates the Selling Price to achieve the percentage Profit typed in the block. (Selling Price - GM% = Cost Price).
Rounds the Selling Price by the integer typed in the second block (leave blank for no rounding).
Only affects Selling Prices set to manually update.
Selling Price by Profit:
Recalculates the Selling Price by adding the Fixed Profit typed in the block amount to the Cost Price.
Only affecta Selling Prices set to manually update.
Changes the Selling Price update method to be based on the cost price.
Selling Price by Amount:
Changes the Selling Price to the amount typed in the block.
Only affects Selling Prices set to manually update.
Selling Price by %:
Adjust the Selling Price by the percentage typed in the block. For example, type 10 to increase the price by 10% or -10 to decrease the price by 10%.
Will only affect Selling Prices set to manually update.
Round the Selling Price:
Rounds the Selling Price up to the nearest multiple of the number typed in the block. For example, 123.45 rounded to the nearest multiple of 5 = 125.00, rounded to the nearest multiple of 1 = R124).
This feature also rounds prices set to automatically update.
Price Qty (/):
Set the Quantity to which the Prices apply.
The default is 1, but for low-value items, you could set a price per 100 or price per 1000 units.
Add Currency:
Prices are added for the selected Currency if prices for the currency do not exist.
Warning: The price in the new currency is added with the same settings as the existing prices. But the price adjustments are not copied over.
Status:
Toggles the Cost and Selling Prices to be Active or Inactive.
Checkmark = Active.
Fixed Qty:
Changes the Fixed Quantity to the Quantity typed in the block.
VAT:
Changes the Default VAT Type to the type selected in the first block and / or
Changes whether the calculated price is Exclusive (Exc) or Inclusive (Inc) as specified in the second block.
Reapplies the current VAT percentage even if the VAT Type is unchanged.
Batch Updates: Updates are applied to all the selected records when the Update (button) is clicked. Batch Updates for Price Lists only affect the price filled in under the price list and all the applicable columns are hidden by default; they can be displayed using the Field Chooser (*). Batch Update options when a Price List is selected are:
Price List by % from Cost Price:
Changes the markup that is added to the cost price to the number typed in the adjacent block (e.g. 50 for 50%) to determine the Sell Price.
Sets the price to update automatically if the Auto checkbox is checked.
Price List by % from Sell Price:
Changes the adjustment that is added onto the Cost Price to determine the Sell Price to the number typed in the adjacent block (e.g. 50 for 50%).
Sets the price to update automatically if the Auto checkbox is checked.
Price List by Amount:
Changes the Price List's Sell Price to the amount typed in the adjacent block.
Sets the Price List to be manually updated.
Price List by Percent:
Increases or decreases the existing Sell Price by the amount typed in the first block (e.g. 10 for 10%).
Rounds the Sell Price up to the nearest integer based on the number typed in the Round to block (e.g. if 5 is entered, 99 will be rounded up to 100).
Sets the Price List to be manually updated.
Auto-update the Cost Price from the Highest Costing:
Changes the Cost Price setting, and the Cost Price (where applicable), to equal the Highest Costing for all the selected records.
The Highest Costing is the Supplier Price if the item is supplied or Costing Total if the item is produced.
When the Costing is updated, the Cost Price is automatically updated too.
Auto-update the Selling Price from the Cost Price:
Changes the Selling Price setting, and the Selling Price (where applicable), to automatically update based on the Cost Price for all the selected records.
The automatic update adds the Sell Adj % to the Cost Price.
Manually Update the Cost Price:
Changes the Cost Price setting to manually update for all the selected records.
Manual updates require you to review and update your Cost Prices manually.
Manually Update the Selling Price:
Changes the Selling Price setting to manually update for all the selected records.
Manual updates require you to review and update your Selling Prices manually.
Remove from Price List:
Only active if a price list is selected.
Removes the selected prices from the selected price list.
Delete Prices:
Allows users to delete the selected prices.
Prices linked to Costings will not be deleted.
Import Selling Prices (.csv):
Allows users to import Selling Prices.
Export Selling Prices (.csv):
Allows users to export Selling Prices.
Exports the prices in the Selling Price grid view and add a field for each price list which is in the same Currency.
Output: Generates price lists.
Menu:
Reset Data Filter: Resets the selected data filters.
Views
Supplier Prices: Switches the view to Supplier Prices.
Selling Prices: Switches the view to Selling Prices.
Inventory Prices: Switches the view to Inventory Prices.
Service Prices: Switches the view to Service Prices.
Items
Add new Item: Allows users to add a new item.
Add new Supplier Price: Allows users to add a new Supplier Price to an existing item.
Price Lists
Edit Price Lists: Allows users to add or edit a price list.
Link Customers to Price Lists: Allows users to add customers to a price list.
Email Excel: Allows users to email the list view by opening the default email template with the view attached in .xlsx format.
Save
Save (All Users)
Restore Default (All Users)
Filters Explained
Filters Explained
Category: A dropdown list allowing users to select a specific Category or All Categories.
Price List: A dropdown list allowing users to select a specific Price List or All the Price Lists.
Currency: A dropdown list allowing users to select a specific Currency.
Active: Checkbox. Checkmark = Only Active Prices are shown.
Fields Explained
Fields Explained
ℹ️ Fields marked in blue can be edited.
- However, fields that are set to automatically update will revert to their prices in the Item's Costing & Pricing tab once you click Save (button).
- Fields that are calculated will also revert to their calculation results even if they are overtyped.
- Click Save (button) to recalculate fields if you make any changes.
- Conditional formatting is used to highlight the low and high Profit, MU%, and GM% values.
Field Chooser (*): Allows users to add or remove columns.
ID: A system-generated number for the price.
Status: The Status of the price.
Category: The item's Category.
Subcategory: The item's Subcategory.
Description: The item's user-defined Description.
Reference: The item's user-defined Reference.
Code: The item's user-defined Code.
Customer: The name of the Customer that was selected in the item's header.
Type: The item's Type (e.g. Material, Service, Assembly).
Category (Customer): The category of the customer linked to the item.
In Stock: The Quantity that is currently In Stock.
Unit: The price's Unit.
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 Price is shown (the Fixed Price is excluded).
Fixed Qty: The Fixed Quantity that the price covers as entered in the Item's Costing & Pricing tab.
Costing Price: The Costing Price if a Costing is linked to the prices. If there are multiple Costing Prices, the Highest Costing Price (based on the Unit Price, excluding the Fixed Price) is displayed.
Sup Price: The Supplier Price of the supplier whose name is shown in the Supplier column.
Fixed Cost: The calculated Fixed Cost in the Pricing section of the Item's Costing & Pricing tab.
Unit Cost: The calculated Unit Cost in the Pricing section of the Item's Costing & Pricing tab.
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.
/ : The Quantity included in the Unit Cost Price (e.g. for products with small unit prices, you might add a price for 100 items instead of a price for 1 item).
Profit: The amount of Profit (difference between the current Cost and Selling Prices).
VAT Type: The VAT Type selected for the Selling Price.
VAT: Whether the price Includes (Inc) or Excludes (Exc) VAT.
Round: The amount the Selling Price must be rounded by.
Fixed Sell: The rounded Fixed Selling Price based on the Fixed Cost Price as per the Pricing section in the Item's Costing & Pricing tab.
Sell Adj %: The percentage by which the Cost Price must be adjusted to calculate the Selling Price.
Unit Sell: The calculated Unit Selling Price.
/ : The Quantity included in the Unit Selling Price (e.g. for products with small unit prices, you might add a price for 100 items instead of a price for 1 item).
MU%: The percentage Markup that the current Selling Price will achieve (the percentage added to the Cost Price to determine the Selling Price).
GM%: The Gross Margin percentage the current Selling Price will achieve (percentage of the Selling Price that is Profit).
Price List Name: The column is only available if a specific Price List is chosen. It displays the Price List's Selling Price.
Price List GM%: The column is only available if a specific Price List is chosen. It displays the Price List's Gross Margin Percentage.
Auto-update C/S: Whether the Cost and Selling Prices are automatically or manually updated. (E.g. if the Cost Price is manual and the Selling Price is automatic the field displays Man/Auto)
Actual Price: The Actual Price matches the specific price list price if there is one, else it matches the Unit Price.
Updated by: The User who last updated the item.
Update: The Date on which the item was last updated.
Menu (...): A submenu that can also be accessed by right-clicking the line.
Open Item: Opens the item's setup interface.
View Item Summary: Displays a Summary of the item and transactions on the right.
Related Topics
Related Topics
Page updated
Report abuse