Ivy Lopez-Oracle

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

Hi @Anaelena Zerpa, 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 WH TAX MISSING TAB ON CREDIT MEMO Comment by Ivy Lopez-Oracle Nov 22, 2023 5:18PM

Hi @User_YJM46, glad to have you with us today and thanks for posting here in the NetSuite Support Community! You can check these SuiteAnswers articles related to your concern: 32141: Customer Saved Search Adding Any Field from the Address Subtab (i.e., City, Country, Etc.) into the Results Displays Duplicates 74188:…

in Customer saved search results displays the same Internal ID twice Comment by Ivy Lopez-Oracle Nov 22, 2023 5:15PM

You can try adding a formula like: CASE WHEN ROUND({today}-{trandate},0) <= 30 THEN {serialnumberquantity} END You can change "30" to the number of days you need. If you need further assistance on this, I suggest submitting a new question here in the community so it can be further addressed.

in AE: Lot no item Aging Report/ Saved search Comment by Ivy Lopez-Oracle Nov 21, 2023 5:44PM

I did find related enhancement # 146430. You can vote for this, or submit a new specific one for your requirement in the SuiteIdeas page.

in Report customization to show non-inventory items for resale received/not fulfilled Comment by Ivy Lopez-Oracle Nov 21, 2023 5:23PM

Hi @Dustin S, 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 the average cost of an item on the Inventory Turnover Comment by Ivy Lopez-Oracle Nov 20, 2023 5:37PM

Hi @User_JPTT1, 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 Invoice Tax Details Comment by Ivy Lopez-Oracle Nov 17, 2023 5:38PM

Hi @User_KE39R, 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 Ampersand in Email Fails to Send Comment by Ivy Lopez-Oracle Nov 17, 2023 5:38PM

Hi @NY_CPA, 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 Looking for solution to integrate multiple BILL.com accounts to 1 Netsuite account. Comment by Ivy Lopez-Oracle Nov 17, 2023 5:31PM

Hi @Chris Haygarth ISDM, 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…

in Earliest Sales Order create date on Project Record Comment by Ivy Lopez-Oracle Nov 17, 2023 5:16PM

MFA for Oracle Community

Ivy Lopez-Oracle · SCM Guru · Red Diamond

Comments