Jay Schwausch Bronze Medal

Ivy, Thank you for your response. Curiosity got the best of me on the suggestion to try Name instead of Bill of Materials : Revision : Name. It actually removed 5 results. But as for the effective start date, that is the catch. Don't ask why - it takes you down a rabbit hole I don't want to take anyone. One of our…

I created a Saved Bill of Materials Revision Search. Criteria: Results:

Sorry. Really bogged down. Will get details to you soon.

Yes, Thank you. My apologies. I thought I already marked this as Answered.

@Nicole Mendoza-Oracle Thank you for your kind compliment. It could not have come at a better time. Greatly appreciated.

Started over from scratch and it now works. Don't know what I did wrong. Sorry to bother y'all again.

My bad. Please disregard. I finally noticed that I had Main Line = True on by mistake.

Thank you so much for your help!!! The issue was I simply left out the needed parenthesis.

Thank you. I look forward to working this out.

@Joahnna Given Uy-Oracle Thank you for your update. At least now I know why I could not find the field.

@Tigran Shahnazaryan btw, I tried to paste in a screenshot again but the system is giving me a permissions error. Ditto if I try to use the attach icon (paper clip) below. ???

@Tigran Shahnazaryan Sir, that is the root of my problem. Before i came to the Oracle group for assistance, I went to Transaction Line Fields, but the field is not listed there. This is why I am at a loss as to how to find it. I did find it as a field in a Workflow. It was called Expected Ship Date (Line).

@Tigran Shahnazaryan ¿ relevant custom field subtabs ? Can you be more specific as to what you actually are asking for?

Joahanna, Thank you for trying to assist. Unfortunately, that is what I am trying to discern. I need to use the field in a Saved Search, but do not know how to find the technical field name to do so. Here is a screenshot of where it appears on the Sales Order screen.

Joy, I was able to resume working on this today. ! ! ! AWESOME ! ! ! Your suggested solution worked like a charm.! Thank you very much.

@Gautam Mishra Thank you for you quick response. I will proceed as per your suggestion.

At the time, we had NetSuite ACS and they eventually told us we need to get support from BarTender to handle any issues.

Resolved. As it turns out, I found a way to use "Main Line - True". The catch is I had to scroll down to "Invoice No. (Custom) Fields..." and select "Main Line is True".

Joy, Thank you for the suggestions. I will be trying them out as soon as possible.

Since the field I am addressing is a custom field, I thought that might make things difficult for the NetSuite group. So, I have resolved the issue by writing a separate workflow that sends an email to the appropriate person notifying them of the PO needing approval (with a link to the PO). Therefore, you may consider this…

Just to be certain we are on the same page / have the same understanding, I would like to add a small phrase into yours... A. If the Subsidiary = 'KVH' the value should be HELLEN SONG. Else (Otherwise) If the Subsidiary is NOT 'KVH' then... If the employee is SUZANNE WOOD, the value should be SHELLEY SHMITS and if not, it…

Patrick, Thank you so much for your help !!! Your suggestion has solved my issue.

Thank you for your support. I have submitted the idea as you suggested.

Joahnna, Thank you so much for your response. I believe your response convinced me what I am trying to achieve is not possible. See details below and let me know if you agree it is not possible. 1st Screen that appears after running the Saved Search: 2nd Screen that appears after making selection: 3rd Screen (Final Screen)…

Correct, I only want to remove the column from the view of the printout. Type of search: Saved Bill of Materials Search Only criteria are: INACTIVE = False and... Bill of Materials : Subsidiary includes any of KVH, PRI

Thank you so much for your help! ? This did resolve my issue.

Ivy, that did it. ? POs and IAs are now both showing up. (Wait until Management sees the results went from 533 to 6,429. But this is what they asked for.) FYI: I did have to use the 3-Parenthesis version. Thank you very much!

Thank you for your prompt reply and suggestion. See results below... This setup... ... produced the following result: So, grasping for straws I tried a slight modification of the parenthesis as shown below. The result is that it gives me only the Purchase Order results - no Inventory Adjustments.

Done. Thanks for the reminder.

It looks like that fixed it!!! I will do some further confirmation on it tomorrow. Some times it is really difficult finding that one specific field that makes all the difference. Thank you, so much!