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_QG2Y6, There is no standard report for this, but you can try getting the information that you need using a Transaction Saved Search. This is based on the saved search presented in the related discussion below, but with an added column to show the value of the lot number: Criteria tab: Results tab: Available…
-
Hi @User_QG2Y6, Currently, we can't get the cost of the lot numbers in an Inventory Numbers saved search since it is not available in the Item Record, and there are no joining fields for transactions. This is a current system limitation and is related to the enhancements that Joy mentioned in her answer in your previous…
-
Hi @Neo_Suite, Here's a simple Item Saved Search that I created on my end: Criteria tab: Results tab: Formula Used: Top-Level Parent: REGEXP_SUBSTR({name},'[^:]+') Sample Results: Try this and let me know if it's what you were looking for. If not, then please do elaborate on what you need to show on your search. -Ivy
-
Hi @Ramgopal C, Thank you for posting your question here in our community! Allow our gurus/members some time to check on this for your. Let me tag as well my colleagues who will be assisting you on this one: @Micah Timbol-Oracle / @Patrick Fresnosa-Oracle, any ideas? To our other members, feel free to comment your insights…
-
Hi @Pervaz R. Allauddin, Thanks for the clarification! Here's the Transaction Saved Search I came up with: Criteria tab: Results tab: Formula Used: Work Order Issue Document Number: CASE WHEN {applyingtransaction.type} = 'Work Order Issue' THEN {applyingtransaction.number} END Work Order Issue Date Created: CASE WHEN…
-
Hi @Janis001, I agree with @John Griffin's answer. The ability to convert inventory items to lot numbered inventory items and vice versa is not yet possible and is tracked under Enhancement # 84689. You can vote for this in the SuiteIdeas page. Here's a discussion that you might also find helpful: Also, as mentioned in…
-
Hi @Pervaz R. Allauddin, Are the 'Fulfillment Issues' and 'Fulfillment Completion' records custom records? Or are they renamed records? I am only familiar with Item Fulfillments, Fulfillment Requests, Work Order Issues and Work Order Completions. Is it related to those? Or are these custom records that are associated with…
-
Hi @Lily O, I got the below details in the Oracle NetSuite Support Community Inbox: Thank you – thank you twice You provided more information and it was extremely useful. Once finding the setup spot in NetSuite, we re-registered the UPS account with a current invoice data and it works Thank you so much. For future…en Shipping integration - UPS throwing an error Comentario por Ivy Lopez-Oracle Feb 18, 2022 11:48PM
-
Hi Dallas, Sorry if that was confusing. What I meant was, that if the Inventory Location field has the Summary Type = Group, then it will always show the results as grouped by the location. This means that the Location details will always show in separate lines, and we can't combine them together to show in a single line:…
-
Hi @Lily O, I checked on the case details and some other related cases, and I'm afraid that this particular error you are encountering can be resolved by contacting UPS. I further checked on the error (based on the submitted case), and it seems that the error is "The UserId is currently locked out, please try again in 30…en Shipping integration - UPS throwing an error Comentario por Ivy Lopez-Oracle Feb 18, 2022 11:12PM
-
Hi @User_SQQ29, You can refer to the WMS User Guide for details regarding customizing the WMS Mobile App. You can also check out the following SuiteAnswers articles: 87481 - Mobile Device Customization 87325 - Customizing Mobile Device Processes 87483 - Setting Up Additional Fields on Custom Mobile Pages
-
Hi @Dallas H, Here's the formula I came up with: (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) + MAX(CASE WHEN {transaction.location} = 'Edmonton Warehouse' THEN…
-
I think you don't need a formula for this. You can just add Transaction: Quantity as the field column, then set the Summary Type as Maximum for Highest order size and Average for Average order size.
-
Hi Dallas, Try this: SUM({transaction.quantity})+SUM({locationsafetystocklevel})-SUM({locationquantityavailable})
-
Hi @Dallas H, It's totally fine, as long as you are learning. That's what's important. ? And you're right, it is small this time. Almost too small that I needed to zoom in to your screenshots. ? Notice that in the formula for EDM Sold and CGY Sold, you used {transaction:quantity} for the field (with a colon ":") when the…
-
Hi @NetSuite4All, We do have the NS_CONCAT function which does exactly what you need. Try adding this formula in a Formula (Text) field: NS_CONCAT({item}) For this to work, the lines must be grouped, so make sure to group the lines by Internal ID or Document Number (or any other field that you need them to be grouped) By…
-
Hi @Dallas H, Just to be clear, Quantity Billed is usually associated with Purchase Orders, since this record is the one related to Bills or Vendor Bills. Since you have your transaction type set to Cash Sale and Customer Invoice, then I assume that you are referring to the quantity sold, or invoiced. If this is the case,…
-
Hi Nitin, You can create and run a report/search to get the information you need to be able to analyze and classify the inventory. But you would still need to do the analysis since there maybe a lot of factors to consider. I went over the article that you mentioned initially and it stated: You can use Microsoft Excel to do…
-
Hi Tom, Do you still need assistance on this one? Kindly provide the exact steps you did to encounter the error so we can further test and check this one out for you.
-
Hi @Dallas H, Try this Item Saved Search: Criteria tab Results tab Formula Used: SUM({transaction.quantitybilled})+MAX({locationsafetystocklevel})-MAX({locationquantityavailable}) I believe this should show the information you need, based on the initial screenshots that you provided. Let me know if this works for you, or…
-
Hi @User_RHKAB, Thank you for keeping this thread updated! I did further tests on my account and here's the revised formula that shows the expected results: Formula (Numeric) | SUM: CASE WHEN (ROUND(((TO_CHAR({actualshipdate}, 'J') - TO_CHAR({datecreated}, 'J'))) - ((((TRUNC({actualshipdate}, 'D')) - (TRUNC({datecreated},…
-
Hi @KNason76, If you notice in the Available NetSuite Fields in the Field Mapping step of the csv import, we can only update the header level information of the BOM record, and we can't update the Assembly sublist as this is not yet exposed on the csv import assistant. To be able to update the BOMs associated with…
-
Hi @KNason76, Can you clarify what exactly it is that you are trying to do? You previously said that you need to be able to delete Assembly Item Records. Are you encountering an error message when you try to delete these records in the UI?
-
Hi @User_RHKAB, When I tested this one on my account, it was excluding weekends. Can you send a screenshot of the results tab showing the following fields: Date Created Actual Ship Date Formula (Numeric) with the formula provided Formula (Percent) with the formula provided
-
Hi @Tom Dalton, Can you provide more details on what you are updating in for the Matrix Items? What exact fields are you trying to update? I am trying to replicate the error on my test account so it would be much appreciated if you can provide the steps you took to encounter this error.
-
Hi there @User_RHKAB, Were you able to test the solution I provided in my previous comment? Let us know if it was able to resolve your concern or if you need further assistance on this one. -Ivy
-
Hey there @Dallas H, Good to see you again here in our community! ? Regarding getting the results to show the quantity/amount sold per month, I have a related discussion which I posted: Although the title says "Items Shipped by Month, this can also be applied to get information like Quantity Sold, Received, Returned,…
-
Hi @Martha Hakes, I checked on this and noted that this functionality is not yet available in NetSuite. Currently this is logged under: Enhancement 68529 Price Levels > Allow users to create price levels that calculate based on an item's cost instead of your entered base (selling) cost. Currently, Price Levels in NetSuite…
-
Hi @sanimesa, Thank you for posting your concern here in our community! Allow us to check on your concern and we'll get back to you with our findings. Also tagging our Gurus who can help you out on this one: @Erick Dela Rosa-Oracle / @Mikko De La Fuente-Oracle, any insights you can share? To our other members, feel free to…
-
Hi @JohanvL, Thank you for posting your concern here in our community! We'll be checking on this and we'll get back to you with our findings. To everyone, feel free to comment your insights on this.