Ivy Lopez-Oracle · SCM Guru · Red Diamond

Hi @User_8ZUQ1, I checked my resources on this and wasn't able to find any common issue other than the slow processing of the standard costing roll up due to the volume of records being processed. Based on the previously filed issues, the suggested approach to avoid this slow processing is to do the roll up by batch.…

Hi @User_H7U29, Thank you for posting your concern here in the community! ? Tagging @Michelle Jabanes-Oracle who has the expertise on your concern. Any ideas on this one Mich? To anyone else who has insights on this, feel free to comment on this thread!

Hi @User_MHMBF, Welcome to NS Support Community and thank you for posting your concern here! For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. You can also update your profile and set your preferred username so other…

Hi @liams, Was my previous comment able to help with your concern? If so, we appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of my previous comment that helped you. By doing so, you'll be able to help other community members who might encounter the same concern. Hope you have a…

Hi Dallas, Try adding this to the criteria of your search: This kind of has the same logic with what we discussed previously, just using a different field: https://community.oracle.com/netsuite/discussion/comment/16779172/#Comment_16779172 Hope this is what you were looking for. ? If not, let me know so I can further check…

Hi Dirk, It is not yet possible to have multiple work calendars per work center. Enhancement # 393126 is related to this and you can vote for it in the SuiteIdeas page. Per checking the enhancement details and related cases, it seems that there is currently no documented workaround for this yet. If anyone has ideas or…

Glad it worked for you @phil.walklett! ? To be able to put it back, you just need to set the page element to active again. Here are the steps: 1. Using Administrator role, go to Record Types page: Customization > Lists, Records, & Fields > Record Types 2. Find “Mobile - Page Element” Custom record and open it in list view…

Hi @phil.walklett, It is possible to hide this button from the WMS Mobile App. We suggest to test this first in your Sandbox Account before implementing in Production: 1. Using Administrator role, go to Record Types page: Customization > Lists, Records, & Fields > Record Types 2. Find “Mobile - Page” Custom record and open…

Hi @User_GGRJN, You can use Inventory Adjustments to add the quantity/stock for serialized items. CSV Import of Inventory Adjustments is possible, and is recommended if you will be adding quantity to many items. You may refer to SuiteAnswers 51417 - Inventory Adjustment Import for more information. Hope this helps! ? -Ivy…

Hi @liams, Kindly try if this formula will work for you: Formula (Numeric) Summary Type = Sum Formula: CASE WHEN TO_CHAR({trandate},'MM/YY')=TO_CHAR(TO_DATE(ADD_MONTHS({today},-1)),'MM/YY') THEN {quantity} ELSE 0 END + CASE WHEN TO_CHAR({trandate},'MM/YY')=TO_CHAR(TO_DATE(ADD_MONTHS({today},-2)),'MM/YY') THEN {quantity}…

Hi there @lilywu, Thank you for posting your concern here in our community! ? Allow me to tag our gurus who will be collaborating with you on this one: @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle, any ideas on how to do this? Anyone else with insights or suggestions? Feel free to share it with us in this thread!

Hi @Ancana, Thank you for posting another thread in our community! ? I believe those are called Sublists and you can refer to SuiteAnswers 10120 about Custom Sublists. Also tagging our gurus who specialize on this topic -- @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle. We need your expertise on this one. To our…

Hi @Dallas H, To be able to send email alerts when records are updated, an extra step is needed which is to add the necessary fields (in this case, the Location Safety Stock Level field) in the Updated Fields subtab of the Email tab of the search. Unfortunately, the Location sublist fields are not yet available in the…

Thank you for joining today! I hope you learned something new from the tips I shared, and maybe even something new about me. ? We are now closing today’s session. We hope to see you in the next #AskAGuruLive session. Be sure to follow the tag AskAGuruLive for updates. To help us improve this program, feel free to comment…

