Ivy Lopez-Oracle · SCM Guru · Red Diamond

I recently wrote an article explaining this behavior: Custom line field is currently the only way to show assembly item in another column. Again, if you need further assistance on your search, I suggest that you post a new question here in the community.

You can try the search documented in this discussion: However, note that this is a transaction search, and is based on the component items that are used in the Work Order. The enhancement you mentioned is about creating an Item Saved Search that would show the current revision components. This is still not possible, and…

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

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

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…

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

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…

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…

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…

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…

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…

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…

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?

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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.

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…

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…

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…

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…

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…

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