web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Products in the invoice "advanced Filter"

(0) ShareShare
ReportReport
Posted on by 125

Is it possible to filter on the Invoice en see the sold products / Invoice?

On the Invoice are choosen Existing products, I see in the filter all the Invoice fields but
now Products fields.

 

Example: I want to know: What Who sold on and wat price each product is.

Kind regards!

*This post is locked for comments

I have the same question (0)
  • Ted Profile Picture
    125 on at
    Re: Re: Products in the invoice "advanced Filter"
    Hi Yaniv, First, thank you for your answer. We work unfortunately with CRM 3.0.
    So this may be a good reason to upgrade to 4.0.
    Again, Thanks

    Ted.

     

  • Yaniv Arditi Profile Picture
    3,990 on at
    Re: Products in the invoice "advanced Filter"

    Hi Ted,

    You can't use Invoice Product as the main entity in Advanced Find but if you are using Microsoft Dynamics CRM 4.0 you can use the Report Wizard to query the information you need.
    In the report building form select the Invoice as primary entity type and the Invoice Product as related record type. This will enable you to group Invoice products by Invoice and access the Invoice and Invoice product data.

    Hope this helps.

    Yaniv

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#3
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans