Search Results for

    Show / Hide Table of Contents

    Sale products

    Sale products are created to be used within documents throughout the Sales features.

    Note

    To view the legacy version, please select Legacy User Guide.

    How to view Sale products

    Viewing Sale products

    As per Generic Navigation options, either from left-hand navigation panel, expand Settings and select Sale products from the Sales folder or enter Sale products in the Search option.

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

    • Description: This will describe the sale product.
    • Code: The unique code to identify the sale product.
    • Sale Account: When the product is used it will be analysed under this Chart of account code on the P/L.
    • Product Group: A sale product can be put in a Product group. This will result in the sale product inheriting the defaults of the Product group such as availability for use in other features such as purchase, stock and timesheets.
    • Sale, Purchase, Expense, Stock, Timesheet etc: These boxes are ticked showing the other features that the Product can be used in.
    Tip

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

    How to create Sale products

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

    2. Select New.

    3. Enter the following fields as required, some will be mandatory.

      • Product code: Enter a unique code.

      • Type: Select from the dropdown options.

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

      • Description: Free text.

      • Force Change: Tick this if you would like Users to change the sale 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.

    4. If other features are to be available on this product, then select them in the Tick boxes.

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

      The tabs

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

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

      For Sales there will be an Accounting tab where you enter the Chart of account which will be the way the product is listed in the P/L.

      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 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.

      This tab will show any 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 Sales product to allow the Product to be used in other features, select 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 Sales product information, double click the Product then select Edit.

    • You can now make changes to the product information.

    • Select Save when finished.

    How to force change to description

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

    • Tick the Force change tick box.

    • Select Save when finished.

    How to Import/Export Sale Products

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

    2. Select Sales Product Import from the option.

    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 Sale Products from one of the options as shown above in Viewing Sale products.

    2. Select Sales Product Export from the option.

    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 export 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_sale
    • code
    • description
    • enforce_description_change_flag
    • product_group
    • product_type
    • uom_group
    • uom
    • legacy_ref
    • s.account
    • s.attr.CostCentre
    • s.attr.Department
    • s.attr.Activity
    • s.attr.TaxBand
    • s.attr.Project
    • ext.Warranty
    • ext.AlarmStandard
    • ext.ReviewDate
    • ext.AlarmType
    • ext.Xref
    • ext.Supplier
    • ext.Serial_Number
    • ext.Installer

    Updated September 2026

    In this article
    Back to top Generated by DocFX