Search Results for

    Show / Hide Table of Contents

    Products

    Products are created to be used within documents throughout iplicit features.

    This section will show all Products on the system. To view specific Products for differing documents, you can view these on the individual areas - Purchase products, Sale products, Expense products, Stock products, Timesheet products or Loan products.

    How to view Products

    Viewing Products

    Select Product / Products from the Settings section of the pulse menu -

    Note

    This is an example screenshot of the pulse menu.

    Position of the menu items within pulse will vary according to available options and dependant on personal screen resolution.

    or enter Products in the Quick Launch Side Menu.

    This will then show all the Products on the system where normal customisation of Sets can be used.

    And Tree option will be available where you can toggle the rows to different levels.

    Tip

    To modify the columns displayed, select on the top right of the page, then tick/untick the information you want to hide or display.

    More attribute information

    • Description: This will describe the product.
    • Code: The unique code to identify the product.
    • Purchase/Sale Account: When the product is used it will be analysed under this Chart of account code on the P/L.
    • Purchase, Sale, Expense, Stock, SKU, Timesheet, Loan, Payroll and Job: These boxes are ticked showing the other features that the Product is used in.

    How to create Products

    Create a new Product
    1. Select Products from one of the options as shown above in Viewing Products.

    2. Select New.

    3. Enter the following required fields.

      • Product code: Enter a unique code.

      • Description: Free text.

      • Type: Select from the dropdown options.

    4. Other fields are mandatory.

      • Group: Select a Product Group from the dropdown options, which will result in some fields being auto filled with the group's defaults.

      • Force Change: Tick this if you would like Users to change the product's description upon using it.

      • Unit group: This is the Unit of measure group.

      • Unit: This is the Unit of measure. Choose a Unit group and the Unit both from the dropdown options.

    5. Enter the features that you would like the product to be available for in the Tick boxes.

    6. Depending on the feature boxes that have been selected, various tabs will be available.

      • Accounting
      • Stock
      • Timesheet
      • Pricing
      • Resource Availability
      • Custom
      • Tracking
      • Documents
      • Log

      If Purchase or Sale is selected then there will be an Accounting tab where you enter the Chart of account.

      The way the product is listed in the P/L through Chart of account codes is setup here.

      For example,

      Once the Account has been selected, the following popup appears. You can now add default values, and select if they are required or fixed for any documents that use this Product.

      This tab will show if Timesheet option is ticked in the main details.

      This tab will show if Stock option is ticked in the main details.

      This tab allows default pricing to be set for the products. When the product is used elsewhere in the system, it will automatically inherit the pricing setup in this section.

      You can add resource availability in this tab which allows the product to be used by Resources throughout the system.

      Documents using this Product.

      Transaction History of the Product.


    1. Once all Product details are entered, select Save.

      • This Product will now be available for use.

    How to add Product availability

    Add product availability
    • If you would like to change/amend a Product to allow the Product to be used in other features, double click the Product then select Edit.

    • You can now tick the features that you would like to add to the Products availability.

    • Select Save when finished.

    How to change Product information

    Change product information
    • If you would like to change Product information, for example allow the Product group or description, double click the Product then select Edit.

    • You can now make changes to the product information.

    • Select Save when finished.

    How to force a description change

    Force a user to change the description upon using a product
    • If you would like to force Users to change Purchase product information upon using it, double click the Product then select Edit.

    • Tick the Force change tick box.

    How to Import/Export Products

    Import/Export Products
    • Import
    • Export
    • File information
    1. Select Products from one of the options as shown above in Viewing Products.

    2. Select the icon and select Product Import.

    3. Enter the name of the Excel file, which is saved on an external source, and other options.

      Tip

      To create an Import file with the correct field names and formatting, Export a file first and save to your external source. Then use this file to add details ready to import.

    4. Select Submit.

      Selecting Queue from the dropdown option will queue the import process until other actions in iplicit are completed.

      Warning

      iplicit allows a maximum of 5,000 rows in a single Import.

      If your Import is too large, an error message will tell you that the Import cannot be processed and will advise you to create smaller Import files.

      If the latter is not possible, please contact Customer support.

    1. Select Products from one of the options as shown above in Viewing Products.

    2. Select the icon and select Product Export.

    3. Tick include closed if required, then select Submit to create an Excel file on an external source.

      Selecting Queue from the dropdown option will queue the import process until other actions in iplicit are completed.

    4. The Export file is created as an Excel spreadsheet on your local data source.

    Below are the options for filling out the Excel file with the information available for Products.

    • is_active
    • is_purchase
    • is_sale
    • is_expense
    • is_timesheet
    • is_stock
    • code
    • description
    • enforce_description_change_flag
    • product_group
    • product_type
    • uom_group
    • uom
    • legacy_ref
    • s.account
    • p.account
    • p.is_resale
    • e.quantity_caption
    • e.quantity_default
    • e.quantity_fixed
    • e.rate_caption
    • e.rate_default
    • e.rate_fixed
    • e.receipt_required
    • e.tracking_mode
    • e.tracking_period
    • stk.is_sku_many
    • stk.uom
    • stk.stock_allow_negative
    • stk.has_trace
    • stk.stock_valuation_method
    • sku.code
    • sku.description
    • sku.uom
    • t.timesheet_rule
    • t.date_from
    • t.date_to
    • t.their_ref
    • t.sale_order
    • t.legal_entity_flag
    • t.legal_entity_code
    • t.project_flag
    • t.project_code
    • t.contact_account_flag
    • t.contact_account_code
    • t.timesheet_rate_type_flag
    • t.timesheet_rate_type_code
    • t.auto_generate_sale_invoice
    • t.aggregate_sale_invoice
    • t.auto_generate_purchase_invoice
    • t.aggregate_purchase_invoice
    • t.require_item_note
    • resources
    • resource_groups
    • p.attr.Project
    • p.attr.Department
    • p.attr.CostCentre
    • p.attr.TaxBand
    • p.attr.Resource
    • p.attr.TaxCode
    • p.attr.AssetMovementTypeIc
    • s.attr.CostCentre
    • s.attr.Department
    • s.attr.Activity
    • s.attr.TaxBand
    • s.attr.Project
    • t.attr.Activity
    • t.attr.Department
    • ext.Warranty
    • ext.AlarmStandard
    • ext.ReviewDate
    • ext.AlarmType
    • ext.Serial_Number
    • ext.Supplier
    • ext.Xref
    • ext.Installer
    • ext.X_REV_IE_CATEGORY
    • ext.X_REV_IE_SUBCATEGORY

    Updated December 2025

    In this article
    Back to top Generated by DocFX