Hi All
I am trying follow the steps in Suite Answer 81470 but stucked at the workflow creation. Please advise is this Answer explaining the steps I can follow to create a new workflow for JE Approval? Or must I first have our workflow for JE Approval done by programmer or consultant?
Kedalene
Bulk Approval of Transactions Using Saved Search
Share
Last Updated
05/10/2022
Reading Time
2 mins
Answer ID
81470
Applies To
Product: NetSuite 2022.1
Scenario
It is possible to create a similar functionality as the Approve Journal Entries for Saved Searches where a user can multiple-approve lines of records.
What is needed is to create a Custom Field Checkbox on the Transaction record that would then be used in a Saved Search Inline Editing to mark all records to be Approved. A Workflow would then run once the Checkbox is edited that would set the Current User as the Approver and the custom Approval Status as Approved.
Solution
- Create a Checkbox field for the Transaction Record
- Navigate to Customization > List, Records, & Fields > Transaction Body Fields > New
- Label: Enter Label
- Example: Enter Transaction Checkbox
- Click Applies To tab
- Note: Put a checkmark on all applicable transaction types.
- Type: Select Checkbox
- Store Value: Enter Checkmark
- Click Display tab
- Click Save
- Create a Workflow
- Navigate to Customization > Workflow > Workflows > New
- Basic Information:
- Name: Enter Name
- Example: Enter Workflow A
- Record Type: Select Transaction
- Sub Types: Select any Transaction Type
- Execute as Admin: Enter Checkmark
- Release Status: Select Released
- Keep Instance and History: Select Always
- Enable Logging: Enter Checkmark
- Event Definition:
- On Create: Enter Checkmark
- On View or Update: Enter Checkmark
- Click Save
- Double click State 1
- Click New Action
- Click Set Field Value
- Basic Information:
- Trigger On: Select After Record Submit
- Condition
- Record: Select Old Record
- Field: Select Transaction Checkbox
- Compare Type: Select Not Equal
- Value Field: Select Transaction Checkbox
- Parameters:
- Field: Select Custom Approval Status
- Value, From Field:
- Record (Join Field): Select Current Record
- Field: Select User
- Click Save
- Create Saved Search
- Navigate to Lists > Search > Saved Searches > New
- Click Transaction
- Search Title: Enter Title
- Example: Enter Saved Search A
- Click Criteria
- Fillters:
- Note: For every required field, use the drop-down menu to select it and once adjusted click add if needed.
- Type: Select the Transaction Type
- Main Line: Select Yes
- Transaction Checkbox: Select Yes
- Click Results
- Click Columns
- Fields:
- Note: For every required field, use the drop-down menu to select it and once adjusted click add if needed.
- Select Transaction Checkbox
- Click Save & Run
Note: Once the Saved Search created is ran, enable the Inline Editing button above the Column Headers. It is now possible to click the Checkbox beside each result. Once the Checkbox is clicked, it will automatically set the Approver and Custom Approval Status.
Was this article helpful?
Have more questions?