locked
Help, please [Change lookup to show all records, not just 'active' status] RRS feed

  • Question

  • Hi, all!!
    Please help. I have a problem. I have my entity "plateg". Ana i have a 1:N relationship between  Invoice and "plateg".
    When i try to choice an invoice from a "plateg" form i see all active invoice. But i want to see all invoice ( closed, paid... too). Can i  do it? Is it possible?
    Friday, April 17, 2009 12:01 PM

Answers

  • Hi Elka,

    you have several options for solving this.

    1. In a Pre-Plug-In you can manipulation the RetrieveMultiple message of invoice so that a query for active invoices only will retrieve all invoices. But this a a side-effect to all RetrieveMultiple messages where you want explicely to see active invoices.
    2. You can develop a custom ASP.NET application with a datagrid which displays all invoices for a given plateg. With the isv.config you can display this datagrid in a plateg form.
    3. With the "Filtered Views" of stunnware (http://www.stunnware.com/) you can display all invoices for a given plateg.

    Best regards,
    Jürgen

    Jürgen Beck

    Dipl. Kfm./Wirtschaftsinformatik
    MVP, MCSD.NET, MCITP DBA, MCDBA, MCSE
    Microsoft Certified Business Management Solutions Professional
    Microsoft Certified CRM Developer
    Microsoft Certified Trainer

    ComBeck IT Services & Business Solutions
    Microsoft Gold Certified Partner
    Microsoft Small Business Specialist

    Developing & Supporting Business Applications from small business to big enterprises covering scores of sectors

    http://www.combeck.de
    Sunday, April 19, 2009 12:20 PM
    Moderator

All replies

  • Hi Elka,

        As far as i know you can not change the behaviour of the lookup. 
    A possible work around could be that you set the status of the invoice using a Picklist rather than setting the status via the default menu options.

    H.

    http://hassanhussain.wordpress.com/
    Friday, April 17, 2009 12:20 PM
  • Elka,

    Please don't use "Help" as a subjet.  Enter a topic that will serve others searching for the same answer.

    thanks
    Friday, April 17, 2009 4:57 PM
  • Hi Elka,

    you have several options for solving this.

    1. In a Pre-Plug-In you can manipulation the RetrieveMultiple message of invoice so that a query for active invoices only will retrieve all invoices. But this a a side-effect to all RetrieveMultiple messages where you want explicely to see active invoices.
    2. You can develop a custom ASP.NET application with a datagrid which displays all invoices for a given plateg. With the isv.config you can display this datagrid in a plateg form.
    3. With the "Filtered Views" of stunnware (http://www.stunnware.com/) you can display all invoices for a given plateg.

    Best regards,
    Jürgen

    Jürgen Beck

    Dipl. Kfm./Wirtschaftsinformatik
    MVP, MCSD.NET, MCITP DBA, MCDBA, MCSE
    Microsoft Certified Business Management Solutions Professional
    Microsoft Certified CRM Developer
    Microsoft Certified Trainer

    ComBeck IT Services & Business Solutions
    Microsoft Gold Certified Partner
    Microsoft Small Business Specialist

    Developing & Supporting Business Applications from small business to big enterprises covering scores of sectors

    http://www.combeck.de
    Sunday, April 19, 2009 12:20 PM
    Moderator
  • Thank you. It is very helpfull

    Monday, April 20, 2009 6:16 AM