Hi Marcy730,

Try This.

Criteria Tab

Formula(text) |

CASE WHEN {put here field id} IS NOT NULL THEN 'T' ELSE 'F' END 

In order that you want to discuss this, please contact me for more details.

Regards,

Hi Stephan_Vireo,

You should try “Purchase by Vendor” detail report.

Navigate to:  Reports>Purchases>Purchases by Vendor

Let me know if you need any assistance.

Regards,

Hi VishalThoughts,

Try to add in criteria tab FIELD: ROLE and exclude all old roles.

This should work for you.

If you need any assistance,let me know.

Regards,

Hi, frank33210

If you look under the GL Impact located in Item Fullfilment, est.cost should be the same as COGS, if do you can use it in saved search instead.

Let me know if  I need it to build for you,

Regards,

Hi 4N15,

I don’t think so. Sorry.

Regards,

Hey choozlehannah,

For your information,do not use Report Builder if you have large results.

Could you please,share some screenshoots with me,so I can get into the issue ?

Kind Regards,

Slobodan Sobic

email: slobo.sobic@gmail.com

Hello darg6,

I hope this will helps you,

These are the products they have Transaction: Sales Order.

If I may to,for this type of Saved Search better use Transaction Saved Search not by the Item.

Kind Regards,

Slobodan Sobic

email: slobo.sobic@gmail.com