Pricing - Selling Prices

Overview

The Selling Prices refer to the prices charged to customers. The interface provides 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 markup.
  • 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 entered in those fields are overwritten by the calculation results.
  • When costs or prices are automatically updated, the percentages entered in 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

List View

Buttons Explained

Button Description
ViewGenerates a list of Sell Prices based on the selected Filters.
SaveSaves 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 entered in the block.
    • Selling Price by MU% :
      • Recalculates the Selling Price by marking up the Cost Price by the percentage entered in the block (Cost Price + Markup % = Selling Price).
      • Rounds the Selling Price by the integer entered 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 entered in the block. (Selling Price – GM% = Cost Price).
      • Rounds the Selling Price by the integer entered 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 entered in the block amount to the Cost Price.
      • Only affects 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 entered in the block.
      • Only affects Selling Prices set to manually update.
    • Selling Price by %:
      • Adjust the Selling Price by the percentage entered in the block. For example, type 10 to increase the price by 10% or -10 to decrease the price by 10%.
      • Only affects Selling Prices set to manually update.
    • Round the Selling Price:
      • Rounds the Selling Price up to the nearest multiple of the number entered 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 1 000 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: 
    • 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. Use the Field Chooser (*) to show them. 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 entered 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 entered 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 entered 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 entered in the first block (e.g. 10 for 10%).
      • Rounds the Sell Price up to the nearest integer based on the number entered in the Round to block (e.g. if 5 is entered, 99 is 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: 
    • Delete the selected prices.
    • Prices linked to Costings are not deleted.
  • Import Selling Prices (.csv): 
  • Export Selling Prices (.csv): 
    • 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.
  • View Changelog: Displays changes made to inventory prices.
  • Views
  • Price Lists
  • Layout & Grids
    • Save
    • Save (All Users)
    • Restore Default (All Users)

Filters Explained

Filter Description
CategorySelect a specific Category or All Categories.
Price ListSelect a specific Price List or All the Price Lists.
CurrencySelect a specific Currency.
ActiveCheckbox. Checkmark = Shows only Active Prices.

Fields Explained

Warning

Fields marked in blue can be edited.

  • However, fields that are set to automatically update revert to their prices in the Item's Costing & Pricing tab once you click Save (button).
  • Fields that are calculated also revert to their calculation results even if they are overtyped.
  • Click Save (button) to recalculate fields if you make any changes.
  • Conditional formatting highlights the low and high Profit, MU% and GM% values.

Fields marked in blue (✎) can be edited.

Field Description
Field Chooser (*)Add or remove columns.
IDA system-generated number for the price.
Status (Price)The Status of the price.
CategoryThe item's Category.
SubcategoryThe item's Subcategory.
DescriptionThe item's user-defined Description.
ReferenceThe item's user-defined Reference.
CodeThe item's user-defined Code.
CustomerThe name of the Customer that was selected in the item's header.
TypeThe item's Type (e.g. Material, Service, Assembly).
In StockThe Quantity that is currently In Stock.
UnitThe 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 appears (the Fixed Price is excluded).
Fixed QtyThe Fixed Quantity that the price covers as entered in the Item's Costing & Pricing tab.
Costing PriceThe 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) appears.
Sup PriceThe Supplier Price of the supplier whose name appears in the Supplier column.
Fixed CostThe calculated Fixed Cost in the Pricing section of the Item's Costing & Pricing tab.
Unit CostThe 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 one item).
ProfitThe amount of Profit (difference between the current Cost and Selling Prices).
VAT TypeThe VAT Type selected for the Selling Price.
VATWhether the price Includes (Inc) or Excludes (Exc) VAT.
RoundThe amount the Selling Price must be rounded by.
Fixed SellThe 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 SellThe 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 one item).
MU%The percentage Markup that the current Selling Price achieves (the percentage added to the Cost Price to determine the Selling Price).
GM%The Gross Margin percentage the current Selling Price achieves (percentage of the Selling Price that is Profit).
Price List NameThe 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/SWhether the Cost and Selling Prices are automatically or manually updated. (For example, if the Cost Price is manual and the Selling Price is automatic the field displays Man/Auto)
Actual PriceThe Actual Price matches the specific Price List price if there is one, else it matches the Unit Price.
Updated byThe User who last updated the item.
UpdatedThe 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.
Category (Customer)The category of the customer linked to the item.
Status (Item)The item's status.

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.