Workflows have the capability to capture the details of a user who is currently logged in and update the value of a compatible field. This allows for a seemingly dynamic process. A common example is using the workflow to capture the user’s role while logged in for their approval process. Navigate to Customization > Workflow > Workflows Desired Workflow: Click Edit Click… Continue reading Set the Workflow Field Value Based on the Role of the Current User via a Workflow
Author: Rose Wadakken
Vendor Bills Saved Search for Pull out Expense Category
Need to pull the Expense Category information from the Vendor Bill record within the Saved Transaction Search. Navigate to Lists > Search > Saved Searches > NewClick Transaction Search TypeSearch Title: Enter TitleClick Criteria tab click Standard subtabFilter: Select Type Type: Select any of Select Bill Click Set Select Applied To Transaction Fields… Applied To Transaction Filter: Select Expense Category Expense Category: Select none of Select -None- Click Set Click Results tab click Columns subtabField: Select Applied To Transaction Fields… Applied To Transaction Field: Select Expense Category Click Add… Continue reading Vendor Bills Saved Search for Pull out Expense Category
Creating Formula Fields
In addition to defining a custom field that is populated with dynamic data as described in Dynamic Defaults and Dynamic Hyperlinks, you can define fields to be dynamically calculated based on the values returned in the dynamic fields. To define formula fields, click the Validation & Defaulting subtab of the custom field. Check the Formula box. In the… Continue reading Creating Formula Fields
Bulk Approval of Journal Entries by workflows
Bulk approval of journal entries if Approval Routing preference for Journal Entries is true and no workflows created. To resolve the issue: A. Create a Workflow for Journal Entries. Go to Customization > Workflow > Workflows. Click New Workflow button. Click From Template. Click Select button on Journal Entry Basic Approval. On the Workflow pane on the right, click pencil icon to edit the workflow. On Basic Information section, set Release Status field to Released. On Event Definition section, mark on View… Continue reading Bulk Approval of Journal Entries by workflows
Cannot remove subsidiary: xxx because this record is used on a transaction for subsidiary: xxx.’ when Adding Subsidiary in Item Record
When One World NetSuite users edit the item record to select a subsidiary, the selected subsidiaries become deselected from the list, hence generating the error, ”You cannot remove subsidiary: XXX because this record is used on a transaction for subsidiary: XXX”. Edit the Item record Locate the Subsidiary section Press CTRL key on the keyboard (Windows) or Command/Apple key (Mac) Select the Subsidiary to be added… Continue reading Cannot remove subsidiary: xxx because this record is used on a transaction for subsidiary: xxx.’ when Adding Subsidiary in Item Record
Location is Mandatory when Multi-Location Inventory is Enabled
Once Multi-Location Inventory (MLI) Feature is enabled in a NetSuite account under Setup > Company > Enable Features > Items & Inventory, then the Location field is set to mandatory by default in transaction forms The standalone Vendor Bills, Customer Invoices, and Cash Sales mentioned in Article 27868 (Location field is mandatory in transaction form… Continue reading Location is Mandatory when Multi-Location Inventory is Enabled
Searching for Deleted Records
There are two types of records that support deletion tracking. Each type uses a different data source, and the approach you use to search for the records is different depending on the type. Records that use the old data source – These records use the old data source that was designed for saved searches and reports.… Continue reading Searching for Deleted Records
Set Multiple Item Names as a criteria filter in an Item Saved Search
Set Multiple Item Names as a criteria filter in an Item Saved Search Navigate to Reports> Saved Searches> All Saved Searches> New 2. Select Item as Search Type 3. Assign a name on the Search Title field 4. On the Criteria tab > Standard sub tab> Filter column, add the following: a. Formula (Numeric) is equal to 1 then b. Formula = Case when {name}=’XXXX’ OR {name}=’XXXX’ then 1 else 0 end… Continue reading Set Multiple Item Names as a criteria filter in an Item Saved Search
No Value for Purchase Order field on Vendor Prepayment Saved Search
Vendor Prepayment Saved Search > No Value for Purchase Order field This is the intended behavior when using the Purchase Order field on a Vendor Prepayment Saved Search. As an alternate solution, do not use the Main line as Criteria and use Applied to Transaction under the results tab.
Create a Saved Search for Unapplied Vendor Prepayment
Vendor Prepayments represent advanced payments to Vendors which has to be applied in the future. It is important that users keep track of Vendor Prepayments with unapplied portions to prevent users from making Payments to Bills that are supposed to be applied to a Vendor Prepayment. As of the moment, there is no field that can… Continue reading Create a Saved Search for Unapplied Vendor Prepayment