search cancel

How to get the list of transactions by vendor

book

Article ID: 203388

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

We are using the transactions to track to expenses in the projects.

Among those expenses we have Fixed Fees. We were planning to identify in the "vendor" field of the transaction entry the company that provide the service.But unfortunately we were not able to find a view/portlet that list the transactions by vendor.

How can we get this information ?

 

Environment

Clarity PPM 15.x

Resolution

There is not an out of the box portlet displaying the list of transactions by vendor.

The transactions would be stored on this table:

PPA_WIP.

If the transaction has a header with a vendor, then an entry for such transaction will be on the following table:

PPA_WIPAPINFO.

A query like the following will display the transaction and the vendor:

SELECT  AP.VENDOR_CODE, W.* FROM PPA_WIPAPINFO AP, PPA_WIP W WHERE AP.ID = W.PPA_WIPAPINFO_ID