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
-
Thanks for the quick revert, @Tybrneryan! I was able to come up with a saved search for your requirement but we need to use MS Excel or something similar in order to Pivot the results. This is because the formula I used contains a window function DENSE_RANK() which is allowed only in conjunction with a SELECT list of…
-
Hi @Tybrneryan, I am currently testing this on my account, and I just wanted to know if you need the dates from a specific type of transaction? Like Item Fulfillment perhaps? Or is it just any transaction?
-
Hi there @User_6YI1X, Glad to have you with us today and thank you for posting another question here in our community! Allow me to tag our Gurus who may be able to help you out with your concern: @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Kristoffer Viray-Oracle, any ideas about this one? To our other members,…
-
Hi @Pervaz R. Allauddin, What are you doing to copy the search from Sandbox to Production? Have you tried to recreate the search in Production from scratch, then just copy the formula? Are there any renamed records in Production? Also, can you share a screenshot of the exact error message that you receive?
-
Hi @User_8B06I, You're welcome! We're always glad to help! ? If it's not too much trouble, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment that helped in your concern. This will also help other community members who might have the same concern find the answer easier.…
-
Hi @User_8B06I, I tested this one on my test account, but was unable to reproduce the behavior you mentioned. Only 1 PO is created on my end. I further checked on this, and found other SuiteAnswers article that may help: 71840 - Drop Ship Sales Order created two Purchase Orders 34057 - Requirements to Create One Drop Ship…
-
Hi there @User_8B06I, Welcome to the community and thank you for posting your concern here! ? Can you please check what type of items are in the PO? Are they Inventory Items or Non-Inventory Items? Also, are these Special Order items or Drop Ship items? You may also want to check SuiteAnswers 18557: A Sales Order with two…
-
Hi @Alexsandro_Brazil_Oracle, Thank you for posting your concern here in the community! I checked on this one and it seems like this is a known system limitation and there is an existing enhancement logged for this: Enhancement # 173819: OneWorld:Setup > Accounting > Accounting List > New > Term. Customer is requesting for…
-
Hi @Martha Hakes, Thank you for posting another question here in our community! ? Allow our gurus some time to check on this one for you and we'll get back to you with our findings. To our other members, feel free to comment your insights and ideas on this thread!
-
Hi @HoJo, The Last Purchase Price field in the item record is a read-only field that displays the most recent purchase price of the item. This price is determined by the most recent transaction for the item that added positive inventory, such as a purchase receipt, inventory transfer or inventory adjustment. (This does not…
-
Hi @User_N5LAE, Welcome to the community and thank you for posting your concern here! Let me tag our Gurus who have the expertise on this one: @Erick Dela Rosa-Oracle / @Mikko De La Fuente-Oracle, any ideas? To our other members, feel free to share your insights and suggestions as well.
-
For this one, based on the screenshots you sent, the item has different values under the "TRN OR PUR" column which is why it shows up as different lines.
-
One possible reason this might be happening is because the custom role does not have permissions to view some of the records specified in the criteria/results. To resolve this, mark the Run Unrestricted checkbox under the Results tab. As per field help of the Run Unrestricted: Check this box to make search results…
-
Try these instead: # to Order Both | Maximum: (SUM(CASE WHEN {transaction.location} = 'Edmonton Warehouse' THEN NVL({transaction.quantity},0) ELSE 0 END) + MAX(CASE WHEN {transaction.location} = 'Edmonton Warehouse' THEN NVL({locationsafetystocklevel},0) ELSE 0 END) + MAX(CASE WHEN {transaction.location} = 'Edmonton…
-
Hi @Dallas H, Since you do not have it grouped by Inventory Location, then you can try these formula: To Order (EDM): (SUM(CASE WHEN {transaction.location} = 'Edmonton Warehouse' THEN {transaction.quantity} ELSE 0 END) + MAX(CASE WHEN {transaction.location} = 'Edmonton Warehouse' THEN {locationsafetystocklevel} ELSE 0 END)…
-
Hi Dallas, I did try the formula you provided and it worked for me. I did not get any error. Can you try it again? (SUM(CASE WHEN {transaction.location} = 'Edmonton Warehouse' THEN {transaction.quantity} ELSE 0 END) + MAX(CASE WHEN {transaction.location} = 'Edmonton Warehouse' THEN {locationsafetystocklevel} ELSE 0 END) +…
-
Hi there @WillHendrick, Glad to have you back with us and thank you for posting your concern here in the community! ? I checked my resources about your concern, and it seems like setting Available Filters Fields as a Criteria of Saved 'Saved Search' Searches is not yet possible in the system. I also tried looking for…
-
Hi @Tom Dalton, Thank you for posting another question here in the community! ? The only preference related to the behavior that you mentioned is the Invoice in Advance of Fulfillment preference under Accounting Preferences > Order Management > Invoicing. However, this is not affected by the type of item in the order.…
-
Hi @Dan Moldover, Thank you for posting your concern here in our community! Allow our gurus/members some time to check this for you. Also tagging @Patrick Fresnosa-Oracle who will be helping you out on this one. To our other members, feel free to share your insights as well.
-
Hi @User_SZ0C3, Thank you for posting your concern here in our community! Allow our gurus/members some time to check on this for you, and we'll get back to you with our findings. Tagging my colleagues who will be able to assist you on this one: @Ely Gulen-Oracle / @Dominica Sevilla-Oracle, any ideas? To other members, feel…
-
Hi @Janis001, Was the information provided in my previous comment helpful to your concern? If it was, then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment. This will also help other community members who might have the same concern find the answer easier. Hope you…
-
Hi @User_QG2Y6, Were you able to test the solution provided in my previous comment? If it was helpful to your concern, then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment. This will also help other community members who might have the same concern find the answer…
-
Hi @Neo_Suite, Were you able to test the solution provided in my previous comment? If it was helpful to your concern, then we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment. This will also help other community members who might have the same concern find the answer…
-
Hi @KNason76, I have tested this on my account and confirmed that the Master Default box was checked when the Overwrite Sublists option was checked. As an example, here's an Assembly Item with a BOM: CSV Import steps: Once the import was finished, the Master Default checkbox is now marked in the item record:
-
Thanks for providing the detailed steps, @John Griffin! I tried this on my account and I can confirm that this works. I looked back on the previous test that I did and realized my mistake -- the Overwrite Missing Fields option was checked. Also, hardcoding <NULL> in the Import Assistant results in an error so it would be…
-
Hi @User_SQQ29, Unfortunately, I could not find any documentation about your specific requirement. You may want to reach out to your account manager to confirm with Professional Services team if this is possible in customization of the WMS Mobile App. Apologies for the limited help we can offer.
-
Hello everyone! Our engineers are still working on the solution for this one. We'll make sure to keep you posted on any update and you can also check the NetSuite Status Page. We apologize for the inconvenience.
-
Hi @Pervaz R. Allauddin, Try this: MAX(CASE WHEN {applyingtransaction.type} = 'Work Order Issue' THEN {applyingtransaction.datecreated} END) - MAX(CASE WHEN {applyingtransaction.type} = 'Work Order Completion' THEN {applyingtransaction.datecreated} END) Note that this should be entered in the Summary subtab of the…
-
Hi @User_SQQ29, Have you checked the articles provided in my previous comment? Let us know if you need further assistance on this.
-
Hi @Dallas H, Were you able to test this out? Let us know if you need further assistance on this.