Costing Module Expanded View

Buttons Explained

• Arrows: Navigates to the next or previous Costing, if more than one Costing is linked to an item.

• New: Creates a new costing.

• Copy: Copies the costing to create a new one.

• Delete: Deletes the current costing.

• Save: Saves any changes.

• Actions: 

  • Debug Parameters: Uses with Estimate Types to test/update the parameters back to the setups. E.g. A lookup doesn't show anything,  then you can use this to test why, and also to update the setups.

  • Expand all Items: Converts all the material items with linked costings to components up to a maximum of 100 levels. Asks for confirmation.

  • Update from Item Costing: Deletes all the items on the Estimate and recreates them from the linked Costing. Asks for confirmation.

  • Delete Inactive Items: Displays any inactive items and asks for confirmation to delete them.

• Menu:

  • Email Excel: Allows users to email the list view by opening the default email template with the view attached in .xlsx format. 

  • Export Grid: Allows users to choose a save location to save the grid view in .xlsx format on the server.

  • Layout & Grids: Individual Save and Restore options for the four tabs.

Header Explained

• Reference: Displays the costing transaction's Reference field (e.g. Item Description).

Input (tab) Explained

Buttons and Filters Explained

• Update: A batch update function that allows users to update all the selected fields when Update (button) is clicked. The update options are:

  • Adj%: Updates the Adjustment Percentage to the amount typed in the adjacent block.

  • W%: Updates the Waste Percentage to the amount typed in the adjacent block.

  • RU: Updates the amount by which the calculation is Rounded Up to the amount typed in the adjacent block.

  • Qty Type: Updates the Quantity Type to the option selected from the dropdown list. The options are:

    • Fixed: The quantity is Fixed and is unaffected by the unit quantity.

    • x: The price is multiplied by the Estimate Quantity.

    • x Size: The price is adjusted by the Estimate's Size.

    • /: The price is multiplied by the number of Units.

  • Status: Updates the status to the option selected from the dropdown list. The options are:

    • Inactive

    • Active

    • Active - Don't Adjust

    • Budget

    • Budget - Don't Adjust

  • Setup (Hr/s): Updates the Setup Hours to the hours typed in the adjacent block.

  • Speed - Qty: Updates the Speed Qty to the quantity typed in the adjacent block.

  • /Hrs: Updates the Production Hours to the hours typed in the adjacent block.

  • Fixed Cost: Updates the Fixed Cost to the cost typed in the adjacent block.

  • Fixed Price: Updates the Fixed Price to the price typed in the adjacent block.

  • Clear Setup: Clears the Setup Hours, Fixed Cost, and Fixed Price.

  • Caption: Updates the Caption to the one typed in the adjacent block.

  • Desc: Updates whether the description of the item is included in the estimate description (e.g. Quote Letter) as selected from the dropdown list. The options are:

    • • N/A: The Description is excluded.

      • D: The Description of the Material or Service is included.

      • 1xD: The Quantity and Description of the Material or Service is included.

• Delete (button): Deletes the selected line items.

• Diagonal arrows (buttons): Expands or collapses the view.

• Show Preview icon (button): Toggles showing or hiding the preview.

• Cell Auto Height (button): Expands the height of the rows to fit the content.

• Popup (button): Opens a list of Items for users to select one.

• All (filter): Allows users to select All, Material, Assembly, or Service from the dropdown list which filters the item to add.

• Search (input field): Limits the dropdown list of items to those that match the search phrase.

• Item (shows a blank field): A dropdown list of Items for users to select the item to add.

• Quantity (shows 1): A field to type the Quantity of the item to add.

• Root: A checkbox. If checked, adds the item as the Root Item.

• Add (button): Adds the item selected in the field provided.

• Custom (button): Allows users to add a Custom Assembly, Material, or Service as selected from the dropdown list.

Fields Explained

• Field Chooser (*): Allows users to add or hide columns.

• CompID: A composite field consisting of:

  • The Item's Type indicator (coloured block e.g. Service, Material or Assembly).

  • The Costing's line item Status indicator (coloured circle).

  • The system-generated number for the component.

• Type: An abbreviation indicating the Type of item (e.g. EST for Estimate).

• Item: A sequential number for each item on the costing.

• Description: The item's Description. 

• Category: The item's Category.

• Sub-category: The item's Subcategory.

• QuoteCompID: The system-generated number for the component.

• Caption: The line item's costing caption.

• Desc: An indicator if the description is included in the Estimate's description. The options are:

  • N/A (Blank): The Description is excluded.

  • D: The Description of the Material or Service is included.

  • 1xD: The Quantity and Description of the Material or Service is included.

