SQL script to assist in the identification of Projects revenue issues


Project Billing

To provide an SQL script to assist in the identification of Projects (PA) revenue issues.

This script could prove very useful for PA revenue problems.  It will sum up all the accrued and unearned revenue, thus providing a figure for the total revenue against a project.

 

select   dr.draft_revenue_Num, sum(dri.amount) amt

from     pa_draft_Revenues dr, pa_draft_revenue_items dr

where    dri.project_id = dr.project_Id

and      dri.draft_revenue_Num = dr.draft_revenue_Num

and      dr.project_Id = &project_Id

group by dr.draft_revenue_Num;

 

Thanks – do share ur feedback – shivmohan

2 thoughts on “SQL script to assist in the identification of Projects revenue issues

Want to give some comment to author ( Shivmohan Purohit )

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s