Costings List View

Overview

Costings can be added to Items or created from Quotations. The Items module supports two types of Costings models: Item Costings (COS) and Estimate Costings (EST). Both models can be used as a single-level Costing.

When you create a costing they are available to view separately under the Costings menu option (if setup).

Navigation Example

Main Menu > Items > Costings

Settings

General Settings

Info

These settings affect Costings, Estimates and Prices.

Navigation Example

Main Menu > Setup > Settings > General (tab)

Note

The defaults are the values for new databases, new users and new Transaction Types. Your database may have different values.

Setting Description Default
Items & Inventory > Item Costings – Enable automatic updatesCheckbox, if checked, automatic updates are enabled.Checked
Items & Inventory > Item Costings – Transaction TypeThe Value column provides a dropdown list of all the Transactions for you to select the Transaction Type that is used for Costings. This setting is required for the Estimate (EST) model.Not set
Items & Inventory > Item Costings – UpdateOption to update the:
  • Unit Cost
  • Fixed & Unit Cost (Requires multiple quantities on Costings)
Unit Cost

Transaction Settings

Navigation Example

Main Menu > Setup > Settings > Transactions (tab)

Info

The following settings can be added to specific Transaction Types (e.g. Costings, Quotations).

Field Description
Estimating > Default: Markup on Estimate (%)A number can be entered in the Value column.
Inventory > Default: Inventory Location TransactionsA dropdown list of all locations for you to select one.
Transactions > Add Items to TransactionsCheckbox, if checked, Items are added to Transactions.
Transactions > Create new TransactionsCheckbox, if checked, new Transactions may be created directly in the module.
Transactions > Convert new Items to Estimates when Pricing = Sell PriceCheckbox. If checked, new Items are converted to Estimates when Pricing equals the Sell Price.

Transaction Access Settings

Navigation Example

Main Menu > Setup > Settings > Users (tab)

Field Description
Estimate Form Only
  • The Est (Form only) column determines which information you can see on estimates.
  • The column is only relevant to Transaction Types that include estimates (e.g. Quotations, Sales Orders, Work Orders).
  • The setting in this column does not affect users who have Admin View rights.
  • The column can be checked / unchecked for all the Transaction Types using Batch Updates (Actions > Batch Update).
  • If checked, you have access to the following estimate information:
    • Input (tab)
    • Costs (tab)
    • Description (tab)
    • Specification (tab)
    • Updates (tab)
    • Summary:
      • Line Items: Quantity, Total, Cost per unit.
      • Summary information including a breakdown of costs.
  • If unchecked, you have access to the following estimate information:
    • Description
    • Specification
    • Summary line items only: Quantity, Total, Cost per unit.
User AccessCan be set for all the Transaction Types. The options are:
  • View:
    • None: You have no access and cannot receive access for any of the other options.
    • All: You can view all transactions.
    • Own (Rep): You can view transactions if you were selected as the rep on the transaction.
    • Admin: You can view all the transactions and change the statuses.
  • New: If checked, you can create transactions. Having access to copy transactions overrides this setting.
  • Edit: If checked, you can edit transactions.
  • Delete: If checked, you can delete transactions.
  • Est (Form only): Applies to estimates. Only view the form, and not the profit margins. See detailed explanation above.
  • Status (Up only): Only move a transaction forward (e.g. change the status from Pending to Active, but not from Active to Pending). Users with Admin rights can change the status regardless of this setting.

User Settings

Navigation Example

Main Menu > Setup > Settings > Users (tab)

Setting Description Default
Items & Inventory > Set Costing Status – Access AllowedCheckbox, if checked, access is allowed.Unchecked
Setups > Estimate Types – Access AllowedCheckbox, if checked, access is allowed.Unchecked

Transaction Type Settings

Info

These settings apply to all the Transaction Types for which Estimating is used (e.g. Costings, Work Orders and Quotations).

Navigation Example

Main Menu > Setup > Transactions > Right-click a Transaction > Navigate to the Estimating heading

Field Description
Visible TabsFor Estimating to be accessed from the Transaction Type, one or more of these tabs must be visible:
  • Input
  • Costs
  • Description
  • Specification
  • Pricing
  • Update
Estimate TypesClicking the three dots (...) in the Value column opens a list of Estimate Types for you to link to the Transaction by moving the Estimate Types from the Available to the Linked panels.
PricingSelect whether the Cost Price or Costing Price are used.
ResolveSelect whether any action must take place regarding the inventory. The options are:
  • None
  • Receive
  • Issue
  • Order
  • Reserve
  • Purchase

Transaction Type: Costing

