Emily S
11/05/2024, 7:43 PMCeligo AI
11/05/2024, 7:43 PMAI generated answer (using internal Slack threads):To add base units as a column on an item saved search in NetSuite, you can follow these steps: 1. Navigate to the saved search you want to modify. 2. Click on the 'Results' subtab. 3. Click on the 'Add New Field' button. 4. In the 'Summary Type' dropdown, select 'Group'. 5. In the 'Field' dropdown, select 'Base Unit' (if it's available directly) or 'Primary Units Type' (if you're looking for the units type). 6. Click 'Save'. However, if the 'Base Unit' or 'Primary Units Type' is not available directly, you might need to use a Formula (text) field with a CASE condition to display the base unit. This is especially useful if you want the column to show something different from what the units type field actually says. For example, if your units type field is “weight”, “length”, etc and you want to show, respectively, “kg”, “m”, etc. If you're dealing with UOM (Units of Measure) and want to show the conversion rate, you might need to add a custom field to the item to do the conversion, and then use it in your formula. This could be a case statement formula that essentially says when UOM is not base unit then divide quantity by Modifier field else quantity. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Celigo AI
11/05/2024, 7:44 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.877623677
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.835009038
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.829352379
Celigo AI
11/05/2024, 7:44 PM