You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to Develop Custom Report for "Year to Date" Budget Balance Report

Received Response
1
Views
2
Comments

Summary: Need to Develop Custom Report for "Year to Date" Budget Balance Report

can i get query for budget control

Till now Query i have used

select budget_name.NAME

,GLCC.Segment1 Fund

, GLCC.Segment2 Purpose

, GLCC.Segment3 PRC

, GLCC.Segment4 Oobject

, GLCC.Segment5 Location

, GLCC.Segment6 CostCenter

, GLCC.Segment7 Project

, GLCC.Segment8 LocalUse

, GLCC.Segment9 InterFunc

--, bal.PERIOD_NAME period_name1

--, (bal.budget_amount )

, GLB.Begin_Balance_DR - GLB.Begin_Balance_CR AS Opening_Balance1

, GLB.Period_Net_DR - GLB.Period_Net_CR AS Period_Activity1 -- CurrMo_Activity

, (GLB.Begin_Balance_DR - GLB.Begin_Balance_CR) + (GLB.Period_Net_DR - GLB.Period_Net_CR) AS Ending_Balance1 -- col L in excel

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!