Tip # 3: Changing Item Accounts When editing an Item Record to change any GL account such as Asset, Income, Expense and COGS accounts, it will have a retroactive effect. If there are transactions from closed periods, users will need to reopen such periods to make the necessary changes. If the users do not want to re-open…

Tip # 2: Getting Item Quantity in Searches and Reports Aside from creating an Item Saved Search and using the Location Quantity fields (Location On Hand, Location Available, etc), you can also use the following to get the quantity of items: Inventory Balance Saved Search (Lists > Search > Saved Searches > New > Inventory…

Tip # 1: Location Quantity as Columns in Item Saved Searches Normally, when you add the Location Quantity fields (Location On Hand, Location Available, etc) in Item Saved Searches, they would be displayed as multiple rows per location. If you want to view the Location Quantity per column, you can use a Formula (Text)…

Hi @Tafara, Thank you for your question! ? I started working in NetSuite last January 2019 and have been in the SCM Vertical since then. I was originally a Support Representative for NOAM Operations, but I also had some experience with EMEA Operations before I became a Guru in the NetSuite Support Community.

Hi @Micah Timbol-Oracle, Believe it or not, I am having fun! ? I enjoy answering questions from our community since most of the time, it allows me to think outside the box and come up with formulas for saved searches or workarounds.

Hello @paula.courtemanche, Just wondering if my previous comment was able to help with your concern? If so, we appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of the previous comment that helped you. By doing so, you'll be able to help other community members who might encounter…

Hi Dallas, Based on the screenshots you sent, there is 1 quantity On Order in the Location Calgary Warehouse which is why it is not showing in the saved search. You have the criteria for Location On Order set to either empty OR equal to or less than 0. Is this the correct criteria for your requirement, or do you have…

Hi @jenluna, You can use Inventory Adjustments to change the value of your Serialized Inventory. First, do an Inventory Adjustment to decrease the quantity of the items. When doing this, the value of the items will automatically be calculated. Next, you need to create another Inventory Adjustment (dated at least a day…

Hi @Dirk Nieuwkamp, I checked into your concern and I found a related enhancement which you can vote for in the SuiteIdeas page: Enhancement # 257599: Ability to add a reminder if there are Items for Bin Putaway The documented workaround is to putaway any existing Items pending putaway then create a Transaction Saved…

Hi @MJ NCO, Thank you for posting your concern here in the community! Have you tried checking the 2021.2 Release Notes? Also tagging @Michelle Jabanes-Oracle who will be able to help you with your concern. Anyone else with any ideas? Feel free to comment on this thread!

Hi @User_T6X2J, Welcome to NS Support Community and thank you for posting your concern here! For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. You can also update your profile and set your preferred username so other…

Hi @User_M8IWD, Thank you for posting again here in the community! ? Allow our gurus to check on your concern and update the thread for any findings. To our members, feel free to share your insights that might help regarding this.

Hi @Kenny Wise, When you edit an item record to change any GL account such as Asset, Income, Expense and COGS accounts, it will have a retroactive effect. If there are transactions from closed periods, you will need to reopen such periods to make the necessary changes. If the you do not want to re-open the period, it would…

Hi @Vernita, I tested this on my account but I wasn't able to find a way to select the default currency shown in the Sales/Pricing tab of the item record. I also consulted this with our gurus who are experts in Scripting and Customization, and they confirmed that it is also not possible even with the use of scripts or…

Hi John, I checked my resources on this and it seems like for saved searches, pulling fields from Class record is not yet possible. This is logged in Enhancement # 267605 and you can vote for this in the SuiteIdeas page. Unfortunately, there is no documented workaround for this one yet. We appreciate your understanding on…

Hi @paula.courtemanche, I got the below details in the Oracle NetSuite Support Community Inbox: Perfect representation of the case! This would definitely work for us. The use case that was brought to my attention was that after the first 10 were shipped the second, third and forth shipments were 'forgotten', but got…