@Dominica Sevilla-Oracle Thanks for the quick response. It is a transaction saved search. The Criteria is set as

@KNason76 This is what I have built to identify ours. Hope it helps! :) Criteria Tab Results Tab

@Ivy Lopez-Oracle Thank you so much! Worked Perfectly. :)

Hi @Ivy Lopez-Oracle For all locations

@Ivy Lopez-Oracle you are amazing! Thank you so much for your help. The formula worked perfectly. :)

@Shamaine Chan-Oracle Thank you for the information

thank you @Pauline Joy Cac-Oracle I appreciate the help.

thank you @Pauline Joy Cac-Oracle I appreciate the help.

@Shamaine Chan-Oracle appreciate the help in answering my question. We set it at 60 Days and created an alert via saved search when it hits the 30 day mark

Thanks @Ivy Lopez-Oracle

@Camille Cagalingan-Oracle Thank you for the response!

Thank you @Joy Noreen Magoling-Oracle

@JohnCirocco @Pierre_Plourde Thanks for the info. I appreciate the help. :)

Hi @Jack Daryl O Espiel-Oracle Thank you for the help. Are the Item Fulfillment records created first before Invoices and Cash Sales? Yes, they are done before billing Are there instances where there are multiple Item Fulfillments associated with a Cash Sale/Invoice? Yes, we usually have multiple fulfillments Is the value…

@JohnCirocco I pulled up an inventory item and did not see that field. I then edited the form and it does not show anywhere. I looked through all tabs and it doesn't seem to be there?

@Pierre_Plourde The funny thing is, I see this field is set to show on my form, but can't locate it anywhere. I even tried switching to the standard form and still nothing. Ahhh the mysteries of NetSuite lol What is even more puzzling, is I tried moving the field over to the Purchasing tab and when I tried, the field…

@Pierre_Plourde Where do I find "Can Be Fulfilled/Received" checkbox? I don't think I have ever noticed that before.

HI @Pierre_Plourde I double checked that and we do not have that marked. Which makes this even more puzzling.

This is where the fields are on the IF screen

@Jack Daryl Espiel-Oracle you are a genius! Thank you so much. Works perfectly now. :)

Thanks @Jack Daryl Espiel-Oracle!

Hi @Jack Daryl Espiel-Oracle Here are the results. Typing the serial number in the box, I would like it to return the document information

@JohnCirocco Quick question. I am setting this up and I need to select All Customers and it will just run on those in the saved search, correct? Forgive me if that is a silly question, but we previously did not have just selected customers via a search.

Ahhhh, how did I miss that? Thanks @JohnCirocco !!! You rock!!!

@Jack Daryl O Espiel-Oracle Thanks Jack! I will test this

@Jack Daryl O Espiel-Oracle HI Jack. Yes it is a transaction search and the custom fields are Column fields on the lines of the SO and IF

@Shamaine Chan-Oracle Vendor Name also worked. Not sure how I missed those. Thank you for the help. :)

@JohnCirocco Thank You! You are a genius. :) Main Line Name worked perfectly. Appreciate the help.

Thanks @Red Atok-Oracle the issue is that it never makes it to a Picked Status. The sales team emails the pick ticket and some are not getting printed, so it is lost in limbo. I can easily identify our B2C customers because they don't have partial fulfillments. Our B2B customers could have 10 different fulfillments from…

Thanks @JohnCirocco! Worked perfectly!