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…

Thanks for providing that information. I just tried it on my account, but I don't encounter the behavior that you mentioned. All the Work Order Close records are showing up on my end, when the Main Line = True. I also checked it initially and there are no other documentation of this behavior. Can you check if there are any…

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

https://community.oracle.com/netsuite/english/discussion/comment/16856585#Comment_16856585 Can you clarify what you mean by this? What error are you encountering? I believe what @Tris Mendoza-Oracle is saying is that in the Transaction Saved Search, you can directly use the field called Built which will pull up the Build…

https://community.oracle.com/netsuite/english/discussion/comment/16856584#Comment_16856584 Thanks for clarifying. Can you share the Criteria and Results tab of your search so we can try and replicate on our end?

https://community.oracle.com/netsuite/english/discussion/comment/16856399#Comment_16856399 I recently wrote an article explaining this behavior: https://community.oracle.com/netsuite/english/discussion/4492241/nsc-transaction-saved-search-work-order-main-line-f-show-header-details-in-component-lines Custom line field is…

https://community.oracle.com/netsuite/english/discussion/comment/16856283#Comment_16856283 You can try the search documented in this discussion: https://community.oracle.com/netsuite/english/discussion/4492295/nsc-saved-search-that-shows-work-orders-and-component-items However, note that this is a transaction search, 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…