How to exclude rejected and cancelled transactions
Hello,
We have these requirements:
1. Do not show rejected and cancelled transactions (PR, POs, and Invoices) in the PSI commitments screen.
2. The Commitment amount in thee PSI screen should equate to the total project burdened cost found in the commitments screen.
3. PRC: Update Project Summary Amounts for a Single Project should also exclude cancelled and rejected transactions.
4. Cost (PSI) - Self service screen should also exclude cancelled and rejected transactions.
I was able to do #1 by updating the following views:
- PA_COMMITMENT_TXNS_V
- PA_COMMITMENTS_V
- PA_STATUS_COMMITMENTS_V
For the rest, I am not sure how to do that as I think the sources of the 3 items above are base tables.
We have these requirements:
1. Do not show rejected and cancelled transactions (PR, POs, and Invoices) in the PSI commitments screen.
2. The Commitment amount in thee PSI screen should equate to the total project burdened cost found in the commitments screen.
3. PRC: Update Project Summary Amounts for a Single Project should also exclude cancelled and rejected transactions.
4. Cost (PSI) - Self service screen should also exclude cancelled and rejected transactions.
I was able to do #1 by updating the following views:
- PA_COMMITMENT_TXNS_V
- PA_COMMITMENTS_V
- PA_STATUS_COMMITMENTS_V
For the rest, I am not sure how to do that as I think the sources of the 3 items above are base tables.
0