Ivy Lopez-Oracle

Hi @RichardMc, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Can you clarify what you mean by "what table a saved search was built from?" Are you asking if the search is an Item search, Transaction search, Customer search, etc.? If that's the case, then the easiest way is to…

in Saved Search - Base Table Comment by Ivy Lopez-Oracle Dec 19, 2023 4:17PM

Hi @Amjad Kasem Just wanted to check in if you were able to see the possible solution provided in @Michelle Jabanes-Oracle's previous comment. If it was were helpful, could you do us a quick favor and click "Yes" on "Did this answer the question?" It helps others with the same question find the answer quickly, and you'll…

in How to display sales rep and support rep on customer dashboard Comment by Ivy Lopez-Oracle Dec 19, 2023 3:09PM

Hi @Amjad Kasem Just wanted to check in if you were able to see the possible solution provided in @Michelle Jabanes-Oracle's previous comment. If it was were helpful, could you do us a quick favor and click "Yes" on "Did this answer the question?" It helps others with the same question find the answer quickly, and you'll…

in customer user (contact) can not access the sub customer transaction in customer center Comment by Ivy Lopez-Oracle Dec 19, 2023 3:09PM

Hi @kkuhn, Just wanted to check in if you were able to see the possible solution provided in the previous comments. If any of them were helpful, could you do us a quick favor and click "Yes" on "Did this answer the question?" It helps others with the same question find the answer quickly, and you'll earn points and unlock…

in Adding a new user with an existing license from another user that is no longer with the company Comment by Ivy Lopez-Oracle Dec 19, 2023 3:04PM

Hi @User_Shane, Kindly provide the requested screenshots in @Niks Blando-Oracle's previous comment so we can further check this on our end.

in Creating a Formula in Price Update Saved Search Comment by Ivy Lopez-Oracle Dec 19, 2023 2:59PM

Hi @Gia My "Mei" Luc, Were you able to check the comments of @Niks Blando-Oracle and @R. Dieka Pribadi G. E.,? I also agree with them that CSV Imports are the way to go. Anyway, if any of the previous answers was helpful, could you do us a quick favor and click "Yes" on "Did this answer the question?" below the…

in Import Opening Inventory Balance for Go-live Comment by Ivy Lopez-Oracle Dec 19, 2023 2:45PM

Hi @nir.levy, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you know…

in creating via suitescript encrypted excel file Comment by Ivy Lopez-Oracle Dec 18, 2023 6:01PM

Hi @User_TXI1Z, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in We would like to inquire how to update the last depreciation date of assets imported via CSV import Comment by Ivy Lopez-Oracle Dec 18, 2023 5:26PM

Hi @Kerem Basturk, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in How to prevent anyone from changing the raw component being consumed on a work order? Comment by Ivy Lopez-Oracle Dec 18, 2023 5:09PM

Hi @Mike Begalle, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in Item Fulfillments generated through WMS Comment by Ivy Lopez-Oracle Dec 15, 2023 4:57PM

¡Se acabó el tiempo! La respuesta correcta y su explicación figuran a continuación: Respuesta correcta: B Explicación: La fórmula NVL2({x}, 'Sí', 'No'), dará como resultado 'No' si {x} es NULL. La sintaxis de la función NVL2 es NVL2(expr1, expr2, expr3). Si expr1 no es nulo, NVL2 devuelve expr2. Si expr1 es nulo, NVL2…

in 13 de Diciembre de 2023 | Pregunta de la semana Comment by Ivy Lopez-Oracle Dec 14, 2023 7:00PM

Time's up, everyone! Kindly see details below for the correct answer and its explanation: Correct Answer: B Explanation: The formula NVL2({x}, 'Yes', 'No'), will result to 'No' if {x} is NULL. The syntax for NVL2 function is NVL2(expr1, expr2, expr3). If expr1 is not null, then NVL2 returns expr2. If expr1 is null, then…

in December 13, 2023 | Question of the Week Comment by Ivy Lopez-Oracle Dec 14, 2023 7:00PM

Hi @User_MT6GI, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in Add a Custom Financial Report in Reports Tab for accounting center role Comment by Ivy Lopez-Oracle Dec 13, 2023 4:40PM

