-
Report – Component Item Quantities Sold Through Kit Items
I need a search or report that can provide the quantities sold for individual items that are components of Kit Items. For example, if Kit A consists of items A, B, C, and D, I would like to know, for a given month, how many units of each component item were sold through Kit A. Additionally, some inventory items are used in…
-
NSC | How to Show Preferred Bins by Location in an Item Saved Search
Scenario A common warehouse reporting requirement is to create an Item Saved Search that displays: Inventory by Bin Inventory by Location Preferred Bin per Location On Hand Quantity by Bin The challenge occurs when an item has multiple preferred bins across different locations. In many cases, a formula such as: CASE WHEN…
-
NSC | Why Item Saved Searches Cannot Show Pricing for Items With No Pricing Records
Scenario A common reporting requirement in NetSuite is to display multiple price levels and currencies for items in a single Saved Search row. For example: Item Retail CAD Dealer CAD Retail USD Dealer USD Item A 100 90 75 65 Item B 120 110 95 85 The challenge appears when some items have no pricing records at all,…
-
Saved Search for Vendors and Customer
Hi guys! How can i create a saved search returning the vendors or customers for specific/selected subsidiaries of the environment? Because some may be set as primary subs or selected in the subsidiaries subtab in vendors and customers, what criteria should work to get all the customers/vendors working for specific/selected…
-
Total Quantity on Sales Order
Hello, I've a custom field on sales order header called Total Quantity. This is to get the total of line level quantities. Custom Field Total Quantity - Label = Total Quantity Type = Free-Form Text Store Value = Unchecked Applies To = Purchase Order and Sales Order Validation & Defaulting = <need to add saved search under…
-
Restricting - Saved Search / Quick Search / Global Search
I have restricted the Customer/Vendor/Employee Search for users to a limited number of columns by creating and assigning a saved search with role-based restrictions. This works correctly for the standard/customized saved search I created and assigned on the User Roles as below: However, users still have the option “Return…
-
Replicate BOM Inquiry Page in Saved Search with Level 2 Components
Is it possible? I tried to do it on Saved Search, but to no afford. Please drop your insights on how I can make it happen, either thru script, saved search, or any possible ways to make it happen. Sample Structure: NOTE: If possible, capture level 1 if it does not have level 2, capture level 2 if it has level 1. But…
-
NSC | Saved Search Cost Column Incorrectly Matching Total Cost Due to Summary Type Setting
Scenario: In your Saved Search, the Cost column is showing the same value as the Total Cost column. This raises concern because these fields are meant to represent different metrics: Cost should reflect the average cost per item. Total Cost should represent the average cost multiplied by quantity. Solution: After reviewing…
-
NSC | Unexpected Error When Accessing Item List View for a Specific User
Scenario: You are encountering an "Unexpected Error" when attempting to view the Item List in NetSuite using a specific user account. Other users may not experience the same issue, which suggests a user-specific configuration or view issue. Solution: Based on the error behavior and the information provided, it appears the…
-
NSC | Filtering Sales Order Items to Display Assembly Items Only
Scenario: A user needs to limit the list of selectable items on a Sales Order to Assembly Items only. By default, the item list includes all item types, which may not be relevant for specific business workflows involving only assembly items. Solution: To achieve this, a custom item filter must be created using a Saved…