Method Community

Method:CRM

 

Method Community » Method:Classic » Method:Classic General Q&A » Filter Sales Receipt Grid by Item

Filter Sales Receipt Grid by Item

Last post 05-11-2011 4:59 PM by Geekoid. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 05-11-2011 4:07 PM

    • Geekoid
    • Top 25 Contributor
    • Joined on 06-02-2010
    • Phoenix, AZ
    • Posts 420

    Filter Sales Receipt Grid by Item

    Reply Contact

    Hello,

    Is it possible to filter the Existing Sales Receipt grid to only show sales receipts with any line items that have the Item Name containing "xxxx"?

    I also tried to create a screen using the SalesReceiptLine table, but the Customer field is not in this table as I'm accustomed to seeing using QODBC.

    What is the best way to handle this or is it not possible?

    Thanks!

    Brett
    Go Get Geek!

  • 05-11-2011 4:16 PM In reply to

    Re: Filter Sales Receipt Grid by Item

    Answer
    Reply Contact

    You were on the right track.  Make the screen based on the SalesReceiptLine table.

    But first, add a linked field to the SalesReceiptLineTable, via the SalesReceipt dropdown, to get the Customer field.

    Paul

  • 05-11-2011 4:59 PM In reply to

    • Geekoid
    • Top 25 Contributor
    • Joined on 06-02-2010
    • Phoenix, AZ
    • Posts 420

    Re: Filter Sales Receipt Grid by Item

    Reply Contact

    That was so easy and worked beautifully. Thanks for these forums and quick responses!

    Party!!!

    Now my next problem: when I select a sales receipt on the left (grid), it shows me the heading detail on the right (Customer, Date, RefNumber). However, I have another section for the line items of that sales receipt (another grid), but it is showing me ALL items, not just the ones for the receipt. What am I missing here?

    Brett
    Go Get Geek!
Page 1 of 1 (3 items)