Thank you Herdi Rana-Oracle! Very helpful!

Thanks Herdi Rana-Oracle

@@"JCirocco" Thank You! Yes that was the issue. As always, appreciate the help.

@"Camille Cagalingan-Oracle" Thank you! The formula worked perfectly!

Thanks Everyone! @"coffeeguy" @"Chris.Wognum" @"JCirocco" @"Jack Daryl Espiel-Oracle" We were able to get this to work. As always, thank you for your help!

Thanks @"Camille Cagalingan-Oracle"

@"Herdi Rana-Oracle" thank you so much! It worked perfectly.

Yes. I was able to get the Total Sold formula and it is calculating correctly, but the Qty Sold - Limited Edition Qty is not working.

@"Herdi Rana-Oracle" the custom field is now showing up for me to add to the search.

Thanks @"JCirocco"

@"Camille Cagalingan-Oracle" thank you for the screen shots. Very helpful!

@"Herdi Rana-Oracle" thank you so much! I will give this a try and let you know.

Hi @"Herdi Rana-Oracle" it was a system error and NetSuite was able to fix by the following day

Hi @"Herdi Rana-Oracle" the criteria is below. I also removed exclude item group to show you what it looks like. What I would like to see is the item group that appears above the components to show to the left of the item so the sales team can easily identify.

Thanks so much!

Thank you!

@"CYBuser" I had an issue with trying to delete thousands of item supply plans. One of the guru's suggested the mass delete tool is provided by Techfino at https://www.techfino.com/blog/netsuite-mass-delete-tool and works off of saved searches. It was a lifesaver. Hope it helps!

Yes, your formula is a bit more advanced than mine but we are able to catch as soon as it happens. We do not copy any sales orders or use memorized transactions. I just got off the phone with support and we also noticed something weird, the est unit cost is calculating at qty/avg cost on the item that has the incorrect…

Thanks Chris

@"Chris Dobbins" after implementing the script, have you seen any further issues?

@"Shamaine Chan-Oracle" The original case was 3617909 (Nov 19th) in which I called in and spoke to someone and we walked through the Sales Order. We had already corrected the sales order, so didn't really see anything. System notes and the history on the line item was not showing any price overrides. I then set up a saved…

@Michelle Jabanes-Oracle Thank you!

It is an inventory item

Thanks @"Shamaine Chan-Oracle". We do have Advanced Shipping enabled. The Controller is wanting a way to select multiple sales orders that have been fulfilled and bill one invoice. I don't think there is any way the system can do that, I looked at this about 5 years ago. But wasn't sure if something new was available since…

Thanks Jack! I did not know that.

Update: It wasn't the workflow, it had something to do with the saved search. I tried another one for ALL customers, not just limiting it to those that I have assigned to me. When I executed in test mode, it generated 28 emails. That number seems a little low and don't see any for our large customers, but I am working on…

Thanks Jack. Yeah, I've tried both Release to trigger on the schedule and testing execute now. Can't seem to find what is preventing it from working. Nothing posts to the customer record.

Thanks Mikko!

I deleted the question. We figured it out.

I duplicated your action and still nothing. I am sure it is something small I am missing. I don't get any type of error. I appreciate the help.