formula – NetSuite Professionals

Question Tag: formula

All Questions

Filter by

Questions Per Page:

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.
- 72 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.
- 181 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.
- 244 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.
- 406 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.
- 416 views
- 0 answers
- 0 votes
Date Formula
Hello, I’m trying to craft a formula to produce an error if a date that is entered in a field …
Date

formula

Workflow

JJacobs Beginner Asked on December 28, 2021 in Administration.
- 317 views
- 1 answers
- 0 votes
Extracting string from an email message in case capture and storing as a variable
Hi. I have the following scenario. There are email messages sent to a support email message which are being converted …
Cases

formula

Suitescript 2.0

Lefemmenikita Rookie Asked on December 2, 2021 in SuiteScript.
- 436 views
- 0 answers
- 0 votes
Advance Saved Search
Hi All, How can I apply currency abbreviation for this code block. Currently i used this format below Field: Formula …
Cases

formula

Saved Search

NSP17 Rookie Asked on November 18, 2021 in Saved Searches.
- 701 views
- 1 answers
- 0 votes
How to show the total component cost on an Assembly Item record?
Trying to show the sum of the components on the Assembly Item record so we can confirm and verify the …
Assemblies

Custom field

formula

Randal Beginner Asked on October 22, 2021 in Items.
- 433 views
- 2 answers
- 0 votes
Why are custom field values different when exporting?
We have custom fields that are set up using Case Statements to determine the values. When viewing the values on …
Custom field

formula

ChrisDenison Rookie Asked on October 18, 2021 in Other.
- 488 views
- 1 answers
- 0 votes