Custom Fields
You can create custom fields for both purchase orders & invoices – these will be found above the line items. We have plans to roll this functionality out though to other areas like line items and suppliers. Custom fields on GRN line items are available as a premium feature if required.
Creating Fields
You can create multiple custom fields and use their values to trigger workflows. A typical example will be a buying type – for example, a buying category such as Capex or Opex.
To create a custom field, go to Business Settings > Custom Fields. Click “New Field”
Select the type – Purchase Order or Invoice.
Give the field a name
Create a name for the placeholder – ie the {name} you will use in your templates
Add a description to help you identify it
And then a display order – you can order your custom fields.
Under field type, select one of Text, Date or Select list. If you select List, you can then populate the items in the list.
You can then use this value as a condition on a workflow entry point or step. An example is shown below:
This example shows a workflow that will only trigger if the custom field of ‘Stage’ has the value of ‘Landed’.
Custom fields are available to view in reporting as well.
You can create Parent and Child custom fields. An example is a list that has Vehicle manufacturers:
Ford, BMW, Mercedes
The second list below has Models of cars but is filtered based on the manufacturer – the parent list. In the example below, you can see the List is Vehicle models, with a parent of Manufacturers. Each child of the list can have the Parent list option specified.
Workflows
You can then use this value as a condition on a workflow entry point or step. An example is shown below:
This example shows a workflow that will only trigger if the custom field of ‘Stage’ has the value of ‘Landed’.
Reporting
Custom fields are available to view in reporting as well.
Custom field nesting
You can create Parent and Child custom fields. An example is a list that has Vehicle manufacturers:
Ford, BMW, Mercedes
The second list below has Models of cars but is filtered based on the manufacturer – the parent list. In the example below, you can see the List is Vehicle models, with a parent of Manufacturers. Each child of the list can have the Parent list option specified.
When setup, you will see these fields working correctly on the PO or Invoice screen.
Related Articles
GRN custom fields
If enabled on your account, you can create custom fields to be used when GRN’ing your orders. First off ask us to enable the feature – available to the Enterprise and Unlimited editions. Setting them up Head to Business Settings > Custom fields. Here ...Custom fields on line items
Introduction You can create custom fields on the line items of both Purchase Orders and Invoices. These fields can be text based, a date or a select list of options. The values are then stored with the document and can be seen in the line-item ...Custom Export CSV / Excel Profile
The custom export integration type allows you to customise and produce uniquely structured downloads of your invoice data as either a CSV or Excel document. Creating a profile To begin, you will need to name your profile and set the export format, ...Custom Buttons
A custom button can be created in the approval process to not only approve or reject but also to set a custom field value at the same time. The best example of this is if you want to approve an invoice but also set a custom field of “type” to have a ...GRN an order
This article tells you how to receipt an order. GRN means Good Received Note. To undo a GRN, you can GRN with a negative value to restore the correct GRN value you require. You can receipt an order from the Purchase Order (PO) list view. Find an ...