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 or manually updated. Cost prices can be automatically adjusted to cover Handling and Landed Costs.
Selling Prices can be calculated manually or automatically using a costing, applying a margin, or marking up the cost price.
Prices are assigned to a Unit and Currency. Only one price per unit and currency is allowed.
When costs or prices are set to be 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 will be overwritten by the calculation results.
When costs or prices are set to be automatically updated, the percentages typed into the Cost Adj % and Sell Adj % fields will be applied to calculate the cost and selling prices.
Navigation: Main Menu > Items > Pricing > Menu (button) > Selling Prices
Table of Contents
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 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).
Will only affect 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).
Will only affect 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.
Will only affect 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.
Will only affect Selling Prices set to manually update.
Selling Price by Percent:
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 will also round 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 will be 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.
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 will be 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 the Selling Prices.
Will export 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)
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 will be shown.
ℹ️ 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.
Category: The item's Category.
Status: The Status of the price.
Description: The item's user-defined Description.
Reference: The item's user-defined Reference.
Sub-category: The item's Subcategory.
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).
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 will be 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) will be 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).
Sell GM%: The Gross Margin percentage the current Selling Price will achieve (percentage of the Selling Price that is Profit).
Price List Name: The column only appears if a specific Price List is chosen. It displays the Price List's Selling Price.
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 will display: 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 sub-menu that can also be accessed by right-clicking the line.
Open Item: Opens the item's setup interface.
Open Item Dashboard: Opens a Dashboard with a Summary of the item's activity.
View Item Summary: Displays a Summary of the item and transactions on the right screen.