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,

Hi Susan

I'm sure it's doable, but here's a question for you. You do realize that one PO/Receipt may have multiple vendors? There can be a different vendor for each line item.

So do you want to use the primary (header) vendor, or the vendor linked to the line item?

Steve

Susan

I believe there is a field somewhere that is the vendors amount on po. If its not part of the vendors stats then you need to find the table and use GV ability to link two tables into one view.

Doug, she doesn't want the vendors amount on PO, she wants the Outstanding Receipts. That's a different figure. But the concept is the same - to find the tables and link them into one view, by vendor number.

Which tables depends on Susan's answer to my question above.

Steve

Hi Steve,

I'm not sure if this answers your question, but I would like to show the same results as the Outstanding Receipt Invoice List in Purchase Order for All Vendors, both positive and negative.

Hi Susan

That report uses the primary vendor at the PO/Receipt level. It ignores the vendor assigned to the detail line.

So what you want to do is use GridView and select the PO Header and/or Totals tables (I'm not sure which without doing more research) and create a report that mimics the Outstanding Receipt Invoice List, and summarize by Vendor. Then create a basic GridView report from Payables (the Vendor master table) that lists the vendor number, name and balance outstanding. Then bring the total from the first report onto the second one.

This is an advanced use of GridView and I can't go into all of the details here. If you get stuck, it's what we consultants do for a living.

Steve