Ivy Lopez-Oracle · SCM Guru · Red Diamond

Hi @Paul Reading, Thanks for the clarification. What I meant was that whatever text you put in the description in the filter will be treated as a text/string, not as a field. See example below: Anyway, for your requirement, try adding a Formula (Numeric) in your Criteria with this formula: CASE WHEN {customitem316} =…

Hey there @Paul Reading, I'm testing this out, and was curious why you need the three spaces? Anyway, I think this is possible using a combination of the REGEXP_SUBSTR and REPLACE functions. In the meantime, if you just need the last word after the last colon, then you can try this formula:…

Hi @Paul Reading, Can you clarify what it is you are trying to achieve here? If you put in '{customitem316.name}' in the filter, then the search treats this as a string, and not as the value of the field. Are you trying to get only the items which have a value entered on that custom field?

Hi @Benjamin Paul - USA, Were you able to check my previous comment? If it was able to help in your concern, kindly click "Yes" on "Did this answer the question?". This will aid the others with the same question to easily find the correct answer. You will also earn points and may unlock the Answer Accepter badge.

Hi @Julien Mi Electronics, Were you able to check my previous comment? Let us know if this helped or if you need further assistance.

Wow, awesome @Tiru Chembeti! Also noticed that you are now at the top of our All Time Leaderboards. Congratulations! 🎉

Hi @Benjamin Paul - USA, Generally, the cost of any inventory deducting transaction (Item Fulfillment, Standalone Invoice, Negative Inventory Adjustment) will depend on the costing method of the item. If the costing method of the item is Average Cost, then the cost of the items will depend on the current average cost. For…

Hi @Asher_123, The field is called Location Available: The field ID used in search formula is {locationquantityavailable}.

It might be possible, but there is no documentation yet on SuiteAnswers similar to your requirement so I am unable to provide you with specific steps. However, you can try to create the search from scratch or coordinate with your Account Manager for possible engagement with Professional Services team to create a search or…

Hi @User_YMWNR, Thank you for posting your question here in the community! Per checking, there is no standard report similar to what you described, However, I did find a related enhancement on this: Enhancement # 195421. You can vote for the enhancement request in the SuiteIdeas page. Unfortunately, there is no documented…

HI @Asher_123, Were you able to try my previous comment? Let us know if it worked for you or if you need further assistance.

Hi @User_C6XDE, Try these steps to show the Mark Open Picks Done on the Warehouse Role: Login using Administrator role Go to Customization > Scripting > Script Deployments Check Show Undeployed and sort the list by Script Name Look for WMS Mark Complete Partial Picking > Edit > check Deployed > Save After doing the above,…

Hi @Julien Mi Electronics, I checked this and can confirm that the Transaction record is not on available list of records to be joined to the Item Dataset. However, the Item record fields are available in the Transaction Dataset, so maybe you can use this instead to get the information that you need. See example of the…

Hi there @User_T9YT2, Welcome to the NetSuite Support Community! We're glad to have you with us today and thank you for posting your question here. Allow our gurus/members to check on this and we'll keep this thread updated. In the meantime, can you share some screenshots or example illustrating what exactly you want to…

Hi @Julien Mi Electronics, I checked this on my test account and it seems your requirement is possible if you use the correct field in the SuiteAnalytics Dataset. If you want to show the Purchase Price under the Vendors sublist of the Item Record, then you need to use the Vendor Cost field under Vendors in the Dataset…

We are now closing today's session. Thank you to everyone who participated and I hope you learned something. Shoutouts to @Betsy Vance, @User_1J19L, @Julien Mi Electronics and @Dominica Sevilla-Oracle who sent in their questions. Hope to see you again on the next Ask A Guru: Live. Follow AskAGuruLive for more updates. Feel…

Hi Nikki, Generally, I think data is very interesting. It might seem a bit much at first, but if you know the right reports, searches, or formula, it can tell you a lot of things like how well an individual or a team is performing, or the history of a business. Also, I came from a company that did monthly and annual…

TIP # 3: Column Limit of Custom Search Portlets in Dashboards When placed in the right or left columns of a dashboard, custom search portlets display only the first 4 results columns of the saved search. When placed in the center column, they display the first 9 results columns. Optimizing the way the data is displayed is…

Hi @Julien Mi Electronics, Thanks for bringing this up! @Dominica Sevilla-Oracle is currently checking on this one, but I'll be collaborating with her as well to double check. We'll reply on that thread once we have further investigated it. Thank you for your patience.

TIP # 2: Analytics/Search Formula Samples As mentioned in my introduction, you might have seen my name pop up whenever you have questions about Saved Searches and SQL Formulas. Fun fact: Even before using NetSuite, I really liked playing around with different formula in MS Excel. Because of that habit, I usually tend to…

Hi John @User_1J19L, Are you referring to using SuiteAnalytics Connect? If so, then it is indeed read only. This is documented in the SuiteAnalytics Connect User Guide: As for updating the records, the only thing I am aware of is that this is possible using SuiteTalk or Web Services (though I am not familiar in using these…

Hi @Betsy Vance, Are you referring to the "Available Filters" functionality in Saved Searches? If so, then I'm afraid that there is nothing like that yet available for workbooks. There is a related enhancement for this and is tracked under Enhancement # 548493.

TIP # 1: Custom Fields return Null/Blank in Saved Searches A common question usually asked here in the community is about Custom Fields showing blank results in Saved Searches even though these fields have a value when viewed in the record. The reason for this behavior is that the Store Value is NOT checked in the Custom…

HI @Asher_123, Thank you for posting another question here in the community! What field are you using to get the Quantity Available? Can you try to use Location Available instead? Then in the Criteria, add Inventory Location = Warehouse. Let me know if this will work.

Hi @User_GE47I, Thank you for posting another question here in the community! Allow our gurus to check on this and we'll keep you updated on this thread. To our other members, feel free to share your insights as well.

Hi @User_J6WYT, Thank you for posting your concern here in the community! Allow our gurus to check on this and we'll keep you updated on this thread. To our other members, feel free to share your insights as well.

Hello @User_GANMT, Have you checked my previous comment? If it helped in your concern, kindly click "Yes" on "Did this answer the question?". This will help others with the same question to easily find the correct answer. You can also earn points and unlock the Answer Accepter badge.

Hello @User_T22B9, Per checking, there is an existing enhancement requesting for this functionality: Enhancement # 626191 : Quality Management Bundle > No Quality Inspection Queue record created after clicking Receive & Build button of the WO created from an outsourced PO Unfortunately, there is no documented alternate…

Unfortunately, there is no documented workaround for this. But you can reach out to your developers or to your Account Manager to discuss if your requirement is possible with customizations.

Yes.