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).
Settings
General Settings
These settings affect Costings, Estimates and Prices.
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 updates | Checkbox, if checked, automatic updates are enabled. | Checked |
| Items & Inventory > Item Costings – Transaction Type | The 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 – Update | Option to update the:
| Unit Cost |
Transaction Settings
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 Transactions | A dropdown list of all locations for you to select one. |
| Transactions > Add Items to Transactions | Checkbox, if checked, Items are added to Transactions. |
| Transactions > Create new Transactions | Checkbox, if checked, new Transactions may be created directly in the module. |
| Transactions > Convert new Items to Estimates when Pricing = Sell Price | Checkbox. If checked, new Items are converted to Estimates when Pricing equals the Sell Price. |
Transaction Access Settings
| Field | Description |
|---|---|
| Estimate Form Only |
|
| User Access | Can be set for all the Transaction Types. The options are:
|
User Settings
| Setting | Description | Default |
|---|---|---|
| Items & Inventory > Set Costing Status – Access Allowed | Checkbox, if checked, access is allowed. | Unchecked |
| Setups > Estimate Types – Access Allowed | Checkbox, if checked, access is allowed. | Unchecked |
Transaction Type Settings
These settings apply to all the Transaction Types for which Estimating is used (e.g. Costings, Work Orders and Quotations).
| Field | Description |
|---|---|
| Visible Tabs | For Estimating to be accessed from the Transaction Type, one or more of these tabs must be visible:
|
| Estimate Types | Clicking 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. |
| Pricing | Select whether the Cost Price or Costing Price are used. |
| Resolve | Select whether any action must take place regarding the inventory. The options are:
|
Transaction Type: Costing
A specific Transaction Type must be created for Costings. The fields that must be filled in are:
| Section | Required Fields |
|---|---|
| General |
|
| Items & Inventory |
|
| Estimating |
|
| Accounting | Unchecked. |
Statuses Explained
Changing the costing status requires the user setting Items & Inventory > Set Costing Status – Access Allowed.
| Status | Description |
|---|---|
| Draft | New costings start as Draft. Items can be added to and removed from the costing. |
| Review | The costing can still be edited. |
| Ready | The costing is read-only: components and options cannot be added or updated. |
List View: Transactions
The Costing List View: Transactions lists the costing transactions that were created through Items or Quotations.
Buttons Explained
| Button | Description |
|---|---|
| View | Generates 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:
Lists the created filters for you to select one (e.g. Pending, Active). |
| Output | Unavailable unless specific templates are created for the view. |
| Actions | Allows changes to all the selected records:
|
| Menu |
|
Filters Explained
| Filter | Description |
|---|---|
| Set | Select a Date filter from the dropdown list (e.g. Fin Year, Today). |
| Arrows | Adjusts the date based on the selection under Set. |
| Date fields | Refine the dates. |
| User | Specify all Users or select a specific User from the dropdown list of users. |
| Rep | Specify all Reps or select a specific Rep from the dropdown list of reps. |
| Category | Specify all Categories or select a specific Category from the dropdown list of categories. |
| Status | Checkboxes are available for the following statuses:
Checkmark = The Status is included in the report. |
| Outstanding | Select whether to view Outstanding Costings (COST) or Quotations (QT). |
Fields Explained
| Field | Description |
|---|---|
| Field Chooser (*) | Add or hide columns. |
| ID | The system-generated number for the entry on the list. |
| Trans No. | The system-generated number for the record. |
| Status | The Status of the transaction. |
| From | The source document that was used to create the transaction. |
| User | The user who created the transaction. |
| Date | The date on which the transaction was created. |
| Acc No. | The Customer or Supplier's Account Number. |
| Region | The Customer or Supplier's Region. |
| Entity | The Entity linked to the transaction. |
| Order No | The Order Number, if applicable. |
| Category | The Transaction Category. |
| Reference | The Transaction's Reference. |
| Currency | The Transaction's Currency. |
| Total CUR | The total transaction amount in the Transaction's Currency. |
| Terms | The Customer or Supplier's Terms. |
| Out ZAR | The total outstanding value of the transaction in the Local Currency (where ZAR = Default Local Currency). |
| Linked No./s |
|
| Out CUR | The total outstanding value of the transaction in Foreign Currency. |
| Note | Notes entered in the header of the transaction. |
| Total (exc) | The total amount of the transaction Excluding VAT. |
| VAT | The 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 Date | The date the transaction was/is due. |
| Due Time | The time the transaction was/is due. |
| Status Note | Any note entered on the Status Bar of the transaction. |
| Updated by | The user who last updated the transaction. |
| Updated | The date on which the transaction was last updated. |
| Req Date | The date by which the customer or supplier required the goods. The date is highlighted in red when the date has passed. |
| Req Time | The time by which the goods were required. |
| Notes | Notes 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. |
| Deposit | The 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.
|
List View: Items
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 |
|---|---|
| View | Generates 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:
Lists the created filters for you to select one (e.g. Pending, Active). |
| Output | Unavailable unless specific templates are created for the view. Contact QuickEasy Software for assistance. |
| Actions | Allows changes to all the selected records:
|
| Save | Saves any changes. |
| Menu |
|
Filters Explained
| Filter | Description |
|---|---|
| Set | Select a Date filter from the dropdown list (e.g. Fin Year, Today). |
| Arrows | Adjusts the date based on the selection under Set. |
| Date fields | Refine the dates. |
| User | Specify all Users or select a specific User from the dropdown list of users. |
| Rep | Specify all Reps or select a specific Rep from the dropdown list of reps. |
| Category | Specify all Categories or select a specific Category from the dropdown list of categories. |
| Status | Checkboxes are available for the following statuses:
Checkmark = The Status is included in the report. |
| Outstanding | Select whether to view Outstanding Costings (COST) or Quotations (QT). |
Fields Explained
Fields marked in blue (✎) can be edited.
| Field | Description |
|---|---|
| Field Chooser (*) | Add or hide columns. |
| ID | The system-generated number for the entry on the list. |
| Trans No. | The system-generated number for the record. |
| Trans Status | The Status of the transaction. |
| Trans Date | The date on which the transaction was created. |
| Trans Category | The Transaction's Category. |
| Currency | The Transaction's Currency. |
| Reference | The Transaction's Reference. |
| Trans Due Date | The Due Date selected for the transaction. |
| User | The user who created the transaction. |
| Entity | The Entity link to the transaction. |
| Assign Trans | The user the Transaction is assigned to. |
| Terms | The customer's Terms. |
| Region | The customer's Region. |
| Item | A sequential number for each item on the transaction. |
| GM% | Automatically calculated. Shows the Gross Margin Percentage. |
| Resolve | The action that was taken (e.g. issue, purchase). |
| Item Status | The Item Status of the individual item in the transaction. |
| Type | An abbreviation indicating the Type of item (e.g. EST for Estimate). |
| Description | The Item's Description. |
| Item Category | The Item's Category. |
| Item Subcategory | The Item's Subcategory. |
| Location | The item's Location if it is an inventory item. |
| Expires | The Expiry Date of the goods (where applicable). |
| Supplier | The name of the supplier involved in the transaction. |
| Cost Centre | The Cost Centre selected for the transaction. |
| Category | The Transaction Category. |
| Group | The user-defined Group for the item. |
| Item Reference | The Item's Reference. |
| Costing Status | The Status of the Costing that the item is linked to. |
| Item Type | The Type of Item involved in the transaction (e.g. Assembly, Material). |
| Subgroup | The item's Subgroup. |
| From | The source document that was used to create the item. |
| Department | The 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 Days | The number of lead days needed before production can start. |
| Qty | The quantity of the item. |
| Out Amt | The Outstanding number of Items in Local Currency. |
| Unit | A description of the Unit. |
| VAT Type | The 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. |
| VAT | The VAT component of the Transaction. |
| Total (inc) | The VAT Inclusive total of the Transaction. |
| Unit Cost | The Unit Cost of the item. |
| Unit Price | The Unit Price of the item. |
| /Qty | The quantity of the item that is included in the Unit Price. |
| Subtotal | The subtotal of the Transaction. |
| Adj % | The percentage by which the item's price was Adjusted. |
| Adjustment | The amount by which the item's price was Adjusted. |
| /Unit | The Price for 1 Unit. |
| Profit | The Profit made on the Transaction. |
| Code | The item's Code. |
| Check in | The item's date and Time to Check In. |
| Check out | The item's date and Time to Check Out. |
| Assign Item | The user the item is assigned to. |
| Start Date | The Start Date for the item to be produced. |
| Due Date Item | The date by which the item should be produced. |
| Ver | The Version Number of the transaction. |
| Order No. | The customer or supplier's Order Number. |
| TEXT1 | A custom field as per the Transaction Type setting (where applicable). |
| TEXT2 | A custom field as per the Transaction Type setting (where applicable). |
| TEXT3 | A custom field as per the Transaction Type setting (where applicable). |
| Progress | The percentage progress of the Transaction. |
| Out Qty | The Outstanding Quantity. |
| Out Amt CUR | The Outstanding amount in Foreign Currency. |
| Serial No. | The Serial Number of the item if the item is tracked by serial number. |
| Debit | The Ledger Account that is Debited. |
| Credit | The Ledger Account that is Credited. |
| VAT | Where the value includes or excludes VAT. |
| Menu (...) | A submenu that can also be accessed by right-clicking the line.
|
Summary View
This view can be customised.
Buttons Explained
| Button | Description |
|---|---|
| Output |
|
| Menu |
|
Filters Explained
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 Cat | Select specific customer or Supplier Categories. |
| Cus/Sup | Select specific customers or suppliers. |
| Custom 1 | Select a specific Custom entry as per the Transaction Type setup. |
| Custom 2 | Select a specific Custom entry as per the Transaction Type setup. |
| Custom 3 | Select a specific Custom entry as per the Transaction Type setup. |
| Due Date | Select a specific Due Date. |
| Item Cat | Select specific Item Categories. |
| Item Code | Select specific Item Codes (the item list sorted by code). |
| Item Desc | Select specific Item Descriptions (the item list sorted by description). |
| Item Subcat | Select specific Item Subcategories. |
| Location | Select specific Locations. |
| Out Amt | Select specific Outstanding Amounts. |
| Qty | Select specific Transaction Quantities. |
| Rep | Select specific Reps. |
| Status | Select specific Statuses. |
| Total | Select specific Totals. (Normally a column heading.) |
| Trans Cat | Select specific Transaction Categories. |
| Trans Date | Select 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 From | Select specific source transactions from a list of Costing Transactions. |
| Trans No. | Select a specific Transaction Number. |
| Unit Price | Select a specific Unit Price. |
Fields Explained
| Field | Description |
|---|---|
| Totals | The totals appear as per the summary option chosen from Menu > Date Grouping. |
| Scrollbar | A scrollbar at the bottom gives access to the rest of the data. |
Chart Explained
| Element | Description |
|---|---|
| Columns | The chart displays a column for every period selected as per the summary options (Menu > Date Grouping). |
| Legend | A legend appears on the right. |
| Customize Chart | The chart can be customised by clicking Customize Chart (button). |
| Column Diagram | The chart can be changed by clicking Column Diagram and selecting a different chart. Not all chart choices result in a meaningful display. |
Board View
The Board shows a summary of all the Costings.
- There is no View button, the report is automatically generated.
Buttons Explained
| Button | Description |
|---|---|
| Menu |
|
Filters Explained
| Filter | Description |
|---|---|
| All Due | Select All Due or a specific period: Today, Tomorrow, This Week, This Month. |
| 250 | Adjust the column width by using the arrow keys or overtyping the number. |
| Columns | Select to display All, All (Not Empty) or Pending columns. |
Fields Explained
A summary appears with the following information:
| Field | Description |
|---|---|
| Line 1 | Transaction Number / Transaction Reference. |
| Line 2 | Due Date / Customer or Supplier (line 2 is suppressed in condensed view). |