Ivy Lopez-Oracle

Awesome, @Harikrishnan N! Thanks for posting another content! 👏

in Create a CSV file, save, load and parse the CSV contents using suiteScript Comment by Ivy Lopez-Oracle May 8, 2025 12:36PM

Hi @Raj_08, 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 the meantime,…

in Missing value for Classification Code list Comment by Ivy Lopez-Oracle May 8, 2025 12:20PM

Hi @Glaced999991, 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 the…

in Custom field in Email record / CRM Message Comment by Ivy Lopez-Oracle May 8, 2025 12:20PM

Thanks for sharing this, @SILJA K C! 📝

in Re-Reconciling a Bank Transaction Without Deleting a Reconciled Period Comment by Ivy Lopez-Oracle May 7, 2025 12:49PM

Hi @User_XBPX5, 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 Security Protocols in NetSuite for Handling Email Case Replies and Attached Files Comment by Ivy Lopez-Oracle May 7, 2025 12:06PM

Hi @NPauwels, 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 Issues with voided payment installment Comment by Ivy Lopez-Oracle May 7, 2025 12:05PM

Hi @User_J3JDX, I tried @Harikrishnan N's suggestion (with a slight modification) and it worked on my end. I noticed that their formula had quotation marks which is not really used in SQL formula, and is missing the closing curly brace for the fieldid. The formula is: TO_DATE({fieldid}, 'MM/DD/YYYY HH24:MI:SS') Here's a…

in In Netsuite Data Analytics, require a formula to convert string to date Comment by Ivy Lopez-Oracle May 7, 2025 11:59AM

Hi @User_43PVM, 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 the…

in In the Advanced PDF/HTML template, I'm unable to include child record line items (from a related cus Comment by Ivy Lopez-Oracle May 6, 2025 11:50AM

Hi @Rhys Gottwald, 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 the…

in Bin Blocking and Unblocking Audit Trail Comment by Ivy Lopez-Oracle May 6, 2025 11:49AM

Hi @Dext3r, 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 the meantime,…

in Transaction CustCols on orders from Webstore not Sourcing Info Comment by Ivy Lopez-Oracle May 6, 2025 11:10AM

Hi @Narayan Sharma, 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 the…

in For Resale Item, What Is the "Applies To" Name in NetSuite Script Deployments? Comment by Ivy Lopez-Oracle May 6, 2025 11:09AM

Hi @User_QA49G, 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 the…

in Handling Incorrect Barcode Scans Comment by Ivy Lopez-Oracle May 6, 2025 11:09AM

Unfortunately, I don't think there is a way to achieve your desired results. Anyone else with ideas/insights about this requirement? Feel free to comment on this thread!

in Project Saved Search with Multiple Sales Orders Comment by Ivy Lopez-Oracle May 2, 2025 5:52PM

Hi @User_7NK3Q, just to confirm.. the formula I initially provided works now, right? Now the only problem is it shows the <br> tag when exporting to Excel. I know a quick trick that would replace the <br> tags as line breaks: Using MS Excel, you can use the Replace (Ctrl + H) functionality. Steps: Open your Excel file…

in Project Saved Search with Multiple Sales Orders Comment by Ivy Lopez-Oracle May 2, 2025 3:45PM

サポートコミュニティへの投稿ありがとうございます。専門の担当者と連携して回答いたします。進捗があり次第、こちらに投稿しますので、少々お待ちください。他のメンバーの皆様も、このスレッドにコメントし、知見を共有したり提案することができます。なお、日本対応チームは平日（月〜金）の午前8時から午後6時まで対応しております。よろしくお願いいたします。

in 定期トランザクションで設定している内容を一括更新できないでしょうか？ Comment by Ivy Lopez-Oracle May 2, 2025 1:34PM

Hi @Vernita, 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 the meantime,…

in Display address fields on a suitelet Comment by Ivy Lopez-Oracle May 2, 2025 11:09AM

Hi @Vernita, 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 the meantime,…

in How to access the vendor subsidiary relationship record in Suitescript? Comment by Ivy Lopez-Oracle May 2, 2025 11:09AM

Hi @JingShien, 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 the…

in Missing WMS Setup Stock Adjustment Type Comment by Ivy Lopez-Oracle May 2, 2025 11:09AM

Hi @Elina Kourouzidou, 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 the…

in Date field based on Open Periods Comment by Ivy Lopez-Oracle May 2, 2025 11:09AM

Hi @MJ NCO, 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 the meantime,…

in File Cabinet Folder access by Dynamic Group does not work Comment by Ivy Lopez-Oracle May 2, 2025 11:08AM

Hi @User_Q3A12, 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 the…

in It is possible to mass update the transaction form? Comment by Ivy Lopez-Oracle May 1, 2025 12:29PM

Thanks for posting another content, @Harikrishnan N! 📝

in Configuring IP Address Validation in NetSuite Comment by Ivy Lopez-Oracle May 1, 2025 11:43AM

Hi @Toanne Termeer, 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 the…

in Generate Replenishment Error Comment by Ivy Lopez-Oracle May 1, 2025 11:27AM

That is strange behavior with Formula (Numeric) field, since the intended output is supposed to be just numbers. However, it is now standard behavior for Formula (Text) field to display as plain text only. This is to improve the security of saved searches. (SuiteAnswers 8448) Anyway, glad I was able to help out! If I can…

in Project Saved Search with Multiple Sales Orders Comment by Ivy Lopez-Oracle Apr 30, 2025 5:05PM

Weird that you don't have the option for Formula (HTML). Are you perhaps using a custom role? If so, you need to have an Administrator add the Create HTML Formulas in Search permission (under Setup) either to the Role, or to the Global Permissions in the Employee Record. See SuiteAnswers 108380 for more info about this.

in Project Saved Search with Multiple Sales Orders Comment by Ivy Lopez-Oracle Apr 30, 2025 4:33PM

Hi @User_7NK3Q, based on your original post, you mentioned that: Also tried to use NS_CONCAT function within CASE WHEN to group all sales orders with one project, and get system error. I noticed you used "within" so I am assuming that you tried a formula like: CASE WHEN {transaction.type} = 'Sales Order' THEN…

in Project Saved Search with Multiple Sales Orders Comment by Ivy Lopez-Oracle Apr 30, 2025 3:56PM

Hi @User_AFQQQ, 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 the…

in Problem with vendor preferred in item Comment by Ivy Lopez-Oracle Apr 30, 2025 1:37PM

Hi @Dext3r, 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 the meantime,…

in How long do integrations take? Comment by Ivy Lopez-Oracle Apr 30, 2025 12:52PM

Hi @User_7NK3Q, can you share the NS_CONCAT formula you used? Appreciate if you can send a screenshot of the Results tab of the search and the exact error message you are encountering.

in Project Saved Search with Multiple Sales Orders Comment by Ivy Lopez-Oracle Apr 30, 2025 9:51AM

Hi @HX_SUBHANKAR, 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 the…

in Invoice CSV import is not working with other unit(not the primary sales unit) Comment by Ivy Lopez-Oracle Apr 30, 2025 9:46AM

MFA for Oracle Community

Ivy Lopez-Oracle · SCM Guru · Red Diamond

Comments