Is it possible to have a Gridview showing the following fields:

Vendor #
Vendor Name
Outstanding Balance from AP
Outstanding Receipts from PO

If so, what table and/or related columns can I use to accomplish this?

Please note that I do not want outstanding PO's to be included in the Outstanding Receipts amount. Outstanding PO's could be shown in a separate column but most importantly I need to see outstanding Receipts amount not including any outstanding PO's.

Thanks,
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario