Hi Jack Great to meet you. I tried to create the sublist as specified but I could not see it. I made a saved search and then went to Customisation - Forms - Sublists. I found the saved search in the dropdown list and gave it a label and saved it. However I cannot see this list anywhere on Netsuite, where will it appear…

Thank you for your help Shamaine. This community is amazing. I greatly appreciate your time. Thank you.

There might be another way around this: I have compiled an ITEM search which has given me the necessary breakdown - but in the Expected receipt date it is blank. Essentially these items are on purchase orders. How do I get it to display the purchase order item expected receipt date? Screenshot below to assis

Hi Shamaine Thank you very much for your time and the answer. The formula that you have provided shows the Work Order number, thank you very much. However it does not display the items that are in the Work Order, is there any way to expand this? Thank you.

Thank you, just to expand here is a screen shot to help explain. The item showed contains a number of other lines. How do I get the open sales order saved search to show these items:

Don't worry!!! I missed the ( ) Now it works, problem solved. have a great day all.

Dear John I owe you an apology. You are correct, I was set on transactional search. I changed it to item search and it worked perfectly as you said it would. I have wasted your time and my time and I am sorry for that. I hope that you had an enjoyable weekend and I thank you for all your help. Oliver

Hi John Thanks for your response. It would not let me alter the description and classification fields without having Item in front of them. So I just deleted them in case they were causing the problem. I then changed the formulas as specified but it gave me an error. Screenshots below. Thanks again for all your time, you…

Hi Dominica I have acted on your feedback recommendation. Thanks again for your time. Let us hope a similarly wonderful outcome can be reached on displaying all inventory items as this is also a vexing issue. Have a great afternoon. Oliver

Hi John, yes it is an item search. I want to show all items that are on our inventory database. Screenshot below. Thank you for your time.

Thank you. When I do an inventory snapshot report, I can see all the items. But for various reasons I want to use a saved search, how do I see the same long list from a search? Appreciate your time.

Good morning Dominica and John Thank you so much for your help. This has had the desired effect, I am very grateful. However it has thrown up another problem. We have items that I know should be in this list, that are out of stock, but they are not showing up, how do I make such a search show items even if they are not in…

Hello Dominica, and John. Thank you both for your kindness in helping me. I am going to sleep now as I have been working on netsuite for many hours now. I will try out this formula in the morning. but just to check, I already have an Items Committed column, will this formula create a new column of its own or will it stay…

Hi John. thank you for your suggestion. just to clarify, I have a saved search that is quantifying stock and working out what we need to order. all I want is for any column where there is null value it has a 0, so where do I put such a formula? Am I putting it criteria or results and if so where?

okay. so i got the formula to work. But it just filters out the entire column. I want to display the 0s in the column of there is no value.

Hi Dominica. I have gone for a slightly different approach and will be compiling the date a different way. now in my saved search I just want to display a 0 in the column if there is no value. i have tried the below but it is not working.

Hi Dominica thank you so much for your answer. that is close to what I want, but I already have the items on a saved search of open order numbers, what I want to do is use a formula the searches the database for open sales orders that contain an item on the list, and displays the SO number on the same line as the PO number…