- Home
- Knowledge Base
- Items
- Item Prices Explained
Item Prices Explained
- QuickEasy BOS assists businesses in maintaining their profit margins by providing uncomplicated Costing and Estimating processes.
- The software uses Items: a term that includes Inventory, Materials, Tasks, Costings, and Assemblies.
- There are also specialised items for the printing industry.
- Pricing information is obtained from Cost Centres or Items.
- Items are used in Transactions and Estimates.
Different Item Prices Explained
Unit prices can use up to 4 decimal places.
Price Types
- Supplier:
- Used in Materials and Outwork.
- The price is on the Supplier’s Invoice and must be captured in QuickEasy BOS, either directly or through a Transaction (e.g. Supplier Invoice).
- Cost:
- Used in Estimating and Transactions that use Cost Prices (e.g. Work Orders).
- Can be entered manually.
- Can be automatically calculated based on a Supplier Price, or Costing.
- Can be used in ledger transactions (i.e. transactions that have Accounting price set as the default).
- Sell:
- Used in Transactions that use Sell Price (e.g. Customer Invoices).
- Can be entered manually.
- Can be automatically calculated by applying a markup to a Cost Price.
Fixed and Unit Prices
- Costings, Tasks, and Outwork provide for Fixed and Unit Prices.
- The Fixed Price is always added regardless of the Quantity (e.g. a fixed delivery fee).
- The Unit Price is always multiplied by the Quantity.
- Fixed Prices are disabled for Materials on the item’s Prices tab. But can still be used in transactions.
How Prices Are Calculated
How the Cost Price is calculated from the Highest Supplier Price
- The Supplier Price is converted to the Local Currency.
- The Adjustment (Adj%) is subtracted from the Supplier Price to determine the cost price.
- The Unit Price is converted to the Base Unit.
- All the Base Unit prices are compared and the highest price is selected.
- The highest price, as determined by Step 4, is converted to match the Cost Price’s Unit.
- The Adjustment (Adj%) entered for the Cost Price is added to the price.
- Note: Only positive adjustments are allowed for the Cost Price. If a negative number is entered, it is changed to zero.
How the Cost Price is calculated from a Costing
- If the unit used in the costing differs from the Base Unit, the price is converted to obtain a price for the Base Unit.
- All the Base Unit prices are compared and the highest unit price is selected.
- The Highest Unit Price is converted to the Cost Price’s Unit.
- The Adjustment (Adj%) entered for the Cost Price is added to the price.
- Note: Only positive adjustments are allowed for the Cost Price. If a negative number is entered, it is changed to zero.
How the Sell Price is calculated from the Cost Price
- The Cost Price is converted to match the Sell Price Unit.
- The converted price obtained in Step 1 is converted again to match the Sell Price Currency.
- The Adjustment (Adj%) entered for the Sell Price is added to the price.
How the Accounting Price is calculated from the Cost Price
- The Accounting Price model uses the Fixed Price column which is renamed to Amount.
- When an Item is added, the Fixed Cost on the Item is added to the Amount.
- If the Fixed Cost on the Item is empty, the Unit Cost is added to the Amount.
Pricing and Transaction Items
- When creating a Transaction Type, you must select the price that is applicable to that transaction (e.g. Cost, Sell, Accounting). Items can only be added to a transaction if they have the matching price setup on their Prices tabs.
- When creating transactions in foreign currencies:
- For Supplier and Sell Prices, items can only be added to transactions if they have the matching price in the foreign currency (as chosen on Step 1) setup on their Prices (tab).
- Cost Prices can only be in the Local Currency and are converted if the transaction is not in the local currency.
- The conversion rate is shown in the footer of the transaction.
- The following Items can be added to a Transaction:
- Custom Items (0: CTM): These items are created at the time of the transaction and only apply to the particular transaction. Prices must be manually entered on the transaction. Rules 1 and 2 do not apply.
- Items from the Item Master (1: ITM): These are the pre-created Items. Pricing information is obtained from the item’s Pricing (tab). Rules 1 and 2 apply.
- Estimate – Active Qty (2: EST): The price for a line item on a transaction that has estimating enabled is obtained from the price for the Active Quantity on the Estimate.
- Estimate – Other Qty (3: ES Qty): QuickEasy BOS provides for Inactive Quantities and prices to be displayed on a transaction to give customers insight into how their Quantity decision affects their prices. The default templates for Quotations (Quote Letter) include these inactive quantities. They are also visible on the Estimate itself.
- The Item Totals are updated when one or more of the following fields are updated and Save (button) is clicked:
- Qty
- Unit Cost / Fixed Cost
- MU%
- Unit Sell / Fixed Sell
- Adj %
- VAT Type
- Inc (VAT Inclusive):
- If a price is VAT Exclusive, VAT is added to the price to obtain the inclusive price (e.g. Exclusive Price + VAT = Inclusive Price).
- If a price is VAT Inclusive, VAT is deducted from the price to obtain the exclusive price (e.g. Inclusive Price – VAT = Exclusive Price).
- On transactions (hidden by default) and on the Prices tab of Estimates, a Fix checkbox allows you to fix the Sell Price:
- Unchecked:
- Calculates the Sell Price by adding the markup to the Cost Price.
- Only the markup percentage (MU%) can be edited, not the prices.
- This is the default for Estimates.
- Checked:
- Calculates the Mark Up % by calculating the percentage difference between the Cost and Sell Prices.
- Only the prices can be edited, not the markup percentage.
- This is the default for Non-estimate and Custom Items.
- Unchecked:
Learn More
- Item Extension Types: Explains the types of items that are available.
- Item Creation and Editing Interface: Explains the interface from which items are created.
- Item Creation and Editing Tutorials: These tutorials explain how to create items.
- Item List Views Interface: Explains the various interfaces from which a list of items can be viewed.
- Item List Views Tutorials: These tutorials explain the various reports (List Views) and functions available when viewing item lists.
- Item Categories: Explains what categories are, the interface, and how to use them.
- Item Attributes: Explains the item attributes that are available, their purpose, and how to use them.
- Item Summary: Explains the item summary sections and how to use the functions available from the summary.
- Item: Print Costing Example: An example of an item that has a costing for a print project.
- Inventory Terms and Information: Explains the inventory terms and settings used.
- Inventory and Transaction Types: Explains how inventory integrates with transactions and how the Resolve function is used.
- Inventory Recording Methods: Explains inventory recording methods like the perpetual and periodic methods.
