Ivy Lopez-Oracle

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 book specific je saved search - account number Comment by Ivy Lopez-Oracle Apr 8, 2024 3:41PM

Hi @Micah Mouw - PowerSchool, 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 Date Payment Applied? Comment by Ivy Lopez-Oracle Apr 5, 2024 4:13PM

Hola @Eddson NM, 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 MAP_ERROR: El recuento de segmentos personalizados en la categoría no equivale al número del registr Comment by Ivy Lopez-Oracle Apr 4, 2024 4:19PM

Hi @jmack_admin, 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 Email Message Template Used for Bulk Invoice Sales Orders Comment by Ivy Lopez-Oracle Apr 3, 2024 3:55PM

Hi @NSPK, 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 apply credit memo from parent to child? Comment by Ivy Lopez-Oracle Apr 2, 2024 3:41PM

Hi @Tammy Stewart, 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 Issues uploading CAMT053 bank file Comment by Ivy Lopez-Oracle Apr 1, 2024 3:50PM

Hi @User_NG5TG, you can try if these would work for you: Between specific dates for the new value: CASE WHEN {systemnotes.field} = 'Exp. Close Date' AND TO_DATE({systemnotes.oldvalue},'DD/MM/YYYY') BETWEEN TO_DATE('1/1/2024','DD/MM/YYYY') AND TO_DATE('31/3/2024','DD/MM/YYYY') AND…

in Opportunity: Exp. Close Date moves from Q1 to another Quarter Comment by Ivy Lopez-Oracle Mar 27, 2024 5:56PM

By the way, did you use the exact formula provided above? Or did you perhaps edit the date from 3/31/2024 to 31/3/2024? I ask this because I noticed in the previous screenshots that your date format seems to be DD/MM/YYYY. It seems that the error you are encountering may be related to the date format set on your account as…

in Opportunity: Exp. Close Date moves from Q1 to another Quarter Comment by Ivy Lopez-Oracle Mar 27, 2024 1:11PM

Hello @User_NG5TG, can you share screenshots of the Criteria and Results tab of your search wherein you received the error? Did you only add the provided formula in the Criteria or was there another formula you added?

in Opportunity: Exp. Close Date moves from Q1 to another Quarter Comment by Ivy Lopez-Oracle Mar 27, 2024 12:28PM

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 credit card doesn't default on sales order Comment by Ivy Lopez-Oracle Mar 26, 2024 4:06PM

Hi @Ann Wakefield, 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 class is not showing on a return Authorization Comment by Ivy Lopez-Oracle Mar 26, 2024 3:45PM

Hi @Pallavi1903, 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 add a tax inclusive amount on an Expense Report Comment by Ivy Lopez-Oracle Mar 26, 2024 3:38PM

Hi @User_VRTQP, 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 Report Request - Customers that were not invoiced last month Comment by Ivy Lopez-Oracle Mar 26, 2024 3:31PM

Hi @User_VRTQP, 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 Seeing other's User Notes Search Comment by Ivy Lopez-Oracle Mar 26, 2024 3:31PM

Hey there @User_NG5TG, Kindly try this: SUM(CASE WHEN {item.type} = 'Inventory Item' THEN {estgrossprofit} ELSE 0 END)/NULLIF(SUM(CASE WHEN {item.type} = 'Inventory Item' THEN {amount} ELSE 0 END),0) Also, for your formula GP% for Non-inventory Items, I noticed in your screenshot that you used a capital letter I. It should…

in CASE WHEN and formula issue applying transaction type used. Comment by Ivy Lopez-Oracle Mar 22, 2024 6:55PM

Hi @MTL_MIA, 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 it possible to a vendor with Vendor Center access to modify a purchase order? Comment by Ivy Lopez-Oracle Mar 22, 2024 4:17PM

Hi @Ken Davies, 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 Possible to associate multiple work orders to one sales order? Comment by Ivy Lopez-Oracle Mar 22, 2024 4:12PM

Hi @User_WA9MO, 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 Specific Report for Cash Advance - Employee Comment by Ivy Lopez-Oracle Mar 22, 2024 4:10PM

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 the…

in Do not allow back order at item level Comment by Ivy Lopez-Oracle Mar 21, 2024 3:58PM

Hi Angela, Thank you for posting here in the community! I initially checked my resources if anyone else filed a similar case, but I didn't find any. Let's see if any of our other members encountered this error and how they were able to resolve.

in 2024.1 Broke Auto Lot Numbering Suiteapp Comment by Ivy Lopez-Oracle Mar 20, 2024 3:39PM

Hi @Eunice_Rep, customization (scripting/workflow) is not really my strong suit so I can't say for sure if it can be done or not. However, in theory, if you have a field in the customer record where you can store the default discount item for the customer, then you might be able to use a workflow to source it to the…

in New to NetSuite | Pricing 101: Price Levels Comment by Ivy Lopez-Oracle Mar 20, 2024 2:05PM

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 Report for emails and texts report Comment by Ivy Lopez-Oracle Mar 19, 2024 4:02PM

Hi @User_RLV0D, 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 can I change the Check template for bills of vendors? Comment by Ivy Lopez-Oracle Mar 19, 2024 3:52PM

Hi @User_ZCWF3, 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 Workflow Action Script Comment by Ivy Lopez-Oracle Mar 19, 2024 3:35PM

Hi @User_E5P4R, 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 Analytics: Vendor Name for Expense Accounts Comment by Ivy Lopez-Oracle Mar 19, 2024 3:33PM

Hi Eunice, This is the standard behavior when using price levels. Since the discount amount is also not shown in the transaction. If you want to show the discount, you might want to consider using Discount Items, which I discussed in below article: Unfortunately, I am not familiar with customizing advanced pdf documents,…

in New to NetSuite | Pricing 101: Price Levels Comment by Ivy Lopez-Oracle Mar 19, 2024 2:19PM

Hi @FazeprooF, 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 Error while setting up supply planning Comment by Ivy Lopez-Oracle Mar 18, 2024 3:45PM

Hi @J.Wang1, 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 Best way to hide old transaction in match bank data page Comment by Ivy Lopez-Oracle Mar 15, 2024 3:50PM

Hi @User_4B6IN, 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 Tax Code Error on Journal: Invalid Tax Code(s): -- Tax Accounts Not Defined. Comment by Ivy Lopez-Oracle Mar 14, 2024 4:14PM

Hi @CPAGrrrl, 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 Supplier ID Character Limit Comment by Ivy Lopez-Oracle Mar 14, 2024 3:43PM

MFA for Oracle Community

Ivy Lopez-Oracle · SCM Guru · Red Diamond

Comments