Item Settings

Items can be inventory items, services, materials, components, products, tools or assemblies.

Items are linked to Categories, Classes and Locations. Customers and Suppliers can also be linked to Items and Categories.

The list of items is available in two views: Default and Estimating.

Navigation Example

Main Menu > Items > Items

Settings

Users Settings

Navigation Example

Main Menu > Setup > Settings > Users (tab) > Click a Username

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 > Dependencies Actions - Access AllowedCheckbox. If checked, access is allowed.Unchecked
Items & Inventory > Inventory - Access AllowedProvides a dropdown list of all the inventory views. If checked, access is allowed.Blank
Items & Inventory > Item Summary - Access AllowedOptions are:
  • None: No access.
  • User: Can view the summary.
  • Administrator: Can use the context menu functions.
None
Items & Inventory > Items - Access AllowedOptions are:
  • None: No access.
  • User: Can view the item.
  • Administrator: Can view and edit the item.
None
Items & Inventory > Items - Access Allowed to TabsProvides a dropdown list of all the tabs. If checked, access is allowed.
  • Image & Specs
  • Units
  • Costing & Pricing
  • Inventory
  • Estimating
  • Event
  • Accounting
  • Price History
  • Costing
  • Attachments
  • Dependencies
Not applicable
Items & Inventory > Items - Delete AllowedCheckbox. If checked, access is allowed.Unchecked
Items & Inventory > Pricing - Access AllowedCheckboxes. If checked, access is allowed. Access can be set for the following prices:
  • Supplier Prices
  • Selling Prices
  • Inventory Prices
  • Service Prices
Blank
Items & Inventory > Set Costing Status - Access AllowedCheckbox. If checked, access is allowed.Unchecked
Items & Inventory > Stock Check - Access AllowedOptions are:
  • None: No access to the module.
  • Full control: Can add, edit and delete records.
  • Enter count only: Can only enter the stock count quantities.
Full Access

General Settings:

Navigation Example

Main Menu > Setup > Settings > General (tab)

Setting Description Default
Alerts > Items Warning Message
  • Enter an SQL query that returns a field named WARNING. Its text is shown on the red warning bar of the item, instead of the standard warnings.
  • Fields of the open item can be used as parameters, for example, :MATUNITID.
  • A warning set on the item's production type is used instead of this one.
  • Leave blank to use the standard warnings.
Blank
General > Default: Font name for richtext fieldsThe font of rich text fields, for example, item descriptions, the rich text editor and estimate descriptions.Tahoma
General > Default: Font size for richtext fieldsThe font size of rich text fields.8
Items & Inventory > Caption for Items: CodeField to enter a different caption (e.g. short description). Leave blank to use Code.Blank
Items & Inventory > Caption for Items: ReferenceField to enter a different reference. Leave blank to use Reference.Blank
Items & Inventory > Decimals used to display Inventory quantity (0-4)Enter a number from 0 to 4.0
Items & Inventory > Default: Image size (kb)The default size for images that are uploaded to items.100
Items & Inventory > Filter - Accounts that update Inventory (e.g. = 2, in (1,2,3))Formula to include or exclude accounts that are used in Inventory Reports. (Uses the Account IDs)Blank
Items & Inventory > Inventory Weighted Ave CostingOptions: Field to select one of these options:
  • N/A: Weighted average costing is not used.
  • By Location: Weighted average costing is calculated for each item at each location.
  • By Item: Weighted average costing is calculated for each item.
N/A
Items & Inventory > Item Costings - Enable automatic updatesCheckbox. If checked, automatic updates are enabled.Checked
Items & Inventory > Item Costings - Transaction TypeOption to select a Transaction Type from a dropdown list of Transaction Types.Not set
Items & Inventory > Item Costings - Update...Options are:
  • Unit Cost: Unit costs are automatically calculated and applied, but fixed costs are not updated.
  • Fixed & Unit Cost (Requires multiple quantities on Costings): Both the fixed and unit costs are updated.
Unit Cost
Items & Inventory > Over/Under Stock - Option 1 - Months used to calculate the average monthly demandField to enter the number of months or leave blank if Option 2 is used.3
Items & Inventory > Over/Under Stock - Option 1 - Suggested stock holding in MonthsField to enter the number of months.2
Items & Inventory > Over/Under Stock - Option 2 - Days used to calculate the maximum usage over the last 12 monthsField to enter the number of days or leave blank if option 1 is used.28
Items & Inventory > Setup Cost UpdateEdit (button) provides a list of all the Transaction Types and update options as follows:
  • Transaction Type = You can select a Transaction Type from a dropdown list of all the Transaction Types.
  • Update = You can select one of these update options:
    • Supplier Price (Matching Supplier, Currency and Unit)
    • Supplier Price (Matching Supplier)
    • Supplier Price (All Suppliers and Prices)
    • Cost Price (All Units in Local Currency)
    • Cost Price (Same Unit in Local Currency)
    • Inventory (Last Price)
    • Inventory (Average Price)
    • Inventory by Location (Average Price)
  • Status = You can select a status from a dropdown list of all available statuses.
    • For example:
      • Transaction Type = Purchase Orders (Inv) (PO-INV).
      • Update = Supplier Price (Matching Supplier).
      • Status = Complete.
Not applicable
Items & Inventory > Transaction used for Inventory AdjustmentsA dropdown list of Transaction Types for you to select the applicable Transaction Type (e.g. Stock Check).Not set

Transaction Settings

Navigation Example

Main Menu > Setup > Settings > Transactions (tab)

The following settings can be added to Transaction Types:

Setting Description Default
Transactions > Add Items to TransactionsCheckbox. If checked, items are added.Checked
Transactions > Convert new Items to Estimates when Pricing = Sell PriceCheckbox. If checked, the conversion is done.Unchecked
Transactions > Group Transaction Items byOptions to group transactions by:
  • None
  • Class
  • Category
  • Subcategory
N/A
Transactions > Link Meter Data to Transaction ItemsCheckbox. If checked, meter data is linked.Unchecked
Transactions > Search Items by CodeCheckbox. If checked, items are searched using their codes.Checked
Transactions > Default: Show Item NotesCheckbox. If checked, notes appear.None

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.