• Provider: The Supplier or Cost Centre providing the item. 

  • Clicking on the entry displays the Setup and Speed fields if provider is a Cost Centre. These fields are editable.

  • Clicking on the entry displays the Supplier with a dropdown list of all the other Suppliers, and a Reference if the provider is a Supplier.  These fields are editable.

• Fixed Price: The item's Fixed Price.

• Qty: The Quantity of the item. 

• Qty Type: The item's Quantity Type which can be:

  • Fixed: The quantity is Fixed.

  • x: The price is multiplied by the Estimate Quantity.

  • x Size: The price is adjusted by the Estimate's Size.

  • /: The price is multiplied by the number of Units.

• Unit Price: The Unit Price of the item. 

• /Qty: The Quantity of the item that is included in the Unit Price.

• Hr/s: The number of Production Hours needed to produce the item.

• Total Qty: The Total Quantity of the item included in the costing.

• Unit: A description of the Unit.

• Subtotal: The item's subtotal before any adjustment.

• Adj %: The Percentage by which the item's price was Adjusted.

• Adjustment: The Amount by which the item's price was Adjusted.

• Total: The item's Total including any adjustment.

• /Unit: The Price for 1 Unit.

• Fixed Cost: The item's Fixed Cost.

• Unit Cost: The item's Unit Cost.

• Total Cost: The item's Total Cost.

• Profit: The Profit to be made on the Transaction. 

• GP%: The Gross Profit Percentage to be earned on the line item.

• MU%: The Mark-Up Percentage applicable to the line item.

• Code: The item's Code.

• W%: The percentage Wastage.

• Round: The amount to which any calculation is Rounded Up.

• Minimum: The Minimum Quantity that can be ordered or made.

• Reference: The line item's Reference.

• Length: The item's Length.

• Width: The item's Width.

• Height: The item's Height.

• Setup (Hr/s): The number of Setup Hours.

• Speed - Qty: The Quantity that can be produced in the timeframe specified under /Hrs.

• /Hrs: The timeframe for the Speed - Qty field.

• CC Status: The Status of the Costing. 

• Item Type: The Type of Item involved in the transaction (e.g. Assembly, Material).

• Note: The item's Note.

• Menu (...):  A submenu that can also be accessed by right-clicking the line. The options are:

  • Set Status: Changes the status to the selected option from this list:

    • Active

    • Active - Not Adjusted

    • Budget

    • Budget - Not Adjusted

    • Inactive (Not added to the Estimate Total)

  • Convert to Assembly: Converts the line item to an Assembly.

  • Copy Material: Copies the Material to a new line item.

  • Change Material: Changes the Material to a different Material.

  • View/Edit Note: Allows users to view, edit or create a Note.

  • View/Edit Specification: Allows users to view, edit or create a Specification.

  • Convert prices to Fixed/Unit Price: Opens an interface that allows users to enter three quantities and prices. If the Convert (button) on the popup is clicked, these prices are converted to Setup, Unit, and Cost per 1000 Prices.

  • Add Custom: Adds a Custom Item to the costing of they type selected from this list:

    • Assembly

    • Material

    • Service

  • Move Up: Moves the entry one line up. Keep the Materials and Services together. Services should be in the correct order the item will be produced.

  • Move Down: Moves the entry one line down. Keep the Materials and Services together. Services should be in the correct order the item will be produced.

  • Open linked Item: Opens the linked item's setup page.

  • View Item Summary: Opens the item's summary.

  • Delete: Deletes the line.

Costs (tab) Explained

Filters Explained

• By checking the applicable radio button, the entries can be grouped by:

  • None

  • Component

  • Type

  • Description

Fields Explained

• Field Chooser (*): Allows users to add or hide columns.

• ID:  The system-generated number for the entry.

• Component:  A Description of the Component (e.g. Material).

• Assembly:  A Description of the Assembly.  

• Assembly (Code):  The Assembly's Code. 

• Qty (Comp):  The Component's Quantity.

• Unit (Comp):  The Component's Unit.

• Type: An abbreviation indicating the Type of item (e.g. EST for Estimate).

• Category: The item's Category.

• Description: The item's Description. 

• Code: The item's Code.

• Provider:  The name of the Provider (e.g. Supplier or Cost Centre name).

• Subcategory:  The name of the item's Subcategory.

• Hr/s: The number of Production Hours needed for the service or assembly. 

• Qty: The Quantity of the item.  

• /Qty: The Quantity of the item that is included in the Unit Price.

