formula – NetSuite Professionals

Question Tag: formula

All Questions

Filter by

Questions Per Page:

Calculate Percentages in Workbook
I have a Dataset that has the following Columns – Transaction Date – Document ID – Ship Date – Actual …
analytics

formula

work order

RedHeadHunt Beginner Asked on June 25, 2024 in SuiteAnalytics.
- 1K views
- 1 answers
- 0 votes
I am trying to divide a formula I have used in my Saved search by Quantity Available
I am trying to divide a Quantity Available by a Formula I have used in my Saved search by . …
formula

Saved Search

lhopkins1232 Rookie Asked on April 29, 2024 in Saved Searches.
- 4K views
- 3 answers
- 0 votes
Display image from web url (like =IMAGE(URL) formula)
I have an item field with a URL to an image and an item saved search… Can I display the …
formula

items

Saved Search

suiteeeeee23 Rookie Asked on September 26, 2023 in Saved Searches.
- 1K views
- 1 answers
- 0 votes
Inventory available by location in Transaction Saved Search?
I am working on a saved search for Sales orders down to line items. I have the bones of the …
formula

Saved Search

RedHeadHunt Beginner Asked on May 30, 2023 in Inventory.
- 2K views
- 1 answers
- 0 votes
Running Total formula in Netsuite Saved Search is duplicating each row
I am using the SUM OVER PARTITION formula in Netsuite transaction saved search to get the running total of item …
formula

Saved Search

SQL

bzahid Rookie Asked on April 27, 2023 in Saved Searches.
- 3K views
- 1 answers
- 0 votes
wrong total in Analytics Workbook calculated Measure
I am learning Analytics Workbooks and Created a Pivot workbook. I created a formula in the measures (calculated measure) for …
analytics

formula

memariani Rookie Asked on January 14, 2023 in Other.
- 1K views
- 2 answers
- 0 votes
Total Amount field on Transfer Orders
I would like to have a total amount field in Transfer Orders. Actually, it should display quantity * average cost …
Custom field

custom form

formula

Transaction Line Field

Zubair Rookie Asked on September 14, 2022 in Inventory.
- 1K views
- 1 answers
- 0 votes
Need an Item Search where Pricing level ID = X is NULL
Trying to to return a list of items where Shopify Product (custom field) = T and Shopify Price (Price Level) …
formula

item group

items

Saved Search

SQL

roboriccio Rookie Asked on August 2, 2022 in Items.
- 2K views
- 1 answers
- 0 votes
How to add 2 saved search results into a third?
Hi Team. Complete NetSuite Newbie here and I am struggling with getting my saved search to work. So here are …
Custom field

formula

invoice

Saved Search

Satrangi Rookie Asked on March 25, 2022 in Saved Searches.
- 1K views
- 1 answers
- 0 votes
How can a Saved Search return difference in Time between Now and Last Modified Date
I am attempting to get the difference in Time (Hours) between two dates. I am running a Transaction Search with …
DateTime

DateTime Math

formula

Saved Search

nathanw Beginner Asked on March 2, 2022 in Saved Searches.
- 2K views
- 0 answers
- 0 votes