Navigation Example

Main Menu > Setup > Transactions

A specific Transaction Type must be created for Costings. The fields that must be filled in are:

Section Required Fields
General
  • Description: Costing.
  • Code: COST.
Items & Inventory
  • Item Type: Items.
  • Pricing: Costing Price.
  • Resolve: None selected.
Estimating
  • Visible Tabs: Input; Costs; Pricing; Update.
  • Estimate Types: Estimate Types are unique to an organisation. Select your Estimate Types in this field.
  • Pricing: Cost Price.
  • Resolve: None Selected.
AccountingUnchecked.

Statuses Explained

Info

Changing the costing status requires the user setting Items & Inventory > Set Costing Status – Access Allowed.

Status Description
DraftNew costings start as Draft. Items can be added to and removed from the costing.
ReviewThe costing can still be edited.
ReadyThe costing is read-only: components and options cannot be added or updated.

List View: Transactions

Info

The Costing List View: Transactions lists the costing transactions that were created through Items or Quotations.

Buttons Explained

Button Description
ViewGenerates a list of Costings based on the selected filters. Clicking the button arrow opens a menu of Actions to create filters and set the default view:
  • Add: Adds an additional function to the selected filter.
  • Update: Updates the selected filter with the current selected filters.
  • Delete: Deletes the filter.
  • Set Default: Sets the default view.

Lists the created filters for you to select one (e.g. Pending, Active).

OutputUnavailable unless specific templates are created for the view.
ActionsAllows changes to all the selected records:
  • Batch Update: Updates are applied to all the selected records when the Update button is clicked. Batch Update options are:
    • Status: Updates the Status with the new status selected from the dropdown list of available statuses.
    • Reference: Updates the Reference with the reference entered in the adjacent block.
    • Category: Updates the transaction Category with the one selected from the dropdown list of available categories.
    • Entity: Replaces the transaction's Entity with the one selected from the dropdown list of available entities.
  • Copy to Costing: Creates a new Costing from the selected Costing.
  • Copy to Quotations: Opens an interface for you to select which items can be copied, and includes options to change the Header or Item Statuses. Creates a new Quotation from the costing based on the selections made.
Menu
  • Reset Data Filter: Resets the selected data filters.
  • Views
    • Transactions: Switches the view to Transaction View.
    • Items: Switches the view to Items View.
    • Summary: Switches the view to Summary View.
    • Board: Switches the view to Board View.
    • Set Default View: Sets the Default View for Costings.
  • Export
    • Email Excel: Email the list view by opening the default Email Template with the view attached in .xlsx format.
    • Export Grid: Choose a save location to save the grid view in .xlsx format on the server.
  • Layout & Grids

Filters Explained

Filter Description
SetSelect a Date filter from the dropdown list (e.g. Fin Year, Today).
ArrowsAdjusts the date based on the selection under Set.
Date fieldsRefine the dates.
UserSpecify all Users or select a specific User from the dropdown list of users.
RepSpecify all Reps or select a specific Rep from the dropdown list of reps.
CategorySpecify all Categories or select a specific Category from the dropdown list of categories.
StatusCheckboxes are available for the following statuses:
  • Pending
  • Complete
  • Active
  • Cancelled

Checkmark = The Status is included in the report.

OutstandingSelect whether to view Outstanding Costings (COST) or Quotations (QT).

Fields Explained

Field Description
Field Chooser (*)Add or hide columns.
IDThe system-generated number for the entry on the list.
Trans No.The system-generated number for the record.
StatusThe Status of the transaction.
FromThe source document that was used to create the transaction.
UserThe user who created the transaction.
DateThe date on which the transaction was created.
Acc No.The Customer or Supplier's Account Number.
RegionThe Customer or Supplier's Region.
EntityThe Entity linked to the transaction.
Order NoThe Order Number, if applicable.
CategoryThe Transaction Category.
ReferenceThe Transaction's Reference.
CurrencyThe Transaction's Currency.
Total CURThe total transaction amount in the Transaction's Currency.
TermsThe Customer or Supplier's Terms.
Out ZARThe total outstanding value of the transaction in the Local Currency (where ZAR = Default Local Currency).
Linked No./s
  • See the Transaction Setting > Show linked Trans No./s from (Select the Transaction) (default = blank): When a Transaction is selected, the linked Transaction Numbers (max 10) appear in the Transaction View.
  • For example, you could use this setting to display linked Work Order numbers in a Transaction View where applicable.
