Joy, Thank you for the answer. I have one problem. I am unable to find "Applying Transaction : Type" under Standard. I have "Applying transaction" and then it wants me to select a specific work order issue.

Your awesome! I got the report running perfectly!

I apologize, I mean the location name that I enter into the formula

Joy, Where can I find the custom names in Netsuite?

Ivy it is a custom field. Unfortunately I still can't find it.

Ivy, Appreciate all the help. I really wish there was some way to see all. Your reports will be very useful. Last question, I promise... Is there away to add one column to your report, "Quantity still open on all work orders"

Ivy, I apologize, I've been running around. It looks like I couldn't get it to populate. Maybe I should explain what we are fully want to show and see what you think. We are trying to plan machine ship dates by reviewing parts that have not been pulled on a work order vs the purchase orders open with expected dock dates.…

absolutely. We would like to see total open allocations for each part on a work order company wide. For example, If we have 5 work orders open and each work order requires 1 of the same part, we would like it to show a Total Demand of "5".

Ivy, You have been super helpful with this. If I am unable to create the search with both, Is there away to just show the total part demand in this specific search?

Ivy, what if I wanted to use the Vendor confirmed date? What would I replace ({transaction.expectedreceiptdate}) with?

Oliver, This is a great idea. Do you mind doing a screen shot of the whole report criteria? I'm still new to searches