Custom fields can be added to customer, supplier, product, sales and purchase order records. If there's something you want to record and to use to filter and report on, use a custom field.
Suppliers and Customers have their own set of independent custom fields.
Custom fields can be of the following types:
- Freeform text
Any text up to 64 characters. - Numeric only
Brightpearl will make sure that the text entered is only numbers or spaces. - Select list
You must create a number of options, from which the user will select one. - Textarea
Used for text greater than 64 characters. - Yes/no
Use this to display a yes/no selection., for confirmation of terms and conditions or similar. There is already a default "newsletter" checkbox field in Brightpearl which should be used for any opt-in services. - Date
This will display the pop-up calendar from which the date can be selected.
If you set a custom field as "required" then an admin user will not be able to create or edit a contact without entering some information in the field.
Add a Custom Tab
Each contact record is made up of a selection of tabs, and each tab contains various fields. You can add you own customised tabs; useful for grouping large amounts of extra custom fields:
- Go to Setup > Custom fields > Customers or Suppliers.
- Click the Add a field button.
- Enter a name for your tab in the new tab field.
- Click Save and close the window.
- Refresh the screen to see your tab.
Your tab will be added but it will contain no data.
Add a Custom Field
Add a new field into one of your custom tabs:
- Go to Setup > Custom fields > Customers or Suppliers.
- Click the Add a field button.
- Enter a name for your field.
- Select the tab you want to add the field into or you can add a new tab by entering a new tab name.
- Specify whether this field is required. If you set it as required you will not be able to save the record, after adding or editing it, without completing the field.
- (Contacts only) Specify whether this field can be edited on the web portal. This will allow registered users to edit the data themselves.
- Click Save to add the field to the tab.
Your field will now be displayed in the record, ready for you to begin collecting data.
Select List Options
If you selected to create a select list field you will need to define the list items. Once you have added the custom field as above:
- Click the Edit options link next to the field type.
- Click the Add a value button.
- Enter the list value.
- Click Save.
- Add more items as required.
Searching By Custom Fields
You can search through your record using data you have entered into the custom fields.
- Go to your customer/supplier listing.
- In the filters, click the Add filter link.
- Select the field you want to search by in the "Where" field.
- Next to it specify how you want to filter by that field, e.g. "contains" or "is greater than".
- Then type the parameter.
- Click Filter report to apply the search and display the results.
As with any other search filter, you can save the search for later use by adding it to your Favourites. To add a page to your favourites, click the Add to favourites link at the bottom of the screen. Each time the search is performed the results are refreshed with up-to-date data.
You can also include custom fields (amongst others) on your contact list, hover the mouse over your username and select My Preferences. In the Contact screen columns tick the checkbox next to any detail to include it on the contact listing.




