We'd love to hear from you! Provide feedback to earn a badge today. Take our quick survey

.fullPageLoader { display: none } body.isLoading .page { max-height: initial; height: initial; }

.logo { width: 120px; height: 28px; opacity: 0.6; } .header-container { height: 50px; background: #302D2A; } .logo-container { position: absolute; display: flex; color: #fff; left: 130px; top: 10px; } .logo-container p { margin: auto; padding-left: 20px; } .titleBar-button_fmuucnv.titleBar-button_fmuucnv, .titleBar-button_fmuucnv.titleBar-button_fmuucnv:hover:not(:disabled), .titleBar-button_fmuucnv.titleBar-button_fmuucnv:focus, .titleBar-button_fmuucnv.titleBar-button_fmuucnv:focus:not(.focus-visible), .titleBar-button_fmuucnv.titleBar-button_fmuucnv:active:not(:disabled), .titleBar-button_fmuucnv.titleBar-button_fmuucnv.isOpen, .titleBar-button_fmuucnv.titleBar-button_fmuucnv.isOpen:focus, .titleBar-button_fmuucnv.titleBar-button_fmuucnv.isOpen.focus-visible { color: #fff !important; } .footbar-container { height: 80px; } .footbar-subcontainer { position: relative; height: 80px; background: #CEAA8F; display: flex; align-items: center; justify-content: center; } .footbar-subcontainer p { color: #302D2A; font-size: 20px; margin-right: 10px; } body { font-family: Oracle Sans; } .About.P { background-size: cover; background-image: url(https://us.v-cdn.net/6032253/uploads/815/QURW3A01AKVP.png) } body.Section-Profile .ProfileOptions .ButtonGroup a { background: #302D2A; border-radius: 50px; color: #fff; } body.Section-Profile .Profile dd, body.Section-Profile .Profile dt { color: #100F0E; } .BreadcrumbsBox .Breadcrumbs a { color: #302D2A; font-family: Oracle Sans; } .BreadcrumbsBox { max-width: 1264px; padding-left: 40px; padding-right: 40px; margin: 0 auto; } .ReactionsWrap.H { color: #100F0E; font-weight: 800; } body.Section-Profile .CountItemWrap { width: 95px; margin: 14px; } body.Section-Profile .CountItemWrap .CountTotal { color: #A1ADAF; font-family: Oracle Sans; font-style: normal; font-weight: normal; font-size: 48px; } body.Section-Profile .CountItemWrap .CountLabel { font-family: Oracle Sans; font-style: normal; font-weight: normal; font-size: 16px; } .BoxFilter ul.FilterMenu li.Active a{ background: #302D2A; color: #fff; padding: 5px; } .BoxFilter ul.FilterMenu li a{ font-family: Oracle Sans; font-style: normal; font-weight: 600; font-size: 17px; color: #41727E; } @media screen and (max-width: 768px) { .logo { margin: 0 auto; } } @media screen and (max-width: 480px) { .footbar-container { height: auto; } .footbar-subcontainer { display: block; height: auto; } .footbar-subcontainer p { font-weight: bold; font-size: 26px; line-height: 34px; color: #fff; padding: 20px; } } .logo { width: 120px; height: 28px; opacity: 0.6; } .header-container { height: 50px; background: #302D2A; } .logo-container { position: absolute; display: flex; color: #fff; left: 130px; top: 10px; } .logo-container p { margin: auto; padding-left: 20px; } .footbar-container { height: 80px; } .footbar-subcontainer { position: relative; height: 80px; background: #6B9869; display: flex; align-items: center; justify-content: center; } .footbar-subcontainer p { color: #FFF; margin-right: 10px; font-family: Oracle Sans; font-style: normal; font-weight: bold; font-size: 20px; line-height: 26px; display: flex; align-items: center; text-align: right; color: #FFFFFF; margin: 20px 20px; float: left; clear: both; } .About.P { background-size: cover; background-image: url(https://us.v-cdn.net/6032253/uploads/815/QURW3A01AKVP.png) } body.Section-Profile .ProfileOptions .ButtonGroup a { background: #302D2A; border-radius: 50px; color: #fff; } body.Section-Profile .Profile dd, body.Section-Profile .Profile dt { color: #100F0E; } .breadcrumb-container .BreadcrumbsBox .Breadcrumbs a { color: #FFFFFF !important; } .BreadcrumbsBox .Breadcrumbs a { color: #302D2A; font-family: Oracle Sans; } .ReactionsWrap.H { color: #100F0E; font-weight: 800; } body.Section-Profile .CountItemWrap { width: 95px; margin: 14px; } body.Section-Profile .CountItemWrap .CountTotal { color: #A1ADAF; font-family: Oracle Sans; font-style: normal; font-weight: normal; font-size: 48px; } body.Section-Profile .CountItemWrap .CountLabel { font-family: Oracle Sans; font-style: normal; font-weight: normal; font-size: 16px; } .BoxFilter ul.FilterMenu li.Active a{ background: #302D2A; color: #fff; padding: 5px; } .BoxFilter ul.FilterMenu li a{ font-family: Oracle Sans; font-style: normal; font-weight: 600; font-size: 17px; color: #41727E; } @media screen and (max-width: 768px) { .logo { margin: 0 auto; } } @media screen and (max-width: 480px) { .footbar-container { height: auto; } .footbar-subcontainer { display: block; height: auto; } .footbar-subcontainer p { font-weight: bold; font-size: 26px; line-height: 34px; color: #fff; padding: 20px; } }

Discussions

Check out Oracle NetSuite upcoming events and conferences here

Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!

We’re ringing the bell so you know what that means… LAST CALL! This is your last week to register for #SuiteWorld at our early bird special rate and save $300. Join us for our biggest event of the year and learn more about how your business can get the most out of our system. https://lnkd.in/enaAr8p8

Release 2022.2 is Coming! – Get Ready with your Release Preview Account

Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.

formula

Formula for Invoice Date Paid

Answered Ari Heitner 22 views 6 comments 0 points Most recent by Dominica Sevilla-Oracle Aug 1, 2022 8:31PMAsk A Guru
Saved Customer search - showing Groups

Answered ✓ RobertBongers 11 views 4 comments 0 points Most recent by Dominica Sevilla-Oracle Jul 29, 2022 6:02PMAsk A Guru
COUNT in a saved search formula

Answered ✓ OliverK 31 views 23 comments 0 points Most recent by Ivy Lopez-Oracle Jul 28, 2022 6:44PMAsk A Guru
Item Search with complex formula based on transactions.

Answered ✓ Adam Birk 12 views 3 comments 0 points Most recent by Adam Birk Jul 27, 2022 5:57PMAsk A Guru
Saved Search Formula: Dividing Two Columns: Debit Amount/Quantity

Answered ✓ User_1K0CO 11 views 5 comments 0 points Most recent by User_1K0CO Jul 23, 2022 1:16AMSearch / Reporting
Zero in a saved search drops off in the results

Answered Vernita 21 views 5 comments 0 points Most recent by Katerina Winklerova-Oracle Jul 22, 2022 3:33AMAsk A Guru
HTML tags in saved search formula calculations

Answered Vernita 11 views 3 comments 0 points Most recent by Dominica Sevilla-Oracle Jul 20, 2022 10:30PMAsk A Guru
Formula for running total

Answered ✓ Vernita 1 view 2 comments 0 points Most recent by Elychelle Gulen-Oracle Jul 6, 2022 2:51AMAsk A Guru
calculate formula for multiple fields in custom record

Answered ✓ Amjad Kasem 11 views 3 comments 0 points Most recent by Amjad Kasem Jun 21, 2022 10:58AMAsk A Guru
Add running balance column in saved search

Ibraam 44 views 1 comment 1 point Most recent by Elychelle Gulen-Oracle Jun 17, 2022 10:20PMAccount Administration
Regexp Substring in Workflow

Answered ✓ Vernita 41 views 8 comments 0 points Most recent by Kristoffer Viray-Oracle Jun 17, 2022 9:20AMAsk A Guru
AE:Formula to extract substring to first blank space

Answered ✓ Vernita 23 views 3 comments 0 points Most recent by Jack Daryl Espiel-Oracle Jun 15, 2022 8:04PMAsk A Guru
Finding a particular substring in the middle of a string

Answered ✓ Vernita 1 view 2 comments 0 points Most recent by Vernita May 30, 2022 12:32AMAsk A Guru
Saved Search Formula for Unit Price based on Item Current Standard Cost

Answered ✓ RobertBongers 22 views 7 comments 0 points Most recent by RobertBongers May 17, 2022 7:09AMAsk A Guru
Saved search add up values of the same row

Answered ✓ Dirk Nieuwkamp 11 views 4 comments 0 points Most recent by Dirk Nieuwkamp May 16, 2022 6:21AMAsk A Guru
Workbook/Datataset formula fields - time operations

Michal Hrncirik-Oracle 21 views 5 comments 2 points Most recent by Petr Maly-Oracle May 5, 2022 8:51AMSuiteAnalytics Workbook
How do you find the Quantity Remaining from an Item Receipt (in saved search form)?

Answered ✓ 3ric 1 view 3 comments 0 points Most recent by Joy Noreen Magoling-Oracle Mar 23, 2022 1:54AMAsk A Guru
Extract time from date time field and store result as time

Answered ✓ Vernita 11 views 5 comments 0 points Most recent by Katerina Winklerova-Oracle Mar 11, 2022 5:48AMSearch / Reporting
Extract time from date time field and store result as time

Answered Closed Vernita 1 view 1 comment 0 points Most recent by Katerina Winklerova-Oracle Mar 11, 2022 4:20AMSearch / Reporting
EMPLOYEE SAVED SEARCH | Exposing First and Last Name / Employee ID using a Formula

Micah Timbol-Oracle 1 view 0 comments 0 points Started by Micah Timbol-Oracle Feb 16, 2022 9:09PM Search / Reporting
Number of work days shipment completed

Answered ✓ User_RHKAB 11 views 9 comments 0 points Most recent by Ivy Lopez-Oracle Feb 15, 2022 10:34PMAsk A Guru
Item Receipt vs. PO Line Data Formula (Inventory Detail Status)

Answered ✓ jmack_admin 11 views 4 comments 0 points Most recent by jmack_admin Jan 26, 2022 2:12PMAccounting / ERP
Suiteanalytics summarize calculated measure with a max value being used

Answered User_FHV73 31 views 9 comments 0 points Most recent by Kristoffer Viray-Oracle Jan 14, 2022 10:37PMAsk A Guru
Displaying item quantity in transaction returns an error in saved search results

Answered ✓ BM136 1 view 5 comments 0 points Most recent by BM136 Jan 10, 2022 9:31PMAsk A Guru
Formula to extract string from entity name

Answered ✓ Vernita 11 views 5 comments 0 points Most recent by Ivy Lopez-Oracle Dec 1, 2021 10:11PMSearch / Reporting
Saved Search formula - difference between internal ID, numeric and custom field that is text value

Answered ✓ User_FZNHI 1 view 2 comments 0 points Most recent by Ivy Lopez-Oracle Nov 11, 2021 4:50AMAsk A Guru
Formula for sum of Available Inventory in 2 locations

Answered ChrisH 21 views 9 comments 0 points Most recent by Ivy Lopez-Oracle Oct 20, 2021 8:12PMAsk A Guru
Amount (debit) minus Amount (credit) issues

Answered ✓ timblun 11 views 5 comments 0 points Most recent by Micah Timbol-Oracle Oct 4, 2021 9:46AMAsk A Guru
Calculate total hours

Answered ✓ Toanne Termeer - van de Ven 11 views 5 comments 0 points Most recent by Toanne Termeer - van de Ven Sep 29, 2021 6:42AMAsk A Guru
Amount (debit) minus Amount (credit) issues

Question Closed timblun 12 views 0 comments 1 point Started by timblun Sep 27, 2021 8:59PM Ask A Guru

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders

.logo { width: 120px; height: 28px; opacity: 0.6; } .header-container { height: 50px; background: #302D2A; } .logo-container { position: absolute; display: flex; color: #fff; left: 130px; top: 10px; } .logo-container p { margin: auto; padding-left: 20px; } .titleBar-button_fmuucnv.titleBar-button_fmuucnv, .titleBar-button_fmuucnv.titleBar-button_fmuucnv:hover:not(:disabled), .titleBar-button_fmuucnv.titleBar-button_fmuucnv:focus, .titleBar-button_fmuucnv.titleBar-button_fmuucnv:focus:not(.focus-visible), .titleBar-button_fmuucnv.titleBar-button_fmuucnv:active:not(:disabled), .titleBar-button_fmuucnv.titleBar-button_fmuucnv.isOpen, .titleBar-button_fmuucnv.titleBar-button_fmuucnv.isOpen:focus, .titleBar-button_fmuucnv.titleBar-button_fmuucnv.isOpen.focus-visible { color: #fff !important; } .footbar-container { height: 80px; } .footbar-subcontainer { position: relative; height: 80px; background: #CEAA8F; display: flex; align-items: center; justify-content: center; } .footbar-subcontainer p { color: #302D2A; font-size: 20px; margin-right: 10px; } body { font-family: Oracle Sans; } .About.P { background-size: cover; background-image: url(https://us.v-cdn.net/6032253/uploads/815/QURW3A01AKVP.png) } body.Section-Profile .ProfileOptions .ButtonGroup a { background: #302D2A; border-radius: 50px; color: #fff; } body.Section-Profile .Profile dd, body.Section-Profile .Profile dt { color: #100F0E; } .BreadcrumbsBox .Breadcrumbs a { color: #302D2A; font-family: Oracle Sans; } .BreadcrumbsBox { max-width: 1264px; padding-left: 40px; padding-right: 40px; margin: 0 auto; } .ReactionsWrap.H { color: #100F0E; font-weight: 800; } body.Section-Profile .CountItemWrap { width: 95px; margin: 14px; } body.Section-Profile .CountItemWrap .CountTotal { color: #A1ADAF; font-family: Oracle Sans; font-style: normal; font-weight: normal; font-size: 48px; } body.Section-Profile .CountItemWrap .CountLabel { font-family: Oracle Sans; font-style: normal; font-weight: normal; font-size: 16px; } .BoxFilter ul.FilterMenu li.Active a{ background: #302D2A; color: #fff; padding: 5px; } .BoxFilter ul.FilterMenu li a{ font-family: Oracle Sans; font-style: normal; font-weight: 600; font-size: 17px; color: #41727E; } @media screen and (max-width: 768px) { .logo { margin: 0 auto; } } @media screen and (max-width: 480px) { .footbar-container { height: auto; } .footbar-subcontainer { display: block; height: auto; } .footbar-subcontainer p { font-weight: bold; font-size: 26px; line-height: 34px; color: #fff; padding: 20px; } } .logo { width: 120px; height: 28px; opacity: 0.6; } .header-container { height: 50px; background: #302D2A; } .logo-container { position: absolute; display: flex; color: #fff; left: 130px; top: 10px; } .logo-container p { margin: auto; padding-left: 20px; } .footbar-container { height: 80px; } .footbar-subcontainer { position: relative; height: 80px; background: #6B9869; display: flex; align-items: center; justify-content: center; } .footbar-subcontainer p { color: #FFF; margin-right: 10px; font-family: Oracle Sans; font-style: normal; font-weight: bold; font-size: 20px; line-height: 26px; display: flex; align-items: center; text-align: right; color: #FFFFFF; margin: 20px 20px; float: left; clear: both; } .About.P { background-size: cover; background-image: url(https://us.v-cdn.net/6032253/uploads/815/QURW3A01AKVP.png) } body.Section-Profile .ProfileOptions .ButtonGroup a { background: #302D2A; border-radius: 50px; color: #fff; } body.Section-Profile .Profile dd, body.Section-Profile .Profile dt { color: #100F0E; } .breadcrumb-container .BreadcrumbsBox .Breadcrumbs a { color: #FFFFFF !important; } .BreadcrumbsBox .Breadcrumbs a { color: #302D2A; font-family: Oracle Sans; } .ReactionsWrap.H { color: #100F0E; font-weight: 800; } body.Section-Profile .CountItemWrap { width: 95px; margin: 14px; } body.Section-Profile .CountItemWrap .CountTotal { color: #A1ADAF; font-family: Oracle Sans; font-style: normal; font-weight: normal; font-size: 48px; } body.Section-Profile .CountItemWrap .CountLabel { font-family: Oracle Sans; font-style: normal; font-weight: normal; font-size: 16px; } .BoxFilter ul.FilterMenu li.Active a{ background: #302D2A; color: #fff; padding: 5px; } .BoxFilter ul.FilterMenu li a{ font-family: Oracle Sans; font-style: normal; font-weight: 600; font-size: 17px; color: #41727E; } @media screen and (max-width: 768px) { .logo { margin: 0 auto; } } @media screen and (max-width: 480px) { .footbar-container { height: auto; } .footbar-subcontainer { display: block; height: auto; } .footbar-subcontainer p { font-weight: bold; font-size: 26px; line-height: 34px; color: #fff; padding: 20px; } }