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 @User_MC441, I agree with @John Griffin that the CSV Import for negative and positive adjustments should be done separately. Additionally, can you try using the Internal ID of that Inventory Status instead of the name? You can find the Internal ID by checking Lists > Supply Chain > Inventory Statuses. Then make sure to…
-
That is correct. Based on my testing, when I try to set the BOM to blank/null, I get this error message: Please enter value(s) for: Bill of Materials I did some further research about this but I could not find any documentation about unlinking or removing BOMs from Assembly Items by bulk. However, I tested it on my test…
-
Hi @KNason76, I think the one of the comments in your previous post is applicable to this one: Based on my testing, you would first need to disassociate the BOM with the Assembly Item. To do this, a CSV Import for the Assembly Item is needed to be done first. Here's my sample Assembly Item: Notice that it has only 1 BOM…
-
Hi there @User_RHKAB, I did some tests on my account and here's the formula I came up with: Formula (Numeric): CASE WHEN (ROUND(({actualshipdate}-{datecreated})/7*5 + MOD(ROUND({actualshipdate}-{datecreated}), 7)) - (CASE WHEN TO_NUMBER(TO_CHAR({actualshipdate},'D')) < TO_NUMBER(TO_CHAR({datecreated},'D')) THEN 2 ELSE 0…
-
Hi @NitinEOH, Per checking, there is currently no way to automatically calculate and update the Item Classification field. I did find an enhancement request related to this which you can vote for on the SuiteIdeas page: Enhancement # 610991 : WMS > Ability to auto calculate and populate the Item Cycle Count ABC…
-
Hi there @Jay Schwausch, Glad to have you back with us today and thanks for posting your question here in our community! You are right that there is a character limit in formula fields. There is an enhancement related to this one: Enhancement # 287420: Saved Searches > Formula Fields > Increase the character Limit…
-
HI @eleran, Did we help in your concern? If you have clarifications related to this, let us know. -Ivy
-
Hi @Tom Dalton, It is standard behavior of the system that 1 Work Order will be created per item line in the Sales Order. So if you have a dozen line items in the Sales Order, there will also be a dozen Work Orders created, even if it is the same item. However, if you only have 1 line item in the Sales Order, but for 12…
-
Here's the Criteria and Results tab of the search I tested: Results page: Note that if you run this search, it can only show the total completed quantity per Work Order. As mentioned, it is still an enhancement to get the value of the fields per Work Order Completion.
-
Hi @User_8P1E0, I tried this on my test account and was able to reproduce the same behavior. Upon further checking, it seems that this is currently a system limitation and is logged under Enhancement # 252217. You can vote for the enhancement on the SuiteIdeas page. If the search criteria has Type = Work Order Completion,…
-
Hi @jmack_admin, Does the Item Receipt have a GL Impact? If not, then this behavior might be related to the Generate Accruals Preference on Non-Inventory Items. You can watch this video to learn more about the behavior and how to resolve it: Hope this information helps! ? If it did. then we would greatly appreciate if you…
-
Hi there @Tlarkin, Glad to have you with us today and thank you for posting another question here in our community! I checked on this and it seems your requirement is not yet possible. I did find an existing enhancement requesting for this functionality: Enhancement # 456523 : Automatic Location Assignment = T > Default…
-
Hi @Biomerics_Admin, Thanks for creating another thread here in our community! ? Tagging our gurus who will be assisting you in this one: @Dominica Sevilla-Oracle / @Ely Gulen-Oracle, any ideas? To our other members, feel free to comment your insights here as well!
-
Hi @eleran, I agree with @John Griffin's answer. You can set the Primary Purchase Unit in the Item Record, and you can also set the Purchase Price per Vendor. The Purchase Price you enter should be based on the Purchase Unit. Then, when you create a PO, the Purchase Unit will default and the Purchase Price will depend on…
-
Hi @Asher_123, This can be done in either an Item Saved Search or a Pricing Saved Search. You need to use the Formula: Item Search = CASE WHEN {pricing.pricelevel} = 'Name of Price Level' THEN {pricing.unitprice} ELSE 0 END Pricing Search = CASE WHEN {pricelevel} = 'Name of Price Level' THEN {unitprice} ELSE 0 END Here's…
-
Hi Oliver, I think the simplest way to know if you are using OneWorld is if you are using Subsidiaries. Anyway, I'm glad I could help! Have a great day as well! ? -Ivy
-
You can submit a Support Case for it to be further investigated on your account.
-
Hi @davidd039, Do you still need help with this? We'll be waiting for the requested information in my previous comment.
-
Hi @OliverK, Are you using a OneWorld account? It seems that for OneWorld accounts, the ability to set a beginning Quantity on Hand for new Items is not possible and this is by design. This feature is currently filed as Enhancement # 169533: OneWorld > Items > Allow entering an initial quantity on hand per location. I…
-
Hi @User_QG2Y6, If that preference is already blank, then you can check if there are any scripts or workflows deployed on your account that may be causing this behavior. If there are none and you are still having this warning, then I recommend filing a Support Case so this can be further investigated in your account.
-
Hi @User_6YI1X, Were you able to check this? If the information provided in my previous comment was helpful. 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…
-
Hi @phbryan, Try this formula: (TO_DATE(TO_CHAR({custbody_rfs_endtime}, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') - TO_DATE(TO_CHAR({custbody_rfs_starttime}, 'YYYY-MM-DD HH24:MI:SS'), 'YYYY-MM-DD HH24:MI:SS')) Hope this information helps! ? If it did. then we would greatly appreciate if you can click "Yes" on “Did…
-
Hi @User_QG2Y6, There is a preference for this called Days Before Lot Expiration Warning. You can find this under Setup > Accounting > Accounting Preferences > Items/Transactions > Inventory. If you want to turn off the pop up warnings/alerts, then you need to set the preference to blank. However, note that since this is…
-
Hi @davidd039, Please note that we have deleted the screenshots you initially provided since they contained your account number. Moving forward, please redact/hide/crop sensitive information like this. Anyway, regarding your concern, can you specify what you mean by "only show the items which have additional inventory in a…
-
Hi @Aman Mirza, I'm glad that this worked for you! ? By the way, you can set your Notification Preferences in your Profile page so you will always be notified when someone answers or comments on your posts. Hope you have a great day! -Ivy ----- Your experience can help others make informed decisions about technology.…
-
Hi @OliverK, Thanks for the update! I'm glad that the search is now working as you need it to. ? Hope you have a great day! -Ivy ----- Your experience can help others make informed decisions about technology. Complete a NetSuite product review on G2 in less than 5 minutes and G2 will provide a $20 Visa.com gift card (while…
-
Thanks for clearing that up! I tested this on my account and was able to get it by using Applied to Transaction: Ship Via. Here's what my search looks like: Criteria Tab: Results Tab: Results page: Here's the item line of the Sales Order: -Ivy ========================= If you find this reply to your question as helpful,…
-
Glad it worked for you! ? By the way, it would be great too if you can update your profile with your User Name, Profile Picture, and Support Type. To know how, visit Community Tip: Updating Your Profile!
-
There is no known workaround for this since Item Fulfillment transaction is not exposed yet for CSV.
-
Yes that is correct.