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 @Anne Dolce, Were you able to check my previous comment? Let us know if you need further assistance on this one.
-
Hi @SanjeevV, Glad I was able to help! ? As you confirmed that your main concern for this thread (regarding the Saved Search) has been resolved already, I suggest that you post a new question regarding your other concern about financial reports. (You can add a link to this thread if you want.) This is so that members who…
-
Hi there @SanjeevV, Thanks for posting your concern here in our community! In the Criteria tab, try adding a Formula (Numeric) field with this formula: CASE WHEN {quantity}-{quantitybilled}=0 THEN 1 ELSE 0 END equal to 0 Let us know if this works for you. -Ivy ========================= If you find this reply to your…
-
Hi @Amjad Kasem, Good to see you here again in our community! Allow our gurus/members to check this for you and we'll update you here in this thread. @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Kristoffer Viray-Oracle, any ideas? To our other members, feel free to share your insights on this one as well.
-
Hi @Dirk Nieuwkamp, Generally speaking, Saved Searches offer a lot more flexibility in using formulas than Reports wherein you can only do simple formulas. Also, reports are limited to using existing fields (standard and custom) only, and since we don't have a native field that gets the latest bill rate, then we can't get…
-
Hi @Anne Dolce, Basically, the unit cost will depend on the Costing Method that is set on the item record. We previously had a webinar about this topic, and you can watch the replay here: An example of the calculation of the cost using Average Costing is provided at around ~10:40 in the video. Hope this information helps!…
-
You're welcome, Ben! Glad I was able to point you in the right direction. ? By the way, we would greatly appreciate if you can click "Yes" on “Did this answer the question?” below my previous comment that helped in your concern. Doing so will help other community members who might have the same concern find the answer…
-
Hi @User_C6XDE, If you have Item as a column in your Results tab, then the search will get the location on the item line. Did you put any Date filters on the search? That might be causing the mismatch since the quantity on the Item Record always shows the current quantity. About the other search, you can try the steps…
-
Hi @Ben Belzer, The process you described sounds a lot like Outsourced Manufacturing. We do have this feature available in NetSuite and you can refer to SuiteAnswers 91095 (and related topics) to know more. I also found this thread related to the Outsourced Manufacturing process if you want to check it out. Anyway,…
-
Hi Dirk, For your first bullet point, it is a known system limitation to be able to specify a date range on an Item Saved Search. This is logged under Enhancement # 177982. About getting the item rate of the latest bill, I did some tests on my end, but was unsuccessful in getting your requirement. The roadblock I…en Stock valuation based on last purchase price Comentario por Ivy Lopez-Oracle Jun 17, 2022 12:58AM
-
Awesome! Glad that we were able to figure that out and thanks for sharing the solution that worked on your end. ?
-
Can you try removing the criteria for Quantity Shipped/Received/Picked Up and check if you'll get Inventory Adjustments included in the results?
-
Hi @Jay Schwausch, Looking at the screenshot you provided, I can say that you are on the right track with the Use Expressions checkbox marked. For your use case, can you try editing the logic in the criteria to something like this: Type = Inventory Adjustment | OR (Type = Purchase Order | AND (Vendor = Vendor 1 | OR Vendor…
-
You're welcome, @RachaelRahe! Glad that we were able to find the cause of this behavior. ?
-
Glad I was able to help, @David DeLisser! ?
-
Hi @SanjeevV, Glad to have you with us today and thanks for posting your concern here in our community. Allow our gurus/members to check on this one, and we'll provide updates in this thread. @Dominica Sevilla-Oracle / @Elychelle Gulen-Oracle, any ideas? To our other members, feel free to comment your insights on this as…
-
Hi @David DeLisser, You can create an Analytics Audit Trail Search to get the required information. Here's the Criteria and Results tab of what I was able to test out: Criteria tab: Record Type = Report Record Action = Create Results tab: Record Title (Report Title) Date (Created Date) Set By (Created By) You can add other…
-
Hi @RachaelRahe, Thanks for providing the screenshots! I did notice that in the Inventory Balance search, the quantity is in various Bins, but on the screenshot of the Inventory Detail that you sent before, there is no field that you can select the bins. Is this correct? Can you confirm on the item record if the Use Bins…
-
Hi @User_C6XDE, If you're looking for the transaction history of the bins, then you are on the right track in using the Transaction Fields in an Item Saved Search. The only concern I have on this is that you want to also "view a list of bins that have never been used before" in the same search. Not really sure this is…
-
Hi @Dirk Nieuwkamp, Have you tried the formula provided in my previous comment? Let us know if you need further assistance on this one.en Stock valuation based on last purchase price Comentario por Ivy Lopez-Oracle Jun 15, 2022 11:43PM
-
Hi @Mike Wondrasek, The standard Special Order process assumes that there is only one Vendor involved who will ship to your store/warehouse, then you will ship to the customer who ordered it. The process that you mentioned in your post involves sending an email to a second Vendor, which is not yet supported by the native…
-
Hi @Burgess-Mel, Thanks for posting another question in our community. Allow our gurus/members to check on this and we'll get back to you with updates. To our other members, feel free to share your insights on this as well.
-
Hmm, that is weird. I tried to reproduce this on my test account, but I did not encounter this behavior. It is possible that it is an issue specific to your account only. Have you tried reaching out to Support regarding this concern? By the way, is this the 1st time that you experienced this? Do you have any scripts or…
-
Hi @Janis Abernathy, Were you able to check on my previous comment? If it was helpful on your concern, then we would greatly appreciate if you can click "Yes" on “Did this answer the question?” below my previous comment. By doing so, you’ll be able to help other community members who might have the same concern find the…
-
Hi @Dirk Nieuwkamp, Yes, you can use a Formula (Numeric) field and enter this formula: {quantityonhand}*{lastpurchaseprice} Let us know if this works for you. -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…
-
You can submit a new enhancement request specific to your concern via the SuiteIdeas page. We appreciate your understanding on this system limitation.
-
Hi @Curtis Beene, I tried to check my resources on this one, but it seems like what you mentioned is currently the standard behavior of the system. I did manage to find a related enhancement request for this filed under Enhancement # 453622. You can vote for this enhancement or you can also submit a new one specific to…
-
Hi @Wendy_M, Here's what you should add to your Criteria so that your search will show only those with more than 1 preferred Landed Cost Template: Criteria tab > Standard subtab: Landed Cost Template Mapping: Preferred is true Criteria tab > Summary subtab: Count of Landed Cost Template Mapping: Landed Cost Template is…
-
Hi @Dirk Nieuwkamp, We do have the Inventory Valuation Report and some reports for Standard Costing available. If these do not meet your customer's requirement, then you can also create an Item Saved Search and use the Last Purchase Price and On Hand Qty to get the desired results. Hope this information helps. Anyone else…
-
Hi @Janis Abernathy, I tested this one on my end, and here are my findings: -System allows the Outsource Charge Item to be used on multiple Assemblies/BOMs -However, It is not possible to edit the Description or Quantity of this item in the BOM Revision -It is also not possible to edit the Description/Quantity/Cost in the…