Sourcing and Filtering Examples

This topic provides some examples of how you can use the Source Filter by field to create dynamic custom fields.

Let's say you want to link two transactions, such as a sales order and a subsequent credit memo. First, create a transaction custom field and add it to customer credit memos (using a custom form to limit it to the credit memo form only). For more information, see Creating Custom Fields by Type and Adding Custom Fields to Transaction Forms

On the transaction custom field record, set these field values:

• List/Record – Transaction

• Source List – Entity

• Source Filter by – Customer

When you select a customer on the credit memo, NetSuite fills the new list field with transactions for that customer only.

Here's an example of the setup for a new transaction body field called Associated Transaction that uses the setup criteria described previously. In addition, The Sale box is checked on the Applies To subtab, so that the new field appears only on Sale transaction types, such as credit memo.

On the credit memo, the associated transactions for the selected customer are available in the new Associated Transaction field. All associated transactions are listed because no filters were applied.

Now, suppose you want to create a similar field called Associated Sales Order on the same credit memo that lets you choose only a sales order from the available sales order for that customer.

Create the new field using the same setup that was used to create the previous Associated Transaction field. For this example, also include a filter to limit the list to include only transactions of a particular type (sales orders). When you create a new credit memo, and select a customer, the Associated Sales Order list will show only sales orders from that customer.

The following example shows the setup for a transaction body field called Associated Sales Order that uses the setup criteria described previously. In addition to the sourcing criteria, this example contains filtering criteria that includes only the Sales Order transaction type.

On the credit memo, only sales orders for the selected customer are available in the new field.

Related Topics

• Creating a Custom Field
• Creating Custom Fields by Type
• Assigning Custom Fields to Specific Record Types
• Behavior of View from Order Only Settings on Transaction Line and Transaction Body Custom Fields
• Setting Display Options for Custom Fields
• Setting Validation and Defaulting Properties
• Setting Sourcing Criteria
• Setting Filtering Criteria
• Dependent Dropdown Lists
• Restricting Access to Custom Fields
• Restricting Access to Employee Custom Fields
• Creating Read-Only Custom Fields
• Adding Translations for Custom Fields
• Adding Custom Fields to Transaction Forms
• Tracking Changes to Custom Fields

General Notices