Can you share more details of your search so we can try to replicate on our end? Appreciate if you can provide screenshots of the Criteria and Results tab.

Hi @Preethi Kondur, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you. In…

Hi @User_7MHGN, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @kees.netsuiteadmin, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you.…

Hi @Dylan Moore, Thanks for reaching out to us in the NetSuite Support Community. Can you try if this formula works for you: CASE WHEN {item.type} IN ('Inventory Item','Kit/Package') THEN (NVL({quantitycommitted},0)-NVL({quantity},0)) END

Hi @User_V5KBL, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Patrick Fresnosa-Oracle and @Clarisa De Torres-Oracle to take a look at your question and provide you with their insights on this. Please allow them some time to investigate and get back to you. In the meantime, if any…

Hi there @JohanvL, Thanks for reaching out to us in the NetSuite Support Community. To better assist you with this, please provide more information on your requirement. What orders are you trying to compare? It would also be good if you can provide examples/screenshots so we can better visualize. In the meantime, if any…

@Benjamin Paul - USA, Try this in your transaction saved search: Criteria tab: Formula used: NULLIF(({quantity}-NVL({quantityshiprecv},0)-NVL({quantitycommitted},0)), 0) Results tab: Formula used: NULLIF(({quantity}-NVL({quantityshiprecv},0)-NVL({quantitycommitted},0)), 0)

Hi @User_HWW8S, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @User_TL7B6, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Richard James Uri-Oracle, @Nicole Mendoza-Oracle, @Jack Daryl Espiel-Oracle and @Joahnna Given Uy-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and…

@Benjamin Paul - USA, The Back Ordered column is in the Sales Order. But in your previous comment, you mentioned you wanted the Purchase Order information. Is this correct? Can you provide examples or further illustrate your requirement?

Hi @User_EVVPG, Thanks for posting another question here in the community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @Nickoletta Gounaris, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to take a look at your question and check if this is possible. Please allow them some time to investigate and get back to you. In…

Hi @StevenGreen, Welcome to the NetSuite Support Community! We're thrilled to see new members like you joining our community and reaching out for help. Per checking, it seems that the ability to mass update/calculate total item weight for assemblies once the weight of a member item of multiple assemblies changes is not yet…

Hi there @Martha Hakes, Thanks for posting another question here in the community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hello @User_DATN1, Per checking, it is not yet possible to link Assembly Unbuild record with Assembly Build records. There is an existing enhancement requesting for this functionality and is logged as: Enhancement # 77321 : To link the Assembly build and Assembly unbuild, so that if an assembly build created from a work…

Wow! Congratulations @Brian Stisser! Thanks for helping our community! 😊

Hi @Benjamin Paul - USA, I remember you have posted a similar question before: Is this a different question?

Hi @Martha Hakes, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @faisalabdulmoid_39498, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Patrick Fresnosa-Oracle and @Clarisa De Torres-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you. In the meantime, if any…

Hi @BryanL, Thanks for posting another question here in our community! I actually tried this on my test account as well, and got the same error. I found it weird because when I manually typed in the same formula, it worked: CASE WHEN {item.inventorylocation} = 'Warehouse' THEN {item.locationquantityavailable} ELSE NULL END…

Hi @Wendy_M, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hello @User_0RQ7O, Just wanted to check in if you were able to see the possible solution provided in 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…

Hi @FazeprooF, I tried it on my test account and was able to reproduce what you mentioned. As a workaround, please try using a Formula (Date/Time) field instead, and use the formula: {lineitemenddate} (which is the field id of the Line Item End Date field).

Hi @Kellyann, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Dominica Sevilla-Oracle and @Elychelle Gulen-Oracle to take a look at your question and provide you with their thoughts. Please allow them some time to investigate and get back to you. As initial troubleshooting, can you…

Hi @User_HPB3I, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. Please allow them some time to investigate and get back to you. As an initial troubleshooting step, can you check if there's anything entered in the…

Hi Audrey @User_HQRSY, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you.…

Hello @Ivan Babiichuk, Try adding these fields in your Results tab:

Hello @User_0RQ7O, Try this: Formula: CASE WHEN {systemnotes.newvalue} = 'Shipped' AND {systemnotes.date}-({now}-(1/24)) < (1/24) AND {systemnotes.date}-({now}-(1/24)) > 0 THEN 1 ELSE 0 END

Hi @Dext3r, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. Please allow them some time to investigate and get back to you. In the meantime, if any other members have any thoughts, insights, or suggestions, we…