Ivy Lopez-Oracle NSC Guru

Hi @Harry Pham, Did you map both Plan Start Date and Plan End Date in the CSV Import? This is the solution documented in SuiteAnswers 35062. Let us know if it works for you. -Ivy ========================= If you find this reply to your question as helpful, others with the same question might find it helpful as well. By…

Hi @Hormese Paul, As documented in SuiteAnswers 27996, a line on a transfer order can be closed only if the in-transit quantity is zero. This is standard behavior of the system for Transfer Orders. The ability to close transfer orders even when there are quantity's in transit is currently requested in Enhancement # 233320.…

Hi @esabis, I tried this in my test account and I was able to successfully delete a Store Pickup Fulfillment record in Picked Up status. Do you receive an error message when you try to delete this record in your account? Alternatively, you can delete Cancelled Store Pickup Fulfillment records via Inline Edit: Let us know…

Hi @esabis, Thank you for creating another thread here in our community! ? Let me test this on my end first, then I'll get back to you with my findings. In the meantime, can you check if there are any transactions in the Related Records tab of the record you are trying to delete? Has anyone else encountered the same…

Hi Lily, Welcome back to the community and thank you for posting your concern here! Please allow our gurus/members to look into this and update you for any findings. @Shamaine Chan-Oracle / @Dominica Sevilla-Oracle, need your expertise on this. ? Anyone else who has an ideas or suggestions? Feel free to comment on this…

Hi Karan, Thank you for creating another thread in our community! Please allow our gurus/members to look into this and update you for any findings. @Dominica Sevilla-Oracle / @Shamaine Chan-Oracle, any ideas about this one? Anyone else who has an insight? Feel free to reply to this thread! 

Hi @farrago, Have you checked SuiteAnswers 14305 if the Assembly Matrix items meet all the criteria/setup mentioned? I have coordinated this with our experts in this topic and they suggested to create a Support Case if the behavior persists even after trying the suggested solutions in SuiteAnswers 14305. We would also…

Hi Daniel, Since you have Applying Transaction : Type is Purchase Order in your Criteria, then it will only show those Invoiced Sales Orders with related Purchase Orders. Based on the formula in your criteria, it will only pull those with a value for either the Vendor Cost or the Amount/Quantity of the Purchase Order. Can…

Hi @farrago, Thank you for creating another thread here in our community! Are you trying to add the Parent Matrix Assembly Item to the cart? or is it the Child item? Anyone else tried something like this before? Let us know in the comments below! ?

Hi @Curtis Beene, Use a Formula (Text) field with this formula: Monday Date: TO_CHAR((trunc({trandate},'Day')+1),'MM/DD/YYYY') Date Range: TO_CHAR((trunc({trandate},'Day')+1),'MM/DD/YYYY') || ' - ' || TO_CHAR((trunc({trandate},'Day')+7),'MM/DD/YYYY') Hope this helps! ? -Ivy ========================= If you find this reply…

Hi @Johnny Cash, Kindly provide screenshots of the specific fields you want to have in your saved search. I would also help in our testing if you can provide an example of the values you want to total. Just make sure that you hide any confidential information.

Hi Daniel, Since you are searching for the sale price (rate in the Invoice) and the purchase price (rate in the Purchase Order) then there should be a sales order linking the two transactions. Here is the search I came up with: Criteria tab Results tab: Formula: PO Rate: CASE WHEN {applyingtransaction.type} = 'Purchase…

Hi @User_NYYPL, I tested this in my account, but was unsuccessful as well to achieve the desired results. Per further investigation, I found that this is not yet possible and is currently logged as Enhancement # 409727: Transaction Saved Search: Type = Work Order > Provide a separate Quantity field to pull up quantity in…

Hi @Sonics, In Saved Searches, we can only pull up the current values in transaction lines since it is not yet possible to get the system notes or changes per line in a transaction. This is logged in Enhancement # 172761: Ability to create saved search for History link available on line item of a transactions. You can vote…

Hi Blake, Currently, this is exclusive to the Employee Center role. The intention is it would be used by users with the most "regular" or common role in the company. I checked, but found no related enhancements for this yet. If you want, you can submit a new enhancement request in the SuiteIdeas page. Also, we would…

You're welcome! Glad I could help! ?

I created the sample items and the item group in my test account and here's the results of search I came up with: Is this what you were looking for? If it is then here is a screenshot of the results tab of the search: Formula (Percent): 1-(SUM({memberitem.onlineprice})/SUM({memberitem.price})) Based on my tests, the…

Can you please further explain what you need to appear on the saved search results? You can provide an example of what you want to achieve exactly. You can use screenshots, just make sure to hide any confidential information. Also, why will the Summary Type = Sum not work for you? This will help us in testing for a formula…

Hi Daniel, I'm glad it works for you now! ? If it's not too much trouble, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” for the comment/s that helped in your concern. This will also help other community members who might have the same concern find the answer easier. Hope you have a…

It is possible, but the Highlight If and Threshold columns must be populated. The result of the comparison of the custom KPI must meet the condition you set in those columns for it to be added as a headline in the portlet. For example, if you input: Highlight If: Variance Greater Than Threshold: 0 Then it will be…

Hi @User_4KSCX, Kindly check your saved search if it has a Date filter in the Available Filters tab of the saved search. As mentioned in SuiteAnswers 8111, this is one of the requirements of the Saved Search in order to use it for comparison on a Custom KPI: Not include any date fields defined as filters on the Criteria…

Hi @BM136, Try this formula: CASE WHEN {memberitem.type} = 'Inventory Item' THEN {memberitem.onlineprice} ELSE 0 END Your logic is correct, just change the 'is' to an equal sign and also note that the item type is case sensitive. Hope this helps! ? -Ivy ========================= If you find this reply to your question as…

Hi Blake, Can you try it with the Employee Center Role? You can refer to SuiteAnswers 71915 for a video demonstration on how to do this. It was also mentioned in the article to use Employee Center role with Employee Center Publishing global permission. If the Company News Portlet is not available even when using the…

Hi @User_3WQBC, Did you already add the "Employee Center Publishing" global permission to your employee record, then logged out and logged back in? I have coordinated this with our gurus who specialize in SuitePeople HR and if you are still not able to add the portlet to your Dashboard, it would be better to create a…

Hi @CDuf, Thank you for creating another thread here in our community! ? Let me tag @Michelle Jabanes-Oracle who has the expertise on this one. Anyone else who knows about a related enhancement? Share it with us by commenting in the thread! By the way, the community will be have its third webinar on September 2, 2021. It…

Hi @User_LYA61, Thank you for posting your concern here in the community! ? Let me tag our gurus who will be able to help you out with your concern: @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle, any ideas about this? To our other members who have insights or suggestions, feel free to comment in the thread!

Hi @User_3WQBC, 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 Tom, It is always best to test the features first in Sandbox before enabling in Production. This is so that you can test first if the feature will affect your processes or customizations you have in your account. To clarify, to be able to have the kit components show up in the Item Fulfillment, the components need to be…

You're welcome, Martha! Glad I was able to help! ?

Hi @Martha Hakes, At first I thought about the Use Component Yield preference. This preference lets you automatically calculate quantity allowances for expected raw material loss during processing. However, when I tested it, I found that it is not possible to enter a value more than 100 in this field. This makes sense…