Out CURThe total outstanding value of the transaction in Foreign Currency.
NoteNotes entered in the header of the transaction.
Total (exc)The total amount of the transaction Excluding VAT.
VATThe VAT Amount of the transaction (often zero when it is an internal stock transfer).
Total (inc)The total amount of the transaction Including VAT.
Due DateThe date the transaction was/is due.
Due TimeThe time the transaction was/is due.
Status NoteAny note entered on the Status Bar of the transaction.
Updated byThe user who last updated the transaction.
UpdatedThe date on which the transaction was last updated.
Req DateThe date by which the customer or supplier required the goods. The date is highlighted in red when the date has passed.
Req TimeThe time by which the goods were required.
NotesNotes created and linked to a transaction.
Paperclip (Attachments)Indicated whether the transaction has any linked Attachments.
Total CUR (inc)The total value of the Costing in Foreign Currency.
Deposit %The Deposit Percentage due.
DepositThe Deposit Amount due.
SM No.The number of the Service Manager Ticket, where applicable.
Open (d)Indicates how many days the transaction has been open.
Last (d)Indicates the number of days since the last update was made to the transaction.
Menu (...)A submenu that can also be accessed by right-clicking the line.
  • Open Transaction: Opens the transactions.
  • Open Notes & Attachments: Opens any Notes and Attachments and lets you create Notes and Attachments.
  • Summaries
    • Linked Transactions: Displays a list of any linked transactions on the right.
    • Outstanding: Displays a list of items that are still outstanding on the right.
    • Audits: Provides a detailed audit trail of changes made to the transaction.
    • Emails: Switches to the email interface to show any emails related to the transaction.
  • Copy to Costing: Creates a new Costing from the selected Costing.
  • Copy to Quotations: Opens an interface for you to select which items can be copied, and includes options to change the Header or Item Statuses. Creates a new Quotation from the costing based on the selections made.

List View: Items

Info

The Costing List View: Items lists the items that are on the costing transactions that were created through Items or Quotations.

Buttons Explained

Button Description
ViewGenerates a list of Costings based on the selected filters. Clicking the button arrow opens a menu of Actions to create filters and set the default view:
  • Add: Adds an additional function to the selected filter.
  • Update: Updates the selected filter with the current selected filters.
  • Delete: Deletes the filter.
  • Set Default: Sets the default view.

Lists the created filters for you to select one (e.g. Pending, Active).

OutputUnavailable unless specific templates are created for the view. Contact QuickEasy Software for assistance.
ActionsAllows changes to all the selected records:
  • Batch Update: Updates are applied to all the selected records when the Update button is clicked. Batch Update options are:
    • Assign to: Updates the Assign To field to the user selected from the dropdown list.
    • Credit: Updates the general ledger Account to Credit the one selected from the dropdown list of accounts.
    • Debit: Updates the general ledger Account to Debit the one selected from the dropdown list of accounts.
    • Department: Updates the Department to the one selected from the dropdown list of departments.
    • Qty: Updates the Transaction to the quantity entered in the block.
    • Status: Updates the Item Status with the new status selected from the dropdown list of available statuses.
    • Unit Cost: Updates the Unit Cost with the cost entered in the block.
    • Unit Price and /Qty: Updates the Unit Price with the price entered in the first block and replaces the quantity included in that unit price with the amount entered in the second block.
    • VAT: Updates the Default VAT Type to the type selected in the first block and changes the price to be Exclusive (Exc) or Inclusive (Inc) as selected in the second block.
    • Start Date: Updates the Start Date and Time of the transaction to the new date selected in the first block and time selected in the second block.
    • Due Date: Updates the Due Date and Time of the transaction to the new date selected in the first block and time selected in the second block.
    • Lead Days: Updates the Lead Days to the number of days entered in the adjacent block.
SaveSaves any changes.
Menu
  • Reset Data Filter: Resets the selected data filters.
  • Views
    • Transactions: Switches the view to Transaction View.
    • Items: Switches the view to Items View.
    • Summary: Switches the view to Summary View.
    • Board: Switches the view to Board View.
    • Set Default View: Sets the Default View for Costings.
  • Export
    • Email Excel: Email the list view by opening the default Email Template with the view attached in .xlsx format.
    • Export Grid: Choose a save location to save the grid view in .xlsx format on the server.
  • Layout & Grids

Filters Explained

Filter Description
SetSelect a Date filter from the dropdown list (e.g. Fin Year, Today).
ArrowsAdjusts the date based on the selection under Set.
Date fieldsRefine the dates.
UserSpecify all Users or select a specific User from the dropdown list of users.
RepSpecify all Reps or select a specific Rep from the dropdown list of reps.
CategorySpecify all Categories or select a specific Category from the dropdown list of categories.
StatusCheckboxes are available for the following statuses:
  • Pending
  • Complete
  • Active
  • Cancelled