•  Qty Type: The item's Quantity Type which can be:

  • Fixed: The quantity is Fixed.

  • x: The price is multiplied by the Estimate Quantity.

  • x Size: The price is adjusted by the Estimate's Size.

  • /: The price is multiplied by the number of Units.

• Length: The item's Length. 

• Width: The item's Width.

• Height:  The item's Height. 

• Unit: A description of the Unit.

• Direct Cost:  The line item's Direct Cost.

• Adj %: The Percentage by which the item's price was Adjusted.

• Adjustment: The Amount by which the item's price was Adjusted. 

• Fixed Cost: The item's Fixed Cost.

• Unit Cost: The item's Unit Cost. 

•  Fixed Price: The item's Fixed Price.

• Unit Price: The Unit Price of the item.  

• Total Cost: The item's Total Cost.  

• Total: The item's Total including any adjustment.

• /Unit: The Price for 1 Unit. 

• Qty (S):  The Item's Quantity in the Base Unit.

• Unit (S):  The Item's Base Unit.

• In Stock: The quantity that is In Stock. 

• Reserved: The quantity that has been Reserved for pending or current orders.

• On Order: The quantity that has been Ordered but not yet received.

• Available: The quantity that is Available.

• Profit: The Profit made on the Transaction. 

• MU%:  The Mark-Up Percentage applicable to the line item.

• GP%: The Gross Profit Percentage earned on the line item. 

•  Menu (...): A sub-menu that can also be accessed by right-clicking the line. The options are:

  • Open linked Item: Opens the Linked Item's setup page.

  • View Item Summary: Displays a summary of the item's information and transactions on the right.

Pricing (tab) Explained

Buttons Explained

• Add Qty: Works with the preceding 3 input fields. 

  • Block 1: Enter the Start Quantity (e.g. 100).

  • Block 2: Enter the End Quantity (e.g. 500).

  • Block 3: Enter the Step (e.g. 100, which will add 100, 200, 300, 400, 500).

• Add MU %: Adds the amount typed in the preceding block as the Mark-Up Percentage to the selected fields.

• Menu: 

  • Revert to default Adjustments: Changes any adjustment percentages back to their default values.

  • Remove all Price Fixes: Allows all the prices to be edited.

  • Don't Round Off - Set all Prices: Recalculates all the prices without rounding them.

  • Round Totals - Set all Prices: Recalculates all the totals by rounding them.

  • Round Unit Totals - Set all Prices: Recalculates and rounds the unit prices, and updates the total prices.

  • Delete all Prices: Deletes all the prices.

Fields Explained

• Qty: The item's Quantity.

• Cost: The item's Cost Price.

• MU %: The Mark Up Percentage applied to the item.

• Profit: The Profit to be made as per the costing.

• GM%: The Gross Margin Percentage.

• Total: The Total Price.

• /Unit: The Price per Unit.

• Checkbox: If checked, the price is Active.

• Menu (...):  A sub-menu that can also be accessed by right-clicking the line. The options are:

  • Revert to default Adjustment: Reverts the Cost Centre's default adjustment.

  • Fix Price: Prevents edits to the price.

  • Cancel Price Fix: Allows the price to be edited.

  • Don't Round Off: Does not round any of the calculations.

  • Round the Total: Only rounds the final total up.

  • Round the Unit Total: Only rounds the unit total up.

  • Delete Price: Deletes the price.

Updates (tab) Explained

Filters and Buttons Explained

• Price (checkbox): Specifies whether the Price will be updated when Update (button) is clicked.

• Description (checkbox): Specifies whether the Description will be updated when Update (button) is clicked.

• Update (button): Updates the Estimate from the linked item.

Fields Explained 

• Field Chooser (*): Allows users to add or hide columns.

• ID: The system-generated number for the entry.

• QuoteCompID: The system-generated number for the Component.

• Component:  A description of the Component.

• Type: An abbreviation indicating the Type of item (e.g. Material or Service)).

• Description: The item's Description. 

• Estimate: The item's Estimate Description.

• Item: The item's full Description as set up in the Items module.

• Variance: Specifies whether the Prices or Descriptions were updated.

Quantities and Summary Panel Explained

Button Explained

• Add: Enters a single quantity if the quantity is typed in the field closest to Add.

Fields Explained

• Qty: The item's Quantity.

• Total: The Total Price for the quantity.

• /Unit: The Price per Unit.

• Checkbox: If checked, the price is the Active Price.

Related Topics

• Reference: Costings List View

• Reference: Item Creation and Editing

• Tutorial: Item Creation and Editing