ANS-0262 · CUSTOM FIELDS, RECORDS & FORMS

How to Auto-Populate Class from Department on NetSuite Transactions?

Learn to configure a simple NetSuite workflow to automatically assign a Class value to transactions based on the selected Department.

AreaCustom Fields, Records & FormsAudienceNetSuite administratorDifficultyBeginner

Short answer

To auto-populate the Class field from the Department on NetSuite transactions, create a simple workflow. Configure it to trigger on transaction record load and update, with an 'On After Field Edit' action for the Department field. This workflow will automatically set the transaction's Class based on the Class tied to the selected Department.

Scenario

NetSuite users often require the Class field on various transaction types to automatically populate based on the selected Department. Manually assigning the Class can be time-consuming and prone to errors, especially when a specific Class is consistently associated with a particular Department. This automation streamlines data entry and ensures consistency across financial records.

Solution

To automatically populate the Class field on a transaction when the Department is selected, implement a simple workflow with a single state. Follow these steps to create and configure the workflow:

  1. Create a New Workflow:

    • Record Type: Transaction
    • Sub Types: Purchase Order, Sales Order, Cash Sale, etc... (Specify all relevant transaction types)
    • Initiation Event: Event Based
    • Set event definition to: On Create & On Update
    • Trigger Type: Before Record Load

  2. Configure the Workflow State:

    • Add a new action: Set Field Value
    • Set the trigger to: On After Field Edit
    • Specify Client Fields: Department (Main)

  3. Define Parameters for Set Field Value Action:

    • Field: Class (Main)
    • Value: Record Department (Main) Field Class

    This workflow will activate when a transaction record is loaded or updated. The state will then trigger specifically after the Department field is edited. If a Class is associated with the selected Department, the workflow will automatically set that Class on the transaction record.

Originally answered August 21, 2017Verified July 5, 2026

Expert NetSuite Support

Need help with this NetSuite issue?

Custom Fields, Records & Forms consulting and configuration support

Talk to a consultant

Keep exploring

Related answers