Hi @User_CFAIE, 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.

Glad I could help, @Dylan Moore! By the way, we'd really appreciate it if you could take a moment to click "Yes" on "Did this answer the question?" below the comment/s that helped in your concern. This helps others with the same question find the answer quickly, and you'll earn points and unlock the Answer Accepter badge.

Hi @KNason76, Try this in a Transaction Saved Search: You can then add the custom item field that you need to use as a filter.

Hi @SuiteSolvers, 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. -- Thanks…

Hi @User_66058, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our guru @Michelle Jabanes-Oracle to take a look at your question and provide you with her insights. In the meantime, if any other members have any thoughts, ideas, or suggestions, we encourage them to share them with you.

Hi @User_75YL8, We're glad you posted your question in the NetSuite Support Community. We have notified our gurus about your question and they will be checking in soon. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

When you say "missing a value", do you just mean that you want it to show as 0 instead of blank? If so, then you can use this formula instead: CASE WHEN {item.type} IN ('Inventory Item','Kit/Package') THEN (NVL({quantitycommitted},0)-NVL({quantity},0)) ELSE 0 END or if you want to consider only those lines that have not…

Hi @Benjamin Paul - USA, I hope you're doing well! I just wanted to check in and see if my previous comments helped answer your question. If you found it helpful, please consider clicking "Yes" on "Did this answer the question?" This helps others with the same question find the answer quickly, and you'll earn points and…

Hi @User_8HVD5, I hope you're doing well! I just wanted to check in and see if my previous comments helped answer your question. If you found it helpful, please consider clicking "Yes" on "Did this answer the question?" This helps others with the same question find the answer quickly, and you'll earn points and unlock…

Hi Nickey, I hope you're doing well! I just wanted to check in and see if any of my previous comments helped answer your question. If you found it helpful, please consider clicking "Yes" on "Did this answer the question?" This helps others with the same question find the answer quickly, and you'll earn points and unlock…

Hi @asha.jena, 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…

Hi @Shaun Logan-Oracle, 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…

Hi Berkley, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Katerina Winklerova-Oracle and @Micah Timbol-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 other members…

There is an option to Lock Transactions, but this is possible only if the Accounting Periods feature has not been enabled. If you use Accounting Periods, then the only way to stop changes to GL Impact is to close the period.

Hi Dylan, I tested this out but it is working on my end. Can you provide screenshots of sample results that is not working as expected for you?

It's not only the specific transactions that affect costing. All other transactions of the item/component may affect the average cost. Once you close the period where the transaction was posted, the costing should not run for the transaction anymore. However, if you reopen the period, the costing calculation might be…

Hi Nickey, Looks like there has been a costing recalculation that occurred. Normally this is triggered by the system to correct the costing of the items. You can check SuiteAnswers 28147 which explains System Cost of Goods Sold Adjustments in detail. You can check on Setup > Accounting > Inventory Costing Preferences if…

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

Hi @tech work, Currently, adding values of the Scrap Quantity field in the Saved Search is not yet available in the standard NetSuite account. This is logged as an enhancement request under Enhancement # 252217 - Manufacturing > Work Order Completion > Please expose Operation, Quantity and run time fields to transaction…

Hi @KaylaM, Per checking, this might be related to an ongoing issue 715889. As this is a critical issue as you can't access the system, it is highly recommended that you call our support hotline 1-877-NETSUITE. (1-877-638-7848)

Hello @User_8HVD5, Are you getting the error when you go to the page or when you try to save it? Ensure that these fields are filled out in the Main Line when creating a work order: Subsidiary Location Assembly Bill of Materials Bill of Materials Revision Date Quantity Production End Date If you still encounter the error,…

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.