Hi, I would like to create a saved search on the invoice with the following fields on the results. I was able to create until formulas and unable to write the formulas correctly for the formula fields. Please help me with this. * A Invoice number * B Invoice Date * C Invoice Date Created * D Date Invoice was emailed out to the customer * E Invoice amount * (if we can) - the formula of C - B * (if we can) - the formula of D - B * (if we can) - the formula of D - C Thanks

Hi @Jyothi R, You can use the formula round({trandate} - {createddate}, 0)+1 as a template. Kindly substitute the fields below using the field IDs on your requirement: * Formula (Text) | round({B} - {C}, 0)+1 | Age in Days * Formula (Text) | round({D} - {B}, 0)+1 | Age in Days * Formula (Text) | round({D} - {C}, 0)+1 | Age in Days Let me know if this works! Kind regards, @Shamaine Chan-Oracle

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Child Item

Ask A Guru

Child Item

Home
Groups

Child Item

Need help with created a saved search using formula fields

Jyothi B

Hi,

I would like to create a saved search on the invoice with the following fields on the results. I was able to create until formulas and unable to write the formulas correctly for the formula fields. Please help me with this.

A Invoice number
B Invoice Date
C Invoice Date Created
D Date Invoice was emailed out to the customer
E Invoice amount
(if we can) - the formula of C - B
(if we can) - the formula of D - B
(if we can) - the formula of D - C

Thanks

Find more posts tagged with

invoice

Component react.asset.answerThread had an error.

You are not allowed to view comments.

Child Item

Upcoming Events

SuiteWorld | October 25–28, 2026 | Las Vegas
Big ideas. No travel required. SuiteWorld On Air brings the best of SuiteWorld directly to you. Stream keynotes live, access exclusive virtual content, and connect with the NetSuite community from wherever you are. Explore what's next for NetSuite, see AI innovation in action, and discover practical insights designed to…
Learning Lab | DC
Drive better outcomes with AI built into NetSuite Next Capital Hilton,1001 16th St NW, Washington, DC 20036 Join NetSuite experts for a free half-day event where you'll get a tour of NetSuite Next, explore AI-powered capabilities built into the platform, and learn practical ways to optimize NetSuite for your business. At…
Inside the Suite | DC
Take NetSuite Next for a hands-on test drive Capital Hilton, 1001 16th St NW, Washington, DC 20036 What to expect: Inside the Suite is designed for companies exploring modern ERP solutions. This event gives you the opportunity to experience NetSuite Next - the next evolution of NetSuite that brings AI directly into how…
What's Next for Product Companies with NetSuite
WEBINAR What's Next for Product Companies with NetSuite See how NetSuite Next uses AI to improve accuracy and protect margins Ask. Understand. Act. Use Ask Oracle to search, navigate, analyze business data, surface insights, get guidance, and take action using natural language—all through a single conversational…

More events