P4 Software
/
cifraHQ
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.
Go to Setup > User Defined Fields.
User Defined Fields, the custom columns you add to entities and documents.
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
| 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 |
| 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) |
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.
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.
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.
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.
Related: Users · Customers · Vendors · Products · Invoices · Vendor Bills · Employees
Was this page helpful?