We do not have a specific template for CSV Imports for items. However, you can refer to the following SuiteAnswers articles for guidance regarding this: 9982 - Items Import 9973 - Guidelines for CSV Import Files Should you need further assistance on your concern about importing items, feel free to post a new question here…

in Remove Vendor in Inventory Items Comment by Ivy Lopez-Oracle Dec 13, 2023 12:18AM

Hi @Elizabeth Vance, glad to have you back with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In…

in Fixed Asset Proposal Pending Status Comment by Ivy Lopez-Oracle Dec 12, 2023 4:38PM

Hi @User_9EZM3, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in Unable to add my Netsuite Email to Customer account as an employee while provisioning new Customer Comment by Ivy Lopez-Oracle Dec 8, 2023 5:31PM

Hi @Paul Reading, Try using Formula (HTML) field instead of the Formula (Text). There was a change in the recent release that HTML codes will no longer work in Formula (Text) fields. You need to use the dedicated Formula (HTML) for any code that uses HTML formatting.

in How to trim a field to delimiter in a Saved Search? Comment by Ivy Lopez-Oracle Dec 7, 2023 1:25PM

Hi @Rick Cobb_2, Were you able check Mich's previous comment? Let us know if it helped by clicking the "Yes" button on the Did this answer the question? part. It helps others with the same question find the answer quickly, and you'll earn points and unlock the Answer Accepter badge. If you still need assistance, please…

in publishing Employee Center dashboard without SuitePeople HR Comment by Ivy Lopez-Oracle Dec 6, 2023 10:55PM

Hi @ZShah, Were you able see Clarisa's previous comment? Let us know if it helped by clicking the "Yes" button on the Did this answer the question? part. It helps others with the same question find the answer quickly, and you'll earn points and unlock the Answer Accepter badge. If you still need assistance, please don't…

in Net Profit appearing in Elmination Subsidiary Comment by Ivy Lopez-Oracle Dec 6, 2023 10:52PM

Hi @User_USKL1, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in How to create Item Fulfillment from Sales Order with SOAP API ? Comment by Ivy Lopez-Oracle Dec 5, 2023 5:09PM

Hi @✨Jeannie, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you know…

in How to add "User Notes" in a dataset? Comment by Ivy Lopez-Oracle Nov 30, 2023 5:32PM

Hi @User 90210-Oracle, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case…

in How to add the due date field to the Import Assistant? Comment by Ivy Lopez-Oracle Nov 30, 2023 5:29PM

Hi @Chad C, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you know…

in Financial reporting based on class Comment by Ivy Lopez-Oracle Nov 30, 2023 5:27PM

Hi @User_NG5TG, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in Net of tax on all transaction types Comment by Ivy Lopez-Oracle Nov 30, 2023 5:02PM

Hi @Garth T, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you know…

in How do I add "Current Rate" to a transaction report using report builder? Comment by Ivy Lopez-Oracle Nov 29, 2023 4:49PM

Hi @Mike Begalle, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in Anyone else have problems with the Supplementary Tax Calculation version 1.14.4? Comment by Ivy Lopez-Oracle Nov 28, 2023 5:32PM

Hi @User_2LD8N, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in cycle count to get current inventory count Comment by Ivy Lopez-Oracle Nov 28, 2023 5:30PM

Hi @HenryPhillips, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in What do mid-sized companies see as an appropriate, annual ERP Cost/Revenue ratio? Comment by Ivy Lopez-Oracle Nov 27, 2023 5:20PM

Hi @Dext3r, glad to have you with us today and thanks for posting here in the NetSuite Support Community! I noticed on your screenshot that it doesn't have a Bill of Materials and Bill of Materials Revision selected. Can you try adding values to those fields? Greetings, everyone! We have a fellow member who could use our…

in BoM and BoM Revision fields blank on Assembly Build Comment by Ivy Lopez-Oracle Nov 27, 2023 5:12PM

Hi @tech work, glad to have you with us today and thanks for posting here in the NetSuite Support Community! Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated! -- In case you…

in Manufacturing Operation Task - Saved Search Comment by Ivy Lopez-Oracle Nov 22, 2023 5:24PM

MFA for Oracle Community

Ivy Lopez-Oracle · SCM Guru · Red Diamond

Comments