Method:Classic General Q&A

Re: Filter Sales Receipt Grid by Item

Geekoid — Wed, 11 May 2011 21:59:15 GMT

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

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?

Re: Filter Sales Receipt Grid by Item

Method_Paul — Wed, 11 May 2011 21:16:59 GMT

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

Filter Sales Receipt Grid by Item

Geekoid — Wed, 11 May 2011 21:07:01 GMT

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!