Ivy Lopez-Oracle

Hi @User_NG5TG, Based on the formula you provided, can you try if this will work: Formula: SUM({tranestgrossprofit})/SUM(NULLIF({netamountnotax},0)) Summary Type: Maximum

in Accumulated (Not Average!) GP % by Sales Rep Comment by Ivy Lopez-Oracle Sep 29, 2023 6:36PM

Sorry to hear that. However, other than this SuiteApp, there isn't anything else we can provide as this is not possible in saved searches. You can reach out to your developers or to your Account Manager for possible engagement with our ACS or Professional Services team for a customized solution for you.

in Bill of Materials Inquiry Comment by Ivy Lopez-Oracle Sep 29, 2023 6:15PM

Hi @CDuf, Try adding Item: Type is not Item Group in the Criteria. This should remove the parent item line (Item Group) but still show the components on the order.

in How to remove "End of Group" line from a transaction saved search? Comment by Ivy Lopez-Oracle Sep 29, 2023 6:10PM

You can vote and add your comments for Enhancement # 213226 in the SuiteIdeas page.

in Why is UPS SurePost not integrated into Netsuite Comment by Ivy Lopez-Oracle Sep 29, 2023 5:57PM

Hola @User_HPP0V, Estamos encantados de tenerle con nosotros hoy. Gracias por crear este hilo. Por favor, permita que nuestros gurús revisen su preocupación y realicen su investigación inicial. Nos pondremos en contacto de nuevo si tenemos novedades al respecto. Para nuestros otros miembros, siéntanse libres de compartir…

in Se puede reducir el numero de decimas en lo mostrado en el costo promedio en el articulo Comment by Ivy Lopez-Oracle Sep 29, 2023 5:17PM

Hi @Todd Juenemann, 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 pull SO Data to Custom Wave Pick Advanced PDF/HTML template? Comment by Ivy Lopez-Oracle Sep 29, 2023 5:09PM

Hi @Martha Hakes, 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 Is anyone else getting script errors today? Comment by Ivy Lopez-Oracle Sep 29, 2023 3:42PM

Hi @JDKru, Kindly try these steps: Go to Customization > Scripting > Script Deployments Filter the script > FEFO_UE_Sales_Order Click Edit Set execute as role to Administrator Click Save After these steps, try to process a sample sales order, then verify if the error still occurs.

in FEFO Permission Error Comment by Ivy Lopez-Oracle Sep 29, 2023 12:02PM

Hi @User_815U9, 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: Set up environment with "Dealers" and "End-Users" in NetSuite Comment by Ivy Lopez-Oracle Sep 22, 2023 4:24PM

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 Accumulated (Not Average!) GP % by Sales Rep Comment by Ivy Lopez-Oracle Sep 22, 2023 4:21PM

Hi @Amjad Kasem, Were you able to check 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 Answer Accepter badge.

in Downloaded Excel file is encryptor and can’t open it Comment by Ivy Lopez-Oracle Sep 21, 2023 9:19PM

Hi @Chandanesh, Were you able to check the accounts used in the item record and the landed cost item? Let us know if you need further assistance on this.

in Landed Costs are adding to "Material Usage Variance" instead of "Inventory account" Comment by Ivy Lopez-Oracle Sep 21, 2023 9:09PM

Hi @Yee Yie, were you able to submit a case for this? Let me know if you need help in submitting a case. It would also be greatly appreciated if you can share Support's findings here in this thread as it can also help other members who might encounter the same scenario.

in [Advanced Manufacturing] Finite Scheduling: Unable to Release Work Order Comment by Ivy Lopez-Oracle Sep 21, 2023 9:07PM

Hi @Elizabeth Vance, 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 Permission to revalue fixed asset Comment by Ivy Lopez-Oracle Sep 21, 2023 4:39PM

Hi @User_GNSOF, 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 What will become of items created while in release preview mode Comment by Ivy Lopez-Oracle Sep 21, 2023 3:49PM

Hi @Janet P, 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 Why has the logo on the NetSuite Browser tab changed Why is the NetSuite Status site not working? Comment by Ivy Lopez-Oracle Sep 21, 2023 3:44PM

Hi @Chandanesh, Can you please verify the accounts used in the Item record and landed cost item? Appreciate if you can send screenshots of these.

in Landed Costs are adding to "Material Usage Variance" instead of "Inventory account" Comment by Ivy Lopez-Oracle Sep 20, 2023 4:53PM

Hi @emcee_uk, 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 Create multiple assets from a single journal Comment by Ivy Lopez-Oracle Sep 20, 2023 4:36PM

Hi @Wellyntong, 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 Global Invoice Account field in accounting preferences Comment by Ivy Lopez-Oracle Sep 20, 2023 4:27PM

Hi @User_ZKPQL, 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 Creating a Dashboard Portlet for CSV Import Status? Comment by Ivy Lopez-Oracle Sep 20, 2023 4:21PM

Hi @User_EK47U, 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 Sales Order Approval Workflow for The Advanced Partner Center Role Comment by Ivy Lopez-Oracle Sep 20, 2023 4:18PM

Hi @User_MAN7R, seems like this the same question as the previous thread you posted: NetSuite Bank Reconciliation To avoid confusion, let's continue the discussion there. 😊

in Bank Reconciliation Matched transactions Comment by Ivy Lopez-Oracle Sep 20, 2023 4:15PM

Hi @User_MAN7R, 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 NetSuite Bank Reconciliation Comment by Ivy Lopez-Oracle Sep 20, 2023 4:12PM

Thanks for the update, Ted!

in Transfer Errors Comment by Ivy Lopez-Oracle Sep 20, 2023 3:13PM

Hi @Amjad Kasem, I checked this on my end, and it seems that this error is not on NetSuite side, but more on your computer/laptop's settings. I did a quick google search and found these articles which might help: The document may be read-only or encrypted (from theborderofamind.com) the document may be read-only or…

in Downloaded Excel file is encryptor and can’t open it Comment by Ivy Lopez-Oracle Sep 20, 2023 2:57PM

Hi Ted, Were there recent customizations done in your WMS account? I checked my resources regarding this one and it seems that related concerns show that the error may be caused by outdated version of app after a customization. If you are still experiencing the error, I highly suggest that you submit a Case so that it can…

in Transfer Errors Comment by Ivy Lopez-Oracle Sep 20, 2023 2:10PM

Hi, you can try to explore the Costed Bill of Materials SuiteApp.

in Bill of Materials Inquiry Comment by Ivy Lopez-Oracle Sep 20, 2023 1:06PM

Hi @Yee Yie, thanks for checking. Since this is still not working as expected, I suggest that you submit a case for this to be further investigated by our Support team as this might be a potential defect. Let me know if you need help in submitting a case.

in [Advanced Manufacturing] Finite Scheduling: Unable to Release Work Order Comment by Ivy Lopez-Oracle Sep 19, 2023 5:55PM

Hi @Andy Bruner, 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 Why is State not saving in Customer Address? Comment by Ivy Lopez-Oracle Sep 19, 2023 5:40PM

Hi @CDuf, 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 Is there a limit for Scheduled Workflows? Comment by Ivy Lopez-Oracle Sep 19, 2023 4:18PM

Ivy Lopez-Oracle · SCM Guru · Red Diamond

Comments