-
Mass consolidation of item fields to one field
Hello everyone, I am developing a script that would take certain item fields on an item record and consolidate it into key-value data. example of the expected results: "field name1=field value1";"field name2=field value2";"field name3=field value3"; I have a suitescript developed, but I am not sure how to deploy it. I did…
-
Matrix Item Field Selection in Where Clause - Search Query Error
I am currently facing a challenge related to the creation of a matrix item and subsequent search functionality in our system. I have successfully created a matrix item using two item fields: 'Color' and 'Size', as illustrated in the attached image. However, an issue arises when I attempt to apply a filter criterion to the…
-
How can I edit this custom field?
I cannot edit this custom item field.
-
Adding a purchase order field onto an item record
Hi Guru's, I am trying to provide our sales team with more accurate information. Right now our Item record shows the expected receipt date. It is getting that from the PO but o the line level. Our buyers update the PO's Receive by date instead of changing every line of a PO. I am trying to add a field that will show the…
-
What determines when a custom item checkbox field is available to a workflow set field value action?
Hi Everyone, I am creating a workflow that will clear a custom item check box, but the desired field is not available for selection in the workflow's set field value action parameters. In looking at the available fields, I see that 1 of 3 custom item check box fields is available, just not the one I want to use. I do not…
-
Formula in a custom item field
Hi Guru's! I previously asked about adding the safety stock level on a report, which is not currently possible. I am now trying to create a custom item field that copies the value. I am not familiar with formulas in NetSuite. Because a safety stock is per inventory location, I need to make sure it picks the right one. Here…
-
NSC | Show on Custom Field the Merchandise Hierarchy Node
When using the Hierarchy Node on the Saved Search, it only pulls up the last level. In order to show all levels, a Custom Item Field must be created. Note: To use Merchandise Hierarchy in NetSuite, there are required features that needs to be enabled. See article 77293 Configuring Merchandise Hierarchy. 1. Navigate to…
-
Custom item field
Hi, We have 5 price level's. Is there a way to add a custom item field that uses one of the price level's to calculate its value ? Thanks Asher
-
Image field in Workbook
Hi all, I have created an image field in an item record with store value as true. In the saved search I was able to see that field and was able to add it to the search result. In the suite analytics Workbook, I used an item dataset but I was not able to see this custom field? Adding image field in workbook data set, Is…