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 everyone! I'm Ivy, one of the gurus handling Supply Chain Management (including Manufacturing and WMS) concerns. I have been with NetSuite since January 2019, and I have been in this community since November 2020. Aside from answering your questions here in the community, I am also a part of the Gamification Improvement…
-
Hi @Toanne Termeer - van de Ven, Kindly check the replenishment method of the items affected. As per SuiteAnswers 28200: Work orders generated for assembly items that use the Reorder Point replenishment method use Forward Scheduling. This is true regardless of the default scheduling method set in the account preferences. I…
-
Hi there @Toanne Termeer - van de Ven, Glad to have you with us today! ? The difference between the On Hand Qty and the Avaiilable Qty is the Committed Qty. You can check the Committed Qty per item in the following reports: Current Inventory Status report This report provides a snapshot of real-time inventory data. It…
-
Hi @Keith Boatner, Thank you for being with us today and for posting your concern here in our community! I checked this as well on my test account and noticed the same behavior that the Cycle Count Plan page was renamed to WMS Cycle Count Plan. However, the Generate Cycle Count was still visible when I went to my Warehouse…
-
Hi Thusi, I have coordinated this internally with our experts and here are the steps you can try: Go to Reports > Management > Tabular > Account-wide Users. Add these reporting values: User - Name User - Loaded cost [Loaded cost rate] (Current) Set filters as needed. Run the report. where: Burden Rate is = Loaded cost rate…
-
Hello Thusi, Glad to have you with us today and thank you for posting your concern here in our community! One of the gurus will help check this with you and reach out to you soon. To everyone, feel free to share your insights about this one.
-
Hi there @User_TR2J2, Welcome to the community! We are glad to have you here with us! ? Regarding the concern, let's see if any of our members are using the 'Purchase to Project' SuiteApp as well. I'll be tagging my colleagues @Patrick Fresnosa-Oracle and @Micah Timbol-Oracle who are our experts in Projects. Also tagging…
-
Hi @Daniel V, The ability to select the currency when Mass Updating Item Prices is not yet possible in the system and is logged as Enhancement # 125499. You can vote for this enhancement in the SuiteIdeas page. However, updating the item prices for only a single currency is possible via CSV Import. You can check these…
-
Glad I was able to help, Martha! ? Thank you for your input on this @kmd_14170! Let's see if our other members have a similar process they can share with us.
-
Hi @Philip Walklett, Have you tested the solution provided in my previous comment? If you did and it worked for you, then 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…
-
Hi @MSStoke, You could try creating a support case for this, so it can be further investigated. But before that, you can try the following and check if the behavior changes: Try using location 31 first in the search Try creating a new search from scratch Remove the apostrophes in the inventorylocation.id. example:…
-
Thanks for the update, Colleen!
-
Hi @MSStoke, The saved search works fine on my account, it shows quantities in both locations in only a single search. You can try to create this transaction saved search to check which items have Sales Orders within last month. Criteria tab: Results tab: Then check your item saved search if there are quantity sold for the…
-
Hi Myren, Yes, we can use {inventorylocation.id} instead of {transaction.location}. Here are the revised formula you can try: Location Qty Sold: CASE WHEN {transaction.location} = {inventorylocation} AND {inventorylocation.id} = '1' AND {transaction.type} = 'Sales Order' THEN {transaction.Quantity} ELSE 0 END Location…
-
Hi @Martha Hakes, This criteria caught my eye: Fulfilling/Receiving Transactions : Date is empty OR Fulfilling/Receiving Transactions : Date is within this month On the system notes, the document status was changed to Partially Fulfilled on 9/29/2021 (which is not within this month of October). Maybe this is the reason why…
-
Hi @User_82RRL, Glad to have you back with us today and thank you for posting your concern here in our community! Tagging my colleague @Leonard Mallare-Oracle who has the expertise on this. Anyone else with insights on this? Feel free to share them in this thread!
-
Thanks for the update, Chris!
-
Hi @ChrisH, Kindly try these formula: CASE WHEN(((CASE WHEN NVL({inventorylocation},0) = 'Location # 1' THEN {locationquantityavailable} ELSE 0 END) + (CASE WHEN NVL({inventorylocation},0) = 'Location # 2' THEN {locationquantityavailable} ELSE 0 END))-5) > 0 THEN (((CASE WHEN NVL({inventorylocation},0) = 'Location # 1'…
-
Hi there @User_6YI1X, Have you tested the workaround I provided in my previous comment? If you did and it worked for you, then 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…
-
Hi @CDuf, Glad to have you with us today and thanks for creating another thread here in our community! ? I checked this as well in my standard test account, but was unable to find the feature for NetSuite Analytics Warehouse. It would be best to reach out to your account manager as this feature is something that needs to…
-
Hi there @Vernita, Thank you for creating another thread here in our community! ? Allow our gurus/members some time to check on this one. Let me also tag my colleagues who may be able to help out on this one: @Dominica Sevilla-Oracle / @Shamaine Chan-Oracle / @Patrick Fresnosa-Oracle / @Micah Timbol-Oracle, any ideas that…
-
Hi @paula.courtemanche, I got the below details in the Oracle NetSuite Support Community Inbox: we are testing now and tweaking our process but this looks like it will work perfectly. I will respond yes tomorrow when I am online. For future communication, it would be better to reply to this thread instead of replying via…
-
You're welcome, @MSStoke! Glad I could help! ? By the way, it would be great if we will be able to recognize you through your profile picture. By uploading a profile picture, you can earn the Photogenic badge and earn points too. You may check Community Tip: Updating Your Profile to know how. Have a great day! -Ivy
-
Hi Philip, You can try adding an Alternate Date Range for the columns: You can check SuiteAnswers 8341 for more information on this. Hope this helps! -Ivy ========================= 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…
-
Figured out why this behavior is happening. The search is not pulling the quantity available if there are no transactions for the item during the date range that you specified. Anyway, kindly try these formula (also added a formula for returns and total sales): Location Qty Sold: CASE WHEN {transaction.location} =…
-
Is the behavior is still the same if you remove the custom field in the criteria?
-
Are there any other criteria you have in your search? Can you share the Criteria tab of your search as well?
-
Thanks for providing the screenshots, @MSStoke! At first glance, I noticed that an apostrophe (') is missing in the formula. It should be 'Location B' Can you provide an example item please? What is the expected results and what is the actual value in the results of the search?
-
Hi @MSStoke, What do you mean by "when I add to locations it doesn't seem to work"? Are you adding a new column for the 2nd location data or does the data need to be in one column only? Like (location A qty + location B qty)? You can also provide some screenshots of your Criteria tab and Results tab. You can also show us…
-
Hi @MSStoke, Kindly try these on your Item Saved Search: Criteria tab Formula (Numeric): CASE WHEN {inventorylocation} = {transaction.location} THEN 1 ELSE 0 END For the transaction date, select the date range Results tab Formula used: Location Qty Sold: CASE WHEN {transaction.location} = 'Location # 1' AND…