CRM 4.0 Advanced Find/Reports RRS feed

  • Question

  • Hi,

    I'm trying to create either an advanced find view or a report which can filtering on:

    All orders which do not have at least one invoice

    Is that possible?


    Friday, May 30, 2014 10:20 AM

All replies

  • To do this you'd need a Reporting Services report, using a SQL query. Here's a basic query structure

    select * from FilteredSalesOrder where SalesOrderId not in (select SalesOrderId from FilteredInvoice where SalesOrderId is not null)

    This is not possible with Advanced Find in CRM 4.0

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Friday, May 30, 2014 1:26 PM