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 @Dirk Nieuwkamp, Work order transactions track the production of assembly items needed for stock or to fill orders. Work orders track the quantities of assemblies that need to be built and the quantities of components, or member items, needed to do so. That being said, it is not possible to add another item type to a…
-
Hi @Camila O, Thank you for posting your question here in our community! Allow our gurus/members to check this one and they'll keep you updated on this thread. To our other members, feel free to share your insights on this thread as well.
-
Hi there @dspringfield, Glad to have you with us today and thank you for posting your concern here in the community! Allow our gurus/members to check on this one and we'll update this thread for findings or if more information is needed. Also tagging @Leonard Mallare-Oracle who may be able to help you out on this one. To…
-
Hello @User_X9AE5, You can reach out to your NetSuite Account Manager to discuss training options available for you. I suggest to also check out this site to learn more about NetSuite Education Services. Another option is to attend free Webinars offered here in the NetSuite Support Community. We do have one scheduled today…
-
Hi @OliverK, Per checking, the Location Last Purchase Price is still not available on Item Saved Searches. This system limitation is tracked under Enhancement # 156755 Lists> Search> Saved Searches> Item: Show Last Purchase Price on each location as can be seen on item record as opposed to most recent receipt/cost at any…
-
Hi @Dwight Schrute, Good idea, but since there is no standard System Notes recorded for any change, your requirement might be difficult to accomplish. You may contact your developers or your Account Manager for possible engagement with our Professional Services team for this customization.
-
Thanks for your understanding. Unfortunately, it is not possible with just a formula in a saved search that is based on the value from the location sublist of the item record. If anyone else has ideas or insights regarding this one, feel free to comment on this thread.
-
Hi @Sankar Ganguri, Per checking, it seems that this is not possible using formulas if the source is the location lead time. Since if we use the Location Lead Time field in the formula, it can only pull the data from that specific inventory location. For you to accomplish your requirement, you would need to have a custom…
-
Hello @Dwight Schrute, I checked my resources on this one and it seems that it is not yet possible to track the history of the prices in the vendors sublist. This is requested in Enhancement # 150314: Multiple Vendors: Lists > Items -- Track changes made to multiple vendor machine fields. Preferred Vendor Purchase Price -…
-
Hi @Paul Reading, I was able to do some further tests and came up with this formula: CASE WHEN (LENGTH({name})-LENGTH(REPLACE({name},':','')))=3 THEN '         ' || REGEXP_REPLACE({name},'.*: ',' ') WHEN (LENGTH({name})-LENGTH(REPLACE({name},':','')))=2 THEN…
-
Got it. Allow me to test this further and try to come up with a formula for your requirement.
-
Hi @Betsy Vance, Thanks for the update. For other members who might have the same question, you may refer to SuiteAnswers 75343.
-
Hi @Paul Reading, Thanks for providing additional information. You can try this formula if it will show what you need: REGEXP_REPLACE({name},'.*: ',' ') If you want to have the spaces ( ), we'd need a slightly more complex formula, Can you confirm that there are only at most 3 levels in the hierarchy? Example: Level1:…
-
Glad I was able to help. 😊 We'd appreciate if you can click the "Yes" on the "Did this answer the question" under the comment that was helpful to your concern. This way, other members who might encounter the same can find the answer easier.
-
Hi @Paul Reading, Can you compare the Available Filters tab of the search you are working on and the search that search you have on your vendors?
-
Hi @Paul Reading, Thanks for the clarification. What I meant was that whatever text you put in the description in the filter will be treated as a text/string, not as a field. See example below: Anyway, for your requirement, try adding a Formula (Numeric) in your Criteria with this formula: CASE WHEN {customitem316} =…
-
Hey there @Paul Reading, I'm testing this out, and was curious why you need the three spaces? Anyway, I think this is possible using a combination of the REGEXP_SUBSTR and REPLACE functions. In the meantime, if you just need the last word after the last colon, then you can try this formula:…
-
Hi @Paul Reading, Can you clarify what it is you are trying to achieve here? If you put in '{customitem316.name}' in the filter, then the search treats this as a string, and not as the value of the field. Are you trying to get only the items which have a value entered on that custom field?
-
Hi @Benjamin Paul - USA, Were you able to check my previous comment? If it was able to help in your concern, kindly click "Yes" on "Did this answer the question?". This will aid the others with the same question to easily find the correct answer. You will also earn points and may unlock the Answer Accepter badge.
-
Hi @Julien Mi Electronics, Were you able to check my previous comment? Let us know if this helped or if you need further assistance.
-
Wow, awesome @Tiru Chembeti! Also noticed that you are now at the top of our All Time Leaderboards. Congratulations! 🎉
-
Hi @Benjamin Paul - USA, Generally, the cost of any inventory deducting transaction (Item Fulfillment, Standalone Invoice, Negative Inventory Adjustment) will depend on the costing method of the item. If the costing method of the item is Average Cost, then the cost of the items will depend on the current average cost. For…
-
Hi @Asher_123, The field is called Location Available: The field ID used in search formula is {locationquantityavailable}.
-
It might be possible, but there is no documentation yet on SuiteAnswers similar to your requirement so I am unable to provide you with specific steps. However, you can try to create the search from scratch or coordinate with your Account Manager for possible engagement with Professional Services team to create a search or…
-
Hi @User_YMWNR, Thank you for posting your question here in the community! Per checking, there is no standard report similar to what you described, However, I did find a related enhancement on this: Enhancement # 195421. You can vote for the enhancement request in the SuiteIdeas page. Unfortunately, there is no documented…
-
HI @Asher_123, Were you able to try my previous comment? Let us know if it worked for you or if you need further assistance.
-
Hi @User_C6XDE, Try these steps to show the Mark Open Picks Done on the Warehouse Role: Login using Administrator role Go to Customization > Scripting > Script Deployments Check Show Undeployed and sort the list by Script Name Look for WMS Mark Complete Partial Picking > Edit > check Deployed > Save After doing the above,…
-
Hi @Julien Mi Electronics, I checked this and can confirm that the Transaction record is not on available list of records to be joined to the Item Dataset. However, the Item record fields are available in the Transaction Dataset, so maybe you can use this instead to get the information that you need. See example of the…
-
Hi there @User_T9YT2, Welcome to the NetSuite Support Community! We're glad to have you with us today and thank you for posting your question here. Allow our gurus/members to check on this and we'll keep this thread updated. In the meantime, can you share some screenshots or example illustrating what exactly you want to…
-
Hi @Julien Mi Electronics, I checked this on my test account and it seems your requirement is possible if you use the correct field in the SuiteAnalytics Dataset. If you want to show the Purchase Price under the Vendors sublist of the Item Record, then you need to use the Vendor Cost field under Vendors in the Dataset…