-
Setting a Custom Item Search Form for the Employee Center?
We'd like to create a custom item search form for anyone creating a Purchase Order via the Employee Center role. This is the form that would appear when you click the "Search" button next to the item field: As an example, here's the default form: I believe that you can use a Saved Search and mark the "Form" checkbox next…
-
Conversion of Stock Units to Sales UOM in item search
How do I convert quantities from the stock unit of measure to the sales unit of measure in a NetSuite Item Saved Search?" For example: if sales unit is in meters and stock unit is in 50m roll, the search needs to identify how much the on-hand quantity will be in sales unit. I need the same for analysing possible sales with…
-
Total quantity of item on hand excluding specific bins
We are working on a workflow to set a custom field on an item to a value based upon the quantity available for one of our locations. The workflows are ready to go (one to set the field to true and one to set the field to false) by testing with a saved search we have written. What we are struggling with now is to properly…
-
Why does Item saved search show assembly components even if they are not present in the transaction?
Hello, I have created a search of type item and then limit the transaction fields: document number to a single sales order but in the results its showing components of the assembly items even though they are not present in the actual transaction. All we have is assembly items in the actual sales order but in the search…
-
NSC | Saved Search to show Items Sold but not yet Billed / Invoiced
Scenario A user needs to create a Saved Search that shows both: Items sold but not yet paid by the customers Items sold but not yet paid to the vendors Solution This can be accomplished by creating an Item Saved Search with the following details: Criteria tab > Standard subtab Criteria tab > Summary subtab Formula used:…
-
Report Needed for Daily Price List Management and Reporting Across Multiple Vendors
Dear Gurus, I hope this message finds you well. I’m seeking your expertise to streamline the process of managing and analyzing daily price lists from multiple vendors in NetSuite. Background: I receive daily price lists (excel or csv files) from approximately 300 vendors. These price lists contain the items they sell, and…
-
Item Saved Search - need help with formula
Hello community & gurus, I currently have an item saved search that is broken down by year. Below are screenshots from the results tab/page. I need to create a replica of this report that includes the last 12 months. My problem is that I can't figure out what the correct formula should be for the Total Qty Sold & the Total…
-
History of changes in the purchase price of items
History of changes in the purchase price of items Is it possible to list the history of changes in the purchase price of an item in a saved search? If so, could you please provide details? Thank you in advance.
-
System notes information in an Item Saved Search
Good day. I am trying to get the date when the pricing for an inventory item is set, which is the effective date, in a saved search. A snapshot of the fields included is as below. The formula throws an error: Invalid Expression. Any suggestions to get the date value in the saved search? Regards, Ram
-
NSC | Reference the Opportunity record's Entity Status field in an Item Saved Search
In Opportunity records in NetSuite, there appears to be 2 statuses. One of them is the Document Status (boxed in red) and the other is called Entity Status (boxed in yellow). The list of statuses in this Entity Status field (ID: entitystatus) can be found under Setup > Sales > Customer Statuses. In an Item Saved Search,…