formula – NetSuite Professionals

Question Tag: formula

All Questions

Filter by

Questions Per Page:

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.
- 62 views
- 0 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.
- 110 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.
- 340 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.
- 214 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.
- 246 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.
- 360 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.
- 604 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 Rookie Asked on October 22, 2021 in Items.
- 381 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.
- 435 views
- 1 answers
- 0 votes
How to split First Name and Last Name in saved search
I have a custom name field on a custom record that contains the person first and last name. I am …
formula

Saved Search

Margie Beginner Asked on August 9, 2021 in Saved Searches.
- 877 views
- 1 answers
- 0 votes