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…

Hi Paula, I made an image of the scenario you mentioned to help us visualize it: Based on this, it seems that Transfer Orders can be used to transfer or ship the items from one location to another. When making the items demo items, you can use Inventory Adjustments to remove it from regular inventory, or maybe use…

Hi @Jeff_BlueMemento, Welcome to the community and thank you for posting your concern here! ? Our gurus/members will check on this and reply to this thread for any updates. To other users who may have insights with regard to this topic, feel free to add your comments by replying to this thread. By the way, we have an…

Hi Martin, This is a known system limitation, as mentioned in Emilia's comment. As a possible workaround, you can try using a Transaction Saved Search, and use the Item joining fields to pull the Weight from the item Record. Then, you can use a Formula field to multiply the weight by the quantity in the transaction.…

Hi @aisaadaniya, Welcome back to the community and thank you for posting your concern here! I checked my resources on this and found that the ability to add custom portlets in the Employee Center is not yet possible in the system. This limitation is logged in Enhancement # 183471 which you can vote for in the SuiteIdeas…

Glad I was able to help! ?

Hi @Chad C, Have you tried customizing the sublist in the Fulfill Orders page to add Ship Date as a filter? Click the Customize button on the page Go to the Additional Filters subtab Mark the Include checkbox next to Ship Date Click Save The page should now look like this, and you should be able to select the range of the…

Hi @Simone Pires-Oracle, Thanks for posting this in our community! Let's see if any of our members have been able to do the integration. Just to clarify, is it "WhatsUp" or is it "WhatsApp"? To our members, feel free to share your experiences about this one! ?

Hi @User_O4547, Thanks for posting your concern here in our community! ? Is the Demand Planning feature enabled on your account? Upon checking my resources about this, the Expected Ship Date is not showing on the Sales Order – item lines when Demand Planning is not enabled. To show this when Demand planning is not enabled…

Hi @User_GGRJN, Glad to have you with us today and thank you for posting your concern here in the community! Tagging our gurus who will be collaborating with you on this: @Dominica Sevilla-Oracle / @Shamaine Chan-Oracle, any ideas on this one? Anyone else with insights or suggestions? Feel free to comment on this thread! ?

Hi @ksage, I tested the criteria you provided in my standard test account, and it worked as expected on my end. Is this the only item which does not show up in the search? Try removing the Item : Inactive and Item : Sub-Item Of fields in the criteria (one at a time) and check if the item will show in the results. To…

Sounds good, Johnny! Let us know how it goes. ?

Hi @Johnny Cash, I also found a similar saved search documented in SuiteAnswers 39671. Same with the search in the link you provided, this can only pull the results based on the stock quantity of the subassemblies. Should you wish to use phantom as the item source of the subassembly, you may search the subassembly on the…

Thanks Emi! ----- Hi @Christopher, I checked my resources on this, and found out that this is not yet possible in the system. I noted Enhancement # 300622 is requesting for the ability to be able to pull the results in a saved search, and you can vote for this in the SuiteIdeas page. If anyone else has found a possible…

Hi @Ancana, Welcome back to NetSuite Support Community and thank you for posting your question here. ? Kindly allow our gurus some time to check this one for you and we will get back to you with our findings. Anyone else who may have insights regarding this topic, feel free to add your comments by replying to this thread.