Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 4.0 Advanced Find/Reports RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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?

    Thanks

    Friday, May 30, 2014 10:20 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    Moderator