How to Create and Manage Custom Fields for Items

Create custom fields for items and understand their configurations to store item details conveniently.

TABLE OF CONTENTS

When to Use Custom Fields for Items

Custom Fields for Items are fields configured in your company and assigned to items in the catalog and documents to store necessary information. They can be used in Budgets, helping you allocate costs to appropriate budget lines. 

Most often, custom fields for items are used to set up Charts of Accounts/Cost Centers using the Drop-down list type with predefined options. The fields can also display additional information relevant to your business in Text and Date formats.

How to Create Custom Item Fields

Step 1: Add a New Field

Navigate to Configuration (Configuration for app.precoro.us) → Custom Fields for Items. You will see a list of all active custom fields for items created by your company. Press Add field in the top right corner.

A screenshot directing to the Add field button

On the Create Item Custom Field page, begin by entering the new field’s Name and Description. 

An image highlighting the custom field's name and description textboxes

Step 2: Select a Type

Next, you can select one of the following types:

Drop-down list

Allows selecting options from the list predefined for this field. You can add the options after configuring basic settings and availability for the field. 

Use this type when setting up the Chart of Accounts.

Text

Allows entering text information without predefined options. 

This type can be used for business-specific details requiring flexibility beyond standard options as well as codes and numbers.

Date

Suggests to select a date from the calendar. 

Use this type if you need expected payment or delivery dates stated for items.

If you choose the Drop-down list type, you can also select the sorting criteria for options.

Step 3: Configure Basic Settings

In the Basic Settings section, set the parameters depending on the selected type.

A screenshot highlighting the section defining if the field is required and added in printing

These settings are available for Text and Date types:

  • Required to select in items—makes the field mandatory.

  • Print in Excel & PDF documents—adds this field to Excel & PDF versions of the documents.

If you select the Drop-down list type, you will see these parameters:

  • Required to select in items—makes the field mandatory.

  • Show Option Code — if you use option codes, they can be displayed in documents, budgets, and the catalog.

  • Print code in Excel & PDF documents—adds option codes to Excel & PDF versions of the documents.

  • Print name in Excel & PDF documents—adds option names to Excel & PDF versions of the documents.

Here is an example of a purchase order PDF with a custom field option code and name printed:

A picture of a PDF purchase order with Chart of Accounts name and code printed

Step 4: Set Availability in Modules

Select which modules you need the field available in. Please note: to be included in budgets, the field must be available in Purchase Requisitions, Purchase Orders, Invoices, and Expenses.

A screenshot displaying the Available in Modules section and the modules to check to use the custom field in budgets

Step 5: Save the Custom Field’s Configuration

Review the configuration; you can save the custom field once everything looks good.

If you created a Text or Date type field, click Save in the top right corner to finalize the process. However, if you are making a Drop-down list field, click Next Step to save the configuration and proceed to add options. 

A screenshot directing to Next Step/Save button

Step 6: Add Options for Lists

You can easily add options via a table in the lower part of the page. You can create an option hierarchy with up to 5 levels. Here’s what you can do in the options table:

  • Add new options by filling in the codes and names;

  • Add sub-options after clicking the Add sub-level button;

  • Edit options using the Edit (pencil) button, including activating and deactivating options.

  • Delete options using the Delete (bin) button.

  • Expand or collapse sub-levels by pressing the downwards arrow to the left of the option.

Once you set up the list, press Update in the top right to save the changes.

You can also import options via an XLSX template; review this article to learn how.

How to Edit Custom Item Fields

Editing Existing Fields

You can navigate to Configuration — Custom Fields for Items, open the created field, edit all its settings, and then press Update to save the changes.

To edit options:

  1. Open the created field and find the option you want to change in the list.
  2. Click the Edit button (pencil icon).
  3. A sidebar will open on the right, allowing you to make necessary changes.
  4. Press Update to save the changes or Cancel to discard them.
An image introducing the custom item field editing sidebar

Please double-check the information if you have active integrations, as name changes can affect the integration work.

Activating, Deactivating, and Deleting Fields and Options

    To deactivate a Custom Item Field:

    Open it, switch off the toggle by its name, and press Update. A field cannot be deactivated if used in budgets or integrated.

    A screenshot showing the Active toggle

    Once deactivated, the field will not be shown in the general Custom Fields for Items list.

    To reactivate a Custom Item Field:

    1. Open the Custom Fields for Items page.

    2. Find the Active filter and select No.

      An image showing the filter
    3. You will see a list of inactive fields. Open the one you need to reactivate.

    4. Switch on the toggle by its name, then press Update.

    To deactivate a custom field option:

    1. Open the Custom Item Field.

    2. Find the needed option in the list and click the pencil icon.

    3. Switch off the Active toggle at the top of the sidebar.

    4. Click Update.

    If the deactivated option has sub-options, they will be deactivated as well.

    An image with the option deactivation sequence

    To reactivate the option, simply click Activate in the option list.

    A screenshot with the activate button

    You can also Delete options not used in the documents by clicking the Delete (bin) button opposite the option. If you try to delete an option used in documents, you will see a message explaining why the action is restricted and how to proceed.

    A sample message instructing how to delete an option

    Frequently Asked Questions

    How do you set up a Chart of Accounts or Cost Centers?

    You can do so by creating a Custom Item Field with the necessary settings and options.

    1. Create a new custom field as the article describes, choosing the Drop-down list type.
    2. Ensure it is available in all relevant modules.
    3. Create a list of options in Precoro or import the list as explained here.
    If you have a fixed catalog of items and services that you use, it would be beneficial to predefine the Chart of Accounts values for items in the Catalog.
    How do you filter documents using custom fields for items?

    If a custom field is available to select in a document, you can use this field to navigate the document list. Learn how to use the filter here.