Ivy Lopez-Oracle

Hi @User_TL7B6, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Richard James Uri-Oracle, @Nicole Mendoza-Oracle, @Jack Daryl Espiel-Oracle and @Joahnna Given Uy-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and…

in When will SuiteScript 1.0 API be out of service? Comment by Ivy Lopez-Oracle Apr 10, 2023 2:43PM

@Benjamin Paul - USA, The Back Ordered column is in the Sales Order. But in your previous comment, you mentioned you wanted the Purchase Order information. Is this correct? Can you provide examples or further illustrate your requirement?

in How to display the non-zero number of Back Ordered in Sales Order in a saved search? Comment by Ivy Lopez-Oracle Apr 4, 2023 10:25PM

Hi @User_EVVPG, Thanks for posting another question here in the community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

in Changing Unit of Measure - how to update related transactions? Comment by Ivy Lopez-Oracle Apr 3, 2023 3:39PM

Hi @Nickoletta Gounaris, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to take a look at your question and check if this is possible. Please allow them some time to investigate and get back to you. In…

in Can the Address Field on Contact Form not be mandatory? Comment by Ivy Lopez-Oracle Apr 3, 2023 3:37PM

Hi @StevenGreen, Welcome to the NetSuite Support Community! We're thrilled to see new members like you joining our community and reaching out for help. Per checking, it seems that the ability to mass update/calculate total item weight for assemblies once the weight of a member item of multiple assemblies changes is not yet…

in Forcing an assembly to re-calculate it's weight Comment by Ivy Lopez-Oracle Apr 3, 2023 3:34PM

Hi there @Martha Hakes, Thanks for posting another question here in the community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

in How to export and display Product Category in the generated Price List? Comment by Ivy Lopez-Oracle Apr 3, 2023 3:20PM

Hello @User_DATN1, Per checking, it is not yet possible to link Assembly Unbuild record with Assembly Build records. There is an existing enhancement requesting for this functionality and is logged as: Enhancement # 77321 : To link the Assembly build and Assembly unbuild, so that if an assembly build created from a work…

in Is it possible to unbuild part of an Assembly Build? Comment by Ivy Lopez-Oracle Apr 3, 2023 2:28PM

Wow! Congratulations @Brian Stisser! Thanks for helping our community! 😊

in TOP CONTRIBUTOR FOR MARCH 2023! Comment by Ivy Lopez-Oracle Apr 3, 2023 1:58PM

Hi @Benjamin Paul - USA, I remember you have posted a similar question before: Is this a different question?

in How to display the non-zero number of Back Ordered in Sales Order in a saved search? Comment by Ivy Lopez-Oracle Apr 3, 2023 1:27PM

Hi @Martha Hakes, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

in How to create a Saved Search to show multiple Pricing Quantities on one line? Comment by Ivy Lopez-Oracle Mar 31, 2023 4:59PM

Hi @faisalabdulmoid_39498, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Patrick Fresnosa-Oracle and @Clarisa De Torres-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you. In the meantime, if any…

in How to change subsidiary in a project? Comment by Ivy Lopez-Oracle Mar 31, 2023 4:55PM

Hi @BryanL, Thanks for posting another question here in our community! I actually tried this on my test account as well, and got the same error. I found it weird because when I manually typed in the same formula, it worked: CASE WHEN {item.inventorylocation} = 'Warehouse' THEN {item.locationquantityavailable} ELSE NULL END…

in How to resolve Error: "Field Not Found" when referencing Item fields in Saved Searches? Comment by Ivy Lopez-Oracle Mar 31, 2023 3:56PM

Hi @Wendy_M, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

in How to add Custom Item on PDP? Comment by Ivy Lopez-Oracle Mar 31, 2023 3:13PM

Hello @User_0RQ7O, Just wanted to check in if you were able to see the possible solution provided in my previous comment. If it was 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 the…

in How to create a Saved Search for Fulfillments shipped within the last hour? Comment by Ivy Lopez-Oracle Mar 29, 2023 10:48PM

Hi @FazeprooF, I tried it on my test account and was able to reproduce what you mentioned. As a workaround, please try using a Formula (Date/Time) field instead, and use the formula: {lineitemenddate} (which is the field id of the Line Item End Date field).

in Why is Timestamp not showing in saved search? Comment by Ivy Lopez-Oracle Mar 29, 2023 6:49PM

Hi @Kellyann, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Dominica Sevilla-Oracle and @Elychelle Gulen-Oracle to take a look at your question and provide you with their thoughts. Please allow them some time to investigate and get back to you. As initial troubleshooting, can you…

in Why are check boxes missing or replaced by a dot? Comment by Ivy Lopez-Oracle Mar 29, 2023 3:21PM

