Mi contenido
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Celebrate Your 2025 Community Recap & Achievements!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
Staying Connected During the Holidays
Season’s greetings to you and yours! As we head into the holidays (December 24 – January 4), we want to take a moment to celebrate the incredible strength and collaboration within our community. Even during the break, you can continue to benefit from connecting with peers, searching related threads, posting your questions, and marking helpful replies as “Accepted” in the Support Community.
Please note our dedicated team will be on reduced coverage during this time, and regular responsiveness will resume on January 5. Wishing you a joyful and restful holiday season!
-The NetSuite Support Community Team
Season’s greetings to you and yours! As we head into the holidays (December 24 – January 4), we want to take a moment to celebrate the incredible strength and collaboration within our community. Even during the break, you can continue to benefit from connecting with peers, searching related threads, posting your questions, and marking helpful replies as “Accepted” in the Support Community.
Please note our dedicated team will be on reduced coverage during this time, and regular responsiveness will resume on January 5. Wishing you a joyful and restful holiday season!
-The NetSuite Support Community Team
Comentarios
-
Hi @Dwight Schrute, There are resources about Supply Chain Control Tower in SuiteAnswers. Here are some links to videos and articles that may help: 70351 - Supply Chain Control Tower 70352 - Set Up the Supply Chain Control Tower Feature 70353 - Generating a Supply Chain Snapshot 82609 - Customizing a Snapshot Form 68875 -…
-
You're welcome, @Dwight Schrute. Glad I was able to help! ?en Search Formula > Count Days Excluding Weekend Comentario por Ivy Lopez-Oracle Apr 14, 2022 3:18PM
-
Hi @Martha Hakes, You can use the Applying Transaction joining fields to get the information from the PO/WO linked to the Sales Order, but if the POs/WOs are not linked, then we can't get that information. Anyone else have ideas or suggestions for a possible workaround for this one? Let us know by commenting on this thread.
-
Hi @Dwight Schrute, Please try the formula I provided in my previous comment. I noticed that it's not the one that you had in your screenshot. Thanks.
-
Hi again @Martha Hakes, Per checking my resources on this one, it seems that this field is not yet available for reports/saved searches. This system limitation is logged under Enhancement # 258217 which you can vote for in the SuiteIdeas page. For a possible alternate solution, you can refer to SuiteAnswers 34441. Hope…
-
Hi @jmack_admin, Glad to have you with us today and thank you for posting your question here in our community! Allow our gurus/members to check this for you and we'll update you with our findings. To our other members, feel free to comment your insights/suggestions about this as well.
-
Hi there @Martha Hakes, Glad to have you with us today and thanks for posting your concern here in our community. Allow our gurus/members to check this for you and we'll update you with our findings. To other members, feel free to comment your insights on this one as well.
-
Hi again @Dwight Schrute, Please try this formula: ROUND(((TO_CHAR((CASE WHEN {datecreated} > {trandate} THEN {datecreated} ELSE {trandate} END), 'J') - TO_CHAR((CASE WHEN {datecreated} < {trandate} THEN {datecreated} ELSE {trandate} END), 'J'))) + MOD(((CASE WHEN {datecreated} > {trandate} THEN {datecreated} ELSE…en Search Formula > Count Days Excluding Weekend Comentario por Ivy Lopez-Oracle Apr 13, 2022 5:53PM
-
Hi there @Dwight Schrute, I have split your comment to a new thread, since this requires further testing and investigation. I did notice on your excel file that the date created is usually after the transaction date. Note that the formula provided below will work as expected only when the start date is before the end date:…en Search Formula > Count Days Excluding Weekend Comentario por Ivy Lopez-Oracle Apr 13, 2022 5:25PM
-
Hi @Dwight Schrute, Glad you were able to figure it out, and thank you for keeping us updated. ? I have marked your latest comment as the correct answer for this thread to help other members who might encounter the same scenario.
-
Hi @Camila O, Glad to have you with us today and thank you for posting your question here! Kindly allow our gurus/members some time to check this one for you and we will get back to you with our findings To other members of the community, feel free to share your insights on this one as well ?
-
Hi @Dwight Schrute, If your startdate = {datecreated} and enddate=nvl({trandate},{today}), then you just substitute these in the formula. You will come up with something like this: ROUND(((TO_CHAR(nvl({trandate},{today}), 'J') - TO_CHAR({datecreated}, 'J'))) - ((((TRUNC(nvl({trandate},{today}), 'D')) -…
-
Hi @Dwight Schrute, Can you provide some examples that the results are inconsistent? One possible reason is that there are multiple Applied To Transactions, or the search is pulling information from multiple/different lines. It would be helpful if you can provide us the Criteria/Results tab of your search so we can also…
-
Hi @Rhys Gottwald, Yes, the system rule "Allow picking of expired items" is working as expected on my test accounts.
-
Hi @KNason76, Did you proceed with filing a case with NS Support? Or were you able to successfully import the CSV file? We'd appreciate it if you can keep us updated regarding this one. I'm also curious to know if there is indeed a limitation when uploading BOMs or if there's another reason why you are encountering an…
-
Hi @Rhys Gottwald, I did further tests on this one, but I was not able to reproduce the behavior you mentioned. I tried it in both the 2021.2 and 2022.1 versions of WMS. Per further checking, I did note a similar issue but has already been fixed, according to our records: Defect # 655891: WMS > Allow picking of expired…
-
Hi @User_A6IOW, Did @John Griffin's or my comment answer your question? If so, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment/s that helped in your concern. Doing so will help other community members who might have the same concern find the answer easier and you…
-
Hi @User_4G6AP, Were you able to test the solution provided in my previous comment? Let us know if it worked for you, or if you would need further assistance on this one.en Show Item's Current Location in Saved Search Comentario por Ivy Lopez-Oracle Apr 11, 2022 11:03PM
-
Hi @Alexsandro_Brazil_Oracle, To remove this warning, navigate to Home > Set Preference > unmark Inventory Level Warnings. Hope this information helps! ? If it did. then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below this comment. Doing so will help other community members who…
-
Hey there @User_3BTAC, Kindly allow our guru/s some time to check this one for you and we will get back to you with our findings. To other users who may have insights regarding this topic, feel free to add your comments by replying to this thread.
-
Hi @User_3BTAC, Thank you for posting your question here! Our gurus/members will look into your concern and reply to this thread for any updates. @Mikko De La Fuente-Oracle will be assisting you on this one. To other members of the community, feel free to share your insights as well.
-
Hi @Gabriel Jarillo Soto, Thank you for being with us today and for posting your question here! Our gurus/members will look into your concern and reply to this thread for any updates. @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Kristoffer Viray-Oracle, any ideas? To other members of the community, feel free to…en Set ATP Lead Time record with a custom record Comentario por Ivy Lopez-Oracle Apr 11, 2022 7:18PM
-
Glad I was able to help! ? You can try either one of these formula: CASE WHEN {pricing.pricelevel} = 'Name of Price Level' THEN {pricing.unitprice} ELSE NULL END CASE WHEN {pricing.pricelevel} = 'Name of Price Level' THEN {pricing.unitprice} END
-
Hi @Wendy_M, In an Item Saved Search, you can use a Formula (Currency) field with this formula in the Results tab: CASE WHEN {pricing.pricelevel} = 'Name of Price Level' THEN {pricing.unitprice} ELSE 0 END Results tab: Results page: Hope this information helps! ? If it did. then we would greatly appreciate if you can click…
-
Hi all, We also have a video about this one. You may want to check it out here: -Ivy
-
Hi @User_4G6AP, If you want the search to be filtered based on the formula you entered, then you can add the Formula (Text) to the Criteria tab and Available Filters tab: When you run the search, it will show a Text field in the Filters region and you can enter the name of the Location there. Note: In the Results tab, I…
-
Hi @Jyothi B, Maybe you can add a formula in the Criteria tab > Summary subtab: Formula: MAX(CASE WHEN {systemnotes.type} IN ('Set','Change','Unset') AND {systemnotes.role} = 'Administrator' THEN {systemnotes.date} END) - MAX(CASE WHEN {systemnotes.field} = 'Document Status' AND {systemnotes.newvalue} = 'Approved for…
-
Hi @User_A6IOW, What @John Griffin mentioned is correct. I wrote a discussion regarding this topic. Here's the link if you want to check it out: ========================= If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer…
-
Hi @Kellyann, Using Administrator role, go to Setup > Accounting > Shipping > Packages. For more information, check SuiteAnswers 101492. Hope this information helps! ? If it did. then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below this comment. Doing so will help other…
-
Hi @KNason76, As per SuiteAnswers 8069, there is a limit of 25,000 records per imported file. I checked my resources and did not find any limit specific to BOMs so it might follow the 25,000 records/lines limit in general. Hope this information helps! ? If it did. then we would greatly appreciate if you can click "Yes" on…