Costings Edit 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 costings, they are available to view separately under the Costings menu option (if set up).
General Information on Costings
Item Costings
- Costings and Estimates can be created in the relevant tabs of Items.
- Variable Items can be created to allow Users options when Quoting.
- Dependent Costings can be updated when the Cost Price on an Item is updated, subject to the applicable setting.
- A Costing (COS) record is automatically added to an Item's Costing & Pricing (tab) when a Costing is updated.
Estimates from Costings
Fields marked in brown are filled in from the linked Item and cannot be updated when working with certain Costings.
- When an Item Costing is converted to an Estimate, the Estimate is populated as follows:
- Data extracted from the Costing:
- Caption
- Variable
- Description
- Note
- Size
- Qty
- Data extracted from the Item or Option linked to the Costing:
- Code
- The provider (Supplier or Cost Centre)
- Production setup time and speed
- Costs and Prices
- Data extracted from the Costing:
Variables and Options
- The Variables functionality lets you link Options to a Costing item. Options specify similar interchangeable items, optional extras or different parameters like colour.
How to Add Options to a Costing
- Open an Item (Main Menu > Items > Item) and click Costing (tab).
- Use the search bar to find an item to add as an option.
- Click Add Option (button).
- The option is added to the Options panel on the right.
- Note: When an Option is added to a Costing Item, the linked Costing Item is automatically updated to be a Variable.
- Note: Right-click an item and select Set Default to set that option as the default. The Costing's ID, Type, Description and Code are populated from the default option.
Using Variables on a Transaction
- When you right-click an item and select View/Edit Variables, the item is automatically converted to an Estimate before opening the Variables dialogue.
- If the Item does not have a linked Costing, the option to View/Edit Variables is unavailable.
Edit View
Most of the fields on Edit View are for reference purposes only. They cannot be edited.
Top Row Buttons Explained
The options under Actions and the Menu button are only available to certain costing types.
| Button | Description |
|---|---|
| Arrows | Navigates to the next or previous Costing. |
| Output | Unavailable unless custom templates are created. Contact QuickEasy Software for assistance. |
| Links | Displays a list of links to other transactions in the transaction flow. |
| Delete | Deletes the current costing if confirmed. |
| Save | Saves any changes. |
| Actions | Lets you change all the selected records.
|
| Status | Updates the Item Status with the new status selected from the dropdown list of available statuses. |
| Adj % | Updates the item's Adjustment Percentage to the one entered in the block. |
| Qty | Updates the item's Quantity to the quantity entered in the 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. |
| Group | Updates the Group to the one entered in the adjacent block. |
| Subgroup | Updates the Subgroup to the one entered in the adjacent block. |
| Resolve | Update the Resolve to the one selected on the dropdown list. |
| Check in | Updates the check-in Date and Time to the ones selected in the adjacent blocks. |
| Check out | Updates the check-out Date and Time to the ones selected in the adjacent blocks. |
| Debit | Updates the general ledger Account to Debit to the one selected from the dropdown list of accounts. |
| Credit | Updates the general ledger Account to Credit to the one selected from the dropdown list of accounts. |
| Location | Updates the item's Location if it is an inventory item. |
| Unit Price | Updates the Unit Price with the price entered in the adjacent 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. |
| Add Attachment/Link | Opens an interface for you to add an Attachment or Link. |
| Update Transaction | Updates the transaction from one of these sources:
|
| Order Items by Group | Applies when multiple line items have groups allocated to them. Orders the line items by Group. |
| 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 |
|
Header Section Explained
| Field | Description |
|---|---|
| Status Bar |
|
| No | The system-generated number for the Costing. |
| Date | Enter the date on which the costing was created. Defaults to today but can usually be edited. |
| Reference | Enter a description of the costing. Depending on the type of costing, this field may be prefilled and not editable. |
| Note | Enter a Note about the costing. Depending on the type of costing, this field may be prefilled and not editable. |
| Category | A dropdown list of Transaction Categories for you to select one. |
Item Input Section Explained
Depending on the Costing Type, certain options may be greyed out, or once clicked, display a message that the feature is unavailable for this type of costing.
Buttons Explained
| Button | Description |
|---|---|
| Items |
|
| Popup | Opens an interface to choose multiple items at once. |
| Add | Adds the selected Item and input Quantity to the Costing. |
| View |
|
Fields Explained
| Field | Description |
|---|---|
| Search (dropdown list) | Opens a list of Categories for you to select one. |
| Search (dropdown list) | Displays a list of Items belonging to the chosen category. |
| Qty | Enter the Quantity of the selected item to add to the costing. |
Item 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. |
| Item | A sequential number for each item on the transaction. |
| From | The source document that was used to create the transaction. |
| Type | An abbreviation indicating the Type of item (e.g. EST for Estimate). |
| Status | The item's Status. |
| Image | A checkbox. If checked, an Image is added to the item. |
| Category | The item's Category. |
| Costing | The Status of the Costing that the item is linked to. |
| Description | The item's Description. |
| Code | The item's Code. |
| Debit | The Ledger Account that is Debited. |
| Credit | The Ledger Account that is Credited. |
| Supplier | The name of the Supplier involved in the transaction. |
| Cost Centre | The Cost Centre selected for the transaction. |
| Group | The user-defined Group for the item. |
| Reference | The item's Reference. |
| Department | The item's Department. |
| @ (Start Time) | The Start Time for the goods to be produced. |
| @ (Due Time Item) | The Time by when the goods should be produced. |
| Item Type | The Type of Item involved in the transaction (e.g. Assembly, Material). |
| Subgroup | The item's Subgroup. |
| Expires | The Expiry Date of the goods (where applicable). |
| VAT% | The Percentage VAT that applies to the item. |
| Fixed Cost | The item's Fixed Cost. |
| Fixed Price | The item's Fixed Price. |
| Unit Cost | The item's Unit Cost. |
| VAT | Whether the value Includes or Excludes VAT. |
| /Qty | The Quantity of the item that is included in the Unit Price. |
| Fixed Qty | The item's Fixed Quantity. |
| Lead Days | The number of lead days needed before production can start. |
| Qty | The Quantity of the item. |
| Unit | A description of the Unit. |
| Unit Price | The Unit Price of the item. |
| Adj % | The Percentage by which the item's price was Adjusted. |
| Adjustment | The Amount by which the item's price was Adjusted. |
| Landing Cost | The Landing Cost allocated to the item. |
| Total CUR | The transaction total in the Transaction's Currency. |
| Total CUR (inc) | The transaction's VAT Inclusive total in the Transaction's Currency. |
| Total (exc) | The VAT Exclusive total of the Transaction. |
| VAT Type | The default VAT Type for the entry (mostly No VAT). |
| VAT | The VAT component of the Transaction. |
| Total (inc) | The VAT Inclusive total of the Transaction. |
| Check in | The item's Date and Time to Check In. |
| Check out | The item's Date and Time to Check Out. |
| /Unit | The Price for 1 Unit. |
| Assign to | The User the transaction is assigned to. |
| Start Date | The Start Date for the item to be produced. |
| Due Date | The Date by which the item should be produced. |
| Progress | The percentage progress of the transaction. |
| Out Qty | The Outstanding Quantity. |
| Out Amt | The Outstanding number of Items in Local Currency. |
| Serial No. | The Serial Number of the item if the item is tracked by serial number. |
| GM% | Automatically calculated. Shows the Gross Margin Percentage. |
| Profit | The Profit made on the transaction. |
| Tracking | The item's Tracking option. |
| Note | The item's Note. |
| Specification | The item's Specification. |
| TK ID | The Timekeeping ID linked to the item. |
| Menu (...) | A submenu that can also be accessed by right-clicking the line.
|
Linked Transactions Fields Explained
Click the View (button) in the Costing Edit View > Select Linked Transactions.
| Field | Description |
|---|---|
| Field Chooser (*) | Add or hide columns. |
| ID | The system-generated number for the entry on the list. |
| Trans | A description of the Transaction Type (e.g. COST for Costing). |
| No. | The transaction's number. |
| Status | The Item Status of the individual item in the transaction. |
| Date | The Date of the transaction. |
| Due Date | The Date by which the item should be produced. |
| Company | The name of the Customer or Supplier involved in the transaction. |
| Reference | The transaction's Reference. |
| Category | The transaction's Category. |
| Currency | The transaction's Currency. |
| From | The Transaction and Number that the costing was copied from. |
| 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. |
| Total CUR | The transaction total in the Transaction's Currency. |
| Menu (...) | An eye. If clicked, switches back to Edit View > Item View. |
Estimate Costs Fields Explained
Click the View (button) in the Costing Edit View > Select Estimate Costs.
| Field | Description |
|---|---|
| Field Chooser (*) | Add or hide columns. |
| ID | The system-generated number for the entry on the list. |
| ItemID | The system-generated number for the item. |
| Description | The item's Description. |
| Component | A description of the Component (e.g. Assembly, Material, Service). |
| Qty (Comp) | The Component's Quantity. |
| Unit (Comp) | A description of the Component's Unit. |
| Type | A description of the line item's Type of item (e.g. Materials, Services). |
| Category | The item's Category. |
| Description | The item's Description. |
| Code | The item's Code. |
| Subcategory | The item's Subcategory. |
| Hr/s | The Estimate or Actual Hours that the task took. |
| Qty | The Quantity needed. |
| Qty Type | The Quantity Type (e.g. per unit, fixed). |
| Length | The item's Length. |
| Width | The item's Width. |
| Height | The item's Height. |
| Unit | The item's Unit. |
| Unit Cost | The item's Unit Cost. |
| Unit Price | The item's Unit Price. |
| Total | The Total for the line item. |
| /Unit | The Cost per Unit. |
| /Qty | The Quantity included in the cost per unit. |
| Direct Cost | The total Direct Cost. |
| Adj % | The Percentage Adjustment that is applied. |
| Adjustment | The Adjustment Amount that is applied. |
| Fixed Cost | The Fixed Cost of the line item. |
| Fixed Price | The Fixed Price of the line item. |
| Total Cost | The Total Cost of the line item. |
| Qty (S) | The Quantity Required in the Base Unit. |
| Unit (S) | A description of the Base Unit of the required quantity. |
| Reserved | The quantity Reserved for pending or current orders. |
| On Order | The quantity Ordered but not yet received. |
| In Stock | The quantity that is In Stock. |
| Available | The quantity that is Available. |
| Provider | The Provider of the item (e.g. Supplier or Cost Centre). |
| Rate | The Rate for the line item. |
| Profit | The expected Profit to be made for the line item. |
| MU% | The line item's Markup Percentage. |
| GP% | The line item's Gross Profit Percentage. |
| Menu (...) |
|
Inventory Fields Explained
Click the View (button) in the Costing Edit View > Select Inventory.
| Field | Description |
|---|---|
| Field Chooser (*) | Add or hide columns. |
| MatUnitID | The system-generated number for the item's unit. |
| Description | A Description of the item. |
| Code | The item's Code. |
| In Stock | The quantity that is In Stock. |
| On Order | The quantity Ordered but not yet received. |
| Reserved | The quantity Reserved for pending or current orders. |
| Available | The quantity that is Available. |
| Required | The quantity that is Needed for this Costing. |
| Unit | A description of the item's Unit. |
| Menu (...) |
|