Client is using AP and PO (and other modules).
We would like to create a GV Workspace that will display all the Items that a Vendor ordered in the past many, many years.

We will list all the Vendors (Vendor # and Names) in one View, and link to a second View . The second View will read data from the PO details.
We would like to display the PO#, PO Date, the IC Item # & Desc, Qty Ordered, Qty Received and Costs.


Question: Which table in PO should we link to?

Hi Samuel,

If you were using the PurchaseOrders program, where would you find the PO Details information that you would be interested in for your Workspace? Edit POs? View PO history? View Item Purchases? or View Item Purchase History? The answer to this question will be what you are looking for as the data source in GriViiew.

Your choices are:

P/O Details
P/O Details History
P/O Item History