Hi @User_HPB3I, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. Please allow them some time to investigate and get back to you. As an initial troubleshooting step, can you check if there's anything entered in the…

in How to have an Email Alert when a Project Task Status Change? Comment by Ivy Lopez-Oracle Mar 29, 2023 3:17PM

Hi Audrey @User_HQRSY, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you.…

in Is it possible to create a Custom Item List to source from Purchase Order? Comment by Ivy Lopez-Oracle Mar 29, 2023 3:10PM

Hello @Ivan Babiichuk, Try adding these fields in your Results tab:

in How to get Price and Amount from Sales Order in Transaction Saved Search? Comment by Ivy Lopez-Oracle Mar 28, 2023 9:56PM

Hello @User_0RQ7O, Try this: Formula: CASE WHEN {systemnotes.newvalue} = 'Shipped' AND {systemnotes.date}-({now}-(1/24)) < (1/24) AND {systemnotes.date}-({now}-(1/24)) > 0 THEN 1 ELSE 0 END

in How to create a Saved Search for Fulfillments shipped within the last hour? Comment by Ivy Lopez-Oracle Mar 28, 2023 7:50PM

Hi @Dext3r, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. Please allow them some time to investigate and get back to you. In the meantime, if any other members have any thoughts, insights, or suggestions, we…

in Where do I go to learn about Employee Self Service (ESS) Users? Comment by Ivy Lopez-Oracle Mar 28, 2023 3:48PM

Hi @Christopher Williams, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Patrick Fresnosa-Oracle and @Clarisa De Torres-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you. In the meantime, if any…

in How to Customize Income Statement to Summarize Specific Expense Accounts? Comment by Ivy Lopez-Oracle Mar 28, 2023 3:20PM

Hi @Andrii Siryi, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Dominica Sevilla-Oracle and @Elychelle Gulen-Oracle to take a look at your question and check if this is possible in the native system. Also tagging @Richard James Uri-Oracle, @Nicole Mendoza-Oracle, @Jack Daryl…

in Forgiven amount. Comment by Ivy Lopez-Oracle Mar 28, 2023 2:52PM

Hi @Preethi Kondur, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to take a look at this one and provide you with their insights. Please allow them some time to investigate and get back to you. In the…

in Why the 3-Way Match Approval Workflow does not work when set as Scheduled? Comment by Ivy Lopez-Oracle Mar 28, 2023 2:42PM

Hi @User123554855, As documented in SuiteAnswers 31715: To use the Costed BOM Inquiry, enable the Standard Costing and Assemblies features. This inquiry can be run only for a standard cost assembly item. Also in SuiteAnswers 65696: Standard costing and assemblies must be enabled to use the Costed BOM Inquiry. You can run…

in Why is the Costed Bill of Materials Inquiry page not showing Assemblies list? Comment by Ivy Lopez-Oracle Mar 27, 2023 10:54PM

Hi @davidd039, Not quite sure what you need help with. Are you looking for a NetSuite solution similar to the Oracle Product Master Data Management? If so, then it would be best to reach out to your account manager for that. We can only provide assistance with what's available in NetSuite platform, which is the Item…

in Is there Item Substitute or something similar to Oracle Product Master Data Management? Comment by Ivy Lopez-Oracle Mar 27, 2023 10:42PM

Hi @Kedalene, I checked my resources about this and noted that your requirement about FIFO history is not yet available in the system. Here are some enhancements related to this: Enhancement # 72134: Ability to display FIFO layers in a standard report/transactions Enhancement # 183211 : Inventory Valuation Report : Ability…

in How to Revalue Inventory without Standard Costing? Comment by Ivy Lopez-Oracle Mar 27, 2023 9:57PM

Hi @User_F5KU8, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

in What feature would be best to use to record monthly rent expense and payments? Comment by Ivy Lopez-Oracle Mar 27, 2023 3:40PM

Hi there @ssilveri777, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our experts @Richard James Uri-Oracle, @Nicole Mendoza-Oracle, @Jack Daryl Espiel-Oracle and @Joahnna Given Uy-Oracle to take a look at your question and provide you with their thoughts. Please allow them some time to…

in How to show All System notes from API Comment by Ivy Lopez-Oracle Mar 27, 2023 3:34PM

Hi @User_UY6JW, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Micah Timbol-Oracle and @Katerina Winklerova-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you. In the meantime, if any other…

in Is there a Saved Search for Lease - ASC 842 Disclosure? Comment by Ivy Lopez-Oracle Mar 27, 2023 3:31PM

MFA for Oracle Community

Ivy Lopez-Oracle · SCM Guru · Red Diamond

Comments