Skip to content
P4 Software P4 Software / cifraHQ

Add these docs to Claude

Ask Claude questions about these docs. Claude reads the published pages and links you back to them. Copy this address:

https://p4-software.opendocs.page/mcp

In claude.ai or Claude Desktop: open Settings, then Connectors, choose Add custom connector and paste the address.

In Claude Code, run:

claude mcp add --transport http docs https://p4-software.opendocs.page/mcp

User Defined Fields

User Defined Fields

User Defined Fields (UDFs) let you extend CifraHQ entities with extra fields that are specific to your company. When you add a UDF to an entity such as Products or Invoices, a new column prefixed with U_ is added to that table and the field becomes available on the corresponding form. This follows the same model used in SAP Business One.

Where to find it

Go to Setup > User Defined Fields.

User Defined Fields page in CifraHQ.

User Defined Fields, the custom columns you add to entities and documents.

Supported entities

UDFs can be added to the following entities, organized by area:

Master Data: Products, Customers, Vendors, Warehouses, Accounts

Sales: Quotes, Sales Orders, Deliveries, Invoices

Purchasing: Purchase Orders, Inventory Receipts, Bills

What the list shows

Column Description
Entity The table the field belongs to
Field Name The database column name, always starting with U_
Label The display label shown on forms (optional; defaults to the field name)
Type The data type of the field
Max Length Maximum number of characters for Text fields
Sort Order Controls the order the field appears among other UDFs on the form
Required Whether the field must be filled before saving

Field types

Type Description
Text Free-form text, up to the configured max length
Integer Whole numbers
Decimal Numbers with decimal places
Date A date value
Yes/No A checkbox (boolean)

Creating a field

Click New and fill in the form. The Field Name must start with U_ followed by letters, digits, or underscores (for example, U_CustomerRef). The Label is optional - if left blank, the field name is used. Save to create the column immediately.

Only administrators can create or delete UDFs.

Showing a field in a document list

On the Quotes, Sales Orders, Deliveries, Invoices, Purchase Orders, Inventory Receipts and Bills lists, every field of that document can be shown as a column. The column starts hidden. To show it, open the Column Chooser on the list toolbar and tick the field (it is listed by its label). The column appears after the list's own columns and stays shown the next time you open the list.

  • Click the column heading to sort by the field. These columns cannot be filtered.
  • A Dropdown field shows the option's description.
  • Fields on document lines are not shown in the lists. You fill them in on each line.

When a field is created or deleted, each user's saved column layout on that list is reset once so the change shows up. Sorting, filters and page size are kept.

Using a field on a printed report

The values of a document's user-defined fields are part of its report data. Open the JSON menu on the document to see them. Each field appears under its field name (for example U_CustomerRef): a header field on the document itself, a line field on each line. Product fields are also on the product report, in the Products data source. Dropdown fields carry the stored code.

To show a field on an existing report, open the report in the designer, add the column to the Document data source (or to Lines for a line field), and place it on the page. A report saved before the field existed does not pick it up by itself.

Tips

  • Choose the narrowest type that fits your data. Text with a short max length keeps data entry consistent.
  • Use Sort Order to control where your custom field appears relative to other UDFs on the form.
  • Deleting a UDF removes the column and all data stored in it. This cannot be undone.

Related: Users · Customers · Vendors · Products · Invoices · Vendor Bills · Employees

Was this page helpful?