Checkmark = The Status is included in the report.

OutstandingSelect whether to view Outstanding Costings (COST) or Quotations (QT).

Fields Explained

Info

Fields marked in blue (✎) can be edited.

Field Description
Field Chooser (*)Add or hide columns.
IDThe system-generated number for the entry on the list.
Trans No.The system-generated number for the record.
Trans StatusThe Status of the transaction.
Trans DateThe date on which the transaction was created.
Trans CategoryThe Transaction's Category.
CurrencyThe Transaction's Currency.
ReferenceThe Transaction's Reference.
Trans Due DateThe Due Date selected for the transaction.
UserThe user who created the transaction.
EntityThe Entity link to the transaction.
Assign TransThe user the Transaction is assigned to.
TermsThe customer's Terms.
RegionThe customer's Region.
ItemA sequential number for each item on the transaction.
GM%Automatically calculated. Shows the Gross Margin Percentage.
ResolveThe action that was taken (e.g. issue, purchase).
Item StatusThe Item Status of the individual item in the transaction.
TypeAn abbreviation indicating the Type of item (e.g. EST for Estimate).
DescriptionThe Item's Description.
Item CategoryThe Item's Category.
Item SubcategoryThe Item's Subcategory.
LocationThe item's Location if it is an inventory item.
ExpiresThe Expiry Date of the goods (where applicable).
SupplierThe name of the supplier involved in the transaction.
Cost CentreThe Cost Centre selected for the transaction.
CategoryThe Transaction Category.
GroupThe user-defined Group for the item.
Item ReferenceThe Item's Reference.
Costing StatusThe Status of the Costing that the item is linked to.
Item TypeThe Type of Item involved in the transaction (e.g. Assembly, Material).
SubgroupThe item's Subgroup.
FromThe source document that was used to create the item.
DepartmentThe Department selected for the transaction.
@ (Due Time Item)The time by when the goods should be produced.
@ (Start Time)The Start Time for the goods to be produced.
Lead DaysThe number of lead days needed before production can start.
QtyThe quantity of the item.
Out AmtThe Outstanding number of Items in Local Currency.
UnitA description of the Unit.
VAT TypeThe default VAT Type for the entry (mostly No VAT).
VAT%The percentage VAT that applies to the item's entry on the transaction.
Total (exc)The VAT Exclusive total of the Transaction.
VATThe VAT component of the Transaction. 
Total (inc)The VAT Inclusive total of the Transaction.
Unit CostThe Unit Cost of the item.
Unit PriceThe Unit Price of the item.
/QtyThe quantity of the item that is included in the Unit Price.
SubtotalThe subtotal of the Transaction.
Adj %The percentage by which the item's price was Adjusted.
AdjustmentThe amount by which the item's price was Adjusted.
/UnitThe Price for 1 Unit.
ProfitThe Profit made on the Transaction.
CodeThe item's Code.
Check inThe item's date and Time to Check In.
Check outThe item's date and Time to Check Out.
Assign ItemThe user the item is assigned to.
Start DateThe Start Date for the item to be produced.
Due Date ItemThe date by which the item should be produced.
VerThe Version Number of the transaction.
Order No.The customer or supplier's Order Number.
TEXT1A custom field as per the Transaction Type setting (where applicable).
TEXT2A custom field as per the Transaction Type setting (where applicable).
TEXT3A custom field as per the Transaction Type setting (where applicable).
ProgressThe percentage progress of the Transaction.
Out QtyThe Outstanding Quantity.
Out Amt CURThe Outstanding amount in Foreign Currency.
Serial No.The Serial Number of the item if the item is tracked by serial number.
DebitThe Ledger Account that is Debited.
CreditThe Ledger Account that is Credited.
VATWhere the value includes or excludes VAT.
Menu (...)A submenu that can also be accessed by right-clicking the line.
  • View/Edit Note: Opens any notes and lets you create notes for the items (separate from the Open Notes & Attachments function).
  • Open Transaction: Opens the transactions.
  • Open Notes & Attachments: Opens any Notes and Attachments and lets you create Notes and Attachments.
  • Summaries
    • Item Summary: Displays a summary of the item's information and transactions on the right.
    • Linked Transactions: Displays a list of any linked transactions on the right.
    • Outstanding: Displays a list of items that are still outstanding on the right.
    • Audits: Provides a detailed audit trail of changes made to the transaction.
    • Emails: Changes to the email interface to show any emails related to the transaction.
  • Copy to Costing: Creates a new Costing from the selected Costing.
  • Copy to Quotations: Opens an interface for you to select which items can be copied and includes options to change the Header or Item Statuses. Creates a new Quotation from the costing based on the selections made.

