How to verify data of pa_bc_balances & pa_bc_commitments_all from System?
Hi All,
I need to cross-check the data of pa_bc_balances & pa_bc_commitments_all tables from system (values appearing on the forms). Please share details (navigations etc.) of the respective forms of Projects to verify the same.
Let me make it more clear. I am developing a report to show the BUDGET, ACTUAL, & AVAILABLE FUNDS against certain Project/Task. Below is the query, I developed to get my goal:
======================================================================
SELECT project_id, task_id,
SUM (budget_period_to_date) Budget,
SUM (actual_period_to_date) Actuals,
SUM (encumb_period_to_date) Commitment,
SUM (actual_period_to_date) + SUM (encumb_period_to_date) USAGE,