The report I'm using is from Netsuite Answer ID#69737. The company I work for has a lot of assemblies and I'm trying to make a report that will show the raw part being used and not the finished part.

I have attached screenshots to show what is going on. As you can see on the pivottable I have Partially Fulfilled selected but it is showing everything on the sales order and not what is still open. I provided a picture of the sales order showing it is fulfilled Raw Part#1765-2003 (Assembly part#CG-2003FB).

Hi Dominica, The report I made is a web query and when I refreshed the data I found out we currently don't have any partially fulfilled orders in the system for me to take a screenshot for an example. When we have one I will take the screenshot and provide you pictures of what is showing up.