Summary View

Info

This view can be customised.

Buttons Explained

Button Description
Output
  • Email Excel: Email the summary view by opening the default Email Template with the view attached in .xlsx format.
  • Export Grid: Choose a save location to save the grid view in .xlsx format on the server.
  • Print Chart: Opens an interface allowing you to customise the layout of the chart and print it to a PDF file or printer.
Menu
  • Views
    • Transactions: Switches the view to Transaction View.
    • Items: Switches the view to Items View.
    • Summary: Switches the view to Summary View.
    • Board: Switches the view to Board View.
    • Set Default View: Sets the Default View.
  • Date Grouping: Option to display the summary by:
    • Date: Displays a total and column on the chart for every Day that has a transaction.
    • Day of the Week: Displays a total and column on the chart for every Day of the Week (including weekends).
    • Week of the Month: Displays a total and column on the chart for every Week of the Month (e.g. week 1 of March is added to week 1 of April and week 1 of May).
    • Week of the Year: Displays a total and column on the chart for every Week of the selected Year (data is for 52 weeks).
    • Monthly: Displays a total and column on the chart for every calendar Month.
    • Quarterly: Displays a total and column for every Quarter of the selected Year.
    • Yearly: Shows a total and column for every calendar Year that has data.
  • Save Grid
  • Restore Grid

Filters Explained

Info

On the left is a list of headings. You can click the small filter icon on each heading to select specific items. The options are limited to the report (that is, only items involved in transactions will appear on the dropdown list).

There are headings and filters for:

Filter Description
Cus/Sup CatSelect specific customer or Supplier Categories.
Cus/SupSelect specific customers or suppliers.
Custom 1Select a specific Custom entry as per the Transaction Type setup.
Custom 2Select a specific Custom entry as per the Transaction Type setup.
Custom 3Select a specific Custom entry as per the Transaction Type setup.
Due DateSelect a specific Due Date.
Item CatSelect specific Item Categories.
Item CodeSelect specific Item Codes (the item list sorted by code).
Item DescSelect specific Item Descriptions (the item list sorted by description).
Item SubcatSelect specific Item Subcategories.
LocationSelect specific Locations.
Out AmtSelect specific Outstanding Amounts.
QtySelect specific Transaction Quantities.
RepSelect specific Reps.
StatusSelect specific Statuses.
TotalSelect specific Totals. (Normally a column heading.)
Trans CatSelect specific Transaction Categories.
Trans DateSelect specific Transaction Dates based on the summary (e.g. if a report is drawn for weeks, the transaction dates are 1-52 representing the weeks). (Normally a column heading.)
Trans FromSelect specific source transactions from a list of Costing Transactions.
Trans No.Select a specific Transaction Number.
Unit PriceSelect a specific Unit Price.

Fields Explained

Field Description
TotalsThe totals appear as per the summary option chosen from Menu > Date Grouping.
ScrollbarA scrollbar at the bottom gives access to the rest of the data.

Chart Explained

Element Description
ColumnsThe chart displays a column for every period selected as per the summary options (Menu > Date Grouping).
LegendA legend appears on the right.
Customize ChartThe chart can be customised by clicking Customize Chart (button).
Column DiagramThe chart can be changed by clicking Column Diagram and selecting a different chart. Not all chart choices result in a meaningful display.

Board View

Info

The Board shows a summary of all the Costings.

  • There is no View button, the report is automatically generated.

Buttons Explained

Button Description
Menu
  • Views
    • Transactions: Switches the view to Transaction View.
    • Items: Switches the view to Items View.
    • Summary: Switches the view to Summary View.
    • Board: Switches the view to Board View.
    • Set Default View: Sets the Default View.
  • Board
    • Status: Sorts the available records according to their Statuses.
    • Due Date: Sorts the available records according to their Due Dates.
    • Condensed View: Toggles showing only the headings. Checkmark (Enabled) = Only headings appear.

Filters Explained

Filter Description
All DueSelect All Due or a specific period: Today, Tomorrow, This Week, This Month.
250Adjust the column width by using the arrow keys or overtyping the number.
ColumnsSelect to display All, All (Not Empty) or Pending columns.

Fields Explained

Info

A summary appears with the following information:

Field Description
Line 1Transaction Number / Transaction Reference.
Line 2Due Date / Customer or Supplier (line 2 is suppressed in condensed view).

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.