Ivy Lopez-Oracle NSC Guru

Hi Tom, Even if the "DISPLAY COMPONENTS ON TRANSACTIONS" preference is enabled in the item record, it does not show on transaction forms in the UI but only on printed forms. This is its standard behavior. Note that the ability for the components to be displayed on transactions is not yet available within the system. There…

Hi Dirk, As discussed in SuiteAnswers 98926, when creating AM Work Centers, you will still need to select the NetSuite Work Center, or the Static Employee Group created. Each Work Center still has a limitation of 1 Work Calendar each even with the Advanced Manufacturing bundle.

Hi @KaylaM, If you do not want to reopen closed periods, but want to fix the costing calculation, you can file a support case so that a defect can be filed and it will be fixed in the back end. Reversing JEs will be created so the financials will not be affected. Not fixing the costing calculation will mean that you will…

Hi @User_GGRJN, Were you able to add serial numbers to your items? Did my previous comment 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…

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.