Mi contenido

Avatar
Ver todas las insignias desbloqueables Ver todas las insignias desbloqueables
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.
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!
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

Ivy Lopez-Oracle · SCM Guru · Red Diamond

Comentarios

  • You're welcome, Natalia! Let's wait if other members have found a workaround for this. Fingers crossed! ? Also, if you or the consultants manage to come up with the report, we would appreciate if you can share it here with the community. ?
  • Since this is a transaction saved search with Criteria = Status is Work Order:Planned, then when you click on the item, it will show the list of Planned Work Orders for the item. As for the detailed transactions of the back ordered quantity, this will not show in the Saved Search since we are only sourcing the data from…
  • Hi @JCronin, Thank you for posting your concern here in the community! Just to confirm -- the quantity pricing is not saved on Assembly Items and Inventory Items? Are there any scripts or workflows on the Assembly/Inventory Item record? Have you tried saving the Quantity Pricing on the Items with the scripts/workflows…
  • Hi Sarah! Usually, when there is quantity under the Inventory Detail tab, but is not reflected on the Location sublist of the item record or on the Inventory Valuation report, then there might be a location and lot number mismatch on the item. Here are some SuiteAnswers articles which may help you resolve your concern:…
  • The main difference of AIM and Demand Planning is: AIM uses Reorder Points and Preferred Stock levels to get the suggested quantity to be ordered on the Order Items page Demand Planning uses demand plan and supply plan records to track anticipated supply and demand Demand Planning is one of the pre-requisites to use the…
  • Hi Venkat, Usually, revaluation of inventory can be done by creating Inventory Adjustment Worksheet. This transaction allows users to set a new value while keeping the same quantity of the item. However, Inventory Adjustment Worksheets only support regular inventory items and does not yet support Lot Numbered or Serialized…
  • Seasonal Demand assumes that an item's demand fluctuates during specific times of the year thus, a flat historical calculation of demand is not accurate enough. So instead of looking at the last X number of months, NetSuite looks forward X months (a user-defined "season") from the current date in the previous year and…
  • Try adding these on the Criteria: Item : Is Phantom | is false Item : Preferred Vendor | is not -None- Let me know if this works for you or if there is anything else you need to add. ? ====================================== If you find this reply to your question as helpful, others with the same question might find it…
  • Hi Nairoff, Thank you for posting your concern here in the community! Tagging my colleague @Camille Cagalingan-Oracle as she is the expert on this topic. ? To other users who may have insights with regard to this, feel free to add your comments by replying to this thread.
  • Thanks Erick! Hi Natalia, I did some testing here to check if it is possible to customize the Inventory Valuation Report to show Inventory Status. Currently, this is not possible since Inventory Status is not an available field to be added in the Report Builder page. This system limitation is being tracked in Enhancement #…
  • Hi @Martha Hakes, Glad to have you back with us in the community and thanks for starting another discussion here! ? Just to give an insight on how the system works in tracking serialized inventory: When selling or fulfilling serialized items, users will be asked for the serial number on the posting sales transactions such…
  • Hi there Paul! For your 1st question about excluding specific locations, are you referring to Auto Calculate Re-order Point And Preferred Stock Levels, as documented in SuiteAnswers 73031? Per checking my resources, I noted that it is currently not possible to exclude specific locations. This is a system limitation and is…
  • Under the Criteria Tab Summary subtab, add: Summary Type = Sum Field = Formula (Numeric) Description = is 1 Formula = CASE WHEN ((SUM({quantity})+MAX(NVL({item.locationquantitybackordered},0)))-(MAX(NVL({item.locationquantityavailable},0))+MAX(NVL({item.locationquantityonorder},0)))) > 0 THEN 1 ELSE 0 END Let me know if…
  • Hi Roberto, I understand that you are creating a transaction saved search for Inventory Adjustments and need the Location of the transaction to show as the result. You mentioned that you used a joining field for this. Is this field called "Fulfilling/Receiving Transaction : Location"? Please note that this joining field is…
  • Here are the added/modified formula on the Results tab: Qty Backordered: MAX(NVL({item.locationquantitybackordered},0)) Needed Qty: case when ((SUM({quantity})+MAX(NVL({item.locationquantitybackordered},0)))-(MAX(NVL({item.locationquantityavailable},0))+MAX(NVL({item.locationquantityonorder},0)))) > 0 THEN…
  • Glad that we're on the right track! ? Here are the columns you can add to the Results tab of the search: For the Item Display Name and Item Type, you can find this in the Item Fields joining field on the drop down. Again, here's the formula I added/changed: Qty On Order: MAX(NVL({item.locationquantityonorder},0)) Needed…
  • I think we can achieve your requirement via Transaction Saved Search for Planned Work Orders. Here's what I came up with on my standard test account: By the way, I used the same item names as you provided in your initial post. I just did some sample Work Orders in Planned status on my test account to test if the search…
  • Hi @Umar Tanwir-Oracle, thank you for creating this poll! To our community members, appreciate if you can answer this quick poll about how your organization handles Payroll. ?
  • Thanks for creating this discussion, @Umar Tanwir-Oracle! ? Anyone who can share what made you decide to hire HR or Payroll specialist for your company? Feel free to comment on this thread!
  • Thanks Mikko! Hi Roberto, I checked my resources regarding this, and noted that even in NetSuite UI, it is not possible to set a specific Approver on the Inventory Count record. The possible reason on why this is not yet possible is because there is no separate permission for Approval of Inventory Counts. This is a system…
  • Thanks Emi! Hi @User_5RMAF, Kindly provide the following details so I can try and reproduce this in my standard test account: What is the costing method of the Assembly item? What is the costing method of the Component items? What is the value set in Setup > Manufacturing > Manufacturing Preferences > Average Cost…
  • Hi @User_DJQ3M, Welcome to the community and thank you for posting your question here! ? I checked my resources regarding this and noted that the system currently does not support Parent Matrix Items to be components on Assembly items. This system limitation is logged in Enhancement # 445836 - Allow Parent Matrix to be a…
  • Hi there @Kyle_Lautzenhiser-Oracle! Glad to have you back in the community and thanks for posting your question here! Please allow our gurus/members to look into this and update you for any findings. Also tagging my colleague @Micah Timbol-Oracle -- need your expertise here. ?
  • Assembly Item = Include Children checkbox is marked / Available to all subsidiaries Component Item = Restricted / Available only to some subsidiaries Is this the scenario that you have? Please note that as a general rule, the subsidiary field of the component items should include all of the subsidiary of the associated…
  • Hi there @Sonics! May we know if you are using the Demand Planning module in the system? The Demand Planning feature is used to analyze your stock demand needs. This feature also lets you determine replenishment requirements, and then create orders according to a supply plan that will add stock as needed. You can find more…
  • I checked my resources and it seems like this is not possible via saved search. You can check the SuiteScript Records Browser as it lists the standard NetSuite fields and their corresponding Internal ID. For the custom fields, you can view the field name/description and ID under Customization > Lists, Records, & Fields >…
  • Hi @rburns515, Thank you for posting your question here! Glad to have you back in the community! ? May we know if you are referring to custom fields or standard fields? Maybe you can try the SOAP Schema Browser or the SuiteScript Records Browser if this will give you the information you need.…
  • Hi @User_O2F3P, Welcome to the NetSuite Support Community and thank you for posting your concern here! ? Please give some time for our gurus/members to check on your concern and update you for any findings. @Camille Cagalingan-Oracle, need your expertise on this. Other members may also comment ideas which may be helpful.
  • Hi Roberto @User_LAGAM, Welcome back to the NetSuite Support Community and thank you for posting your concern here! ☺️ I checked my resources about being able to prevent commitment of expired lot numbers and found out that this is not yet possible in the system. This is logged in Enhancement # 268261 - Provide setting to…
  • Thanks Mikko! Hi @Kenny Wise, can you please provide the exact error message you receive when trying to change the component of the assembly item?