| Funds [message #462822] |
Mon, 28 June 2010 01:05 |
klra
Messages: 3
Registered: June 2010
|
Junior Member |
|
|
Hi All,
General Ledger
Navigation Path:-
Inquiry --> Funds
I need a query for budget,encumbrance,actual,funds available for period to date and year to date amount type.
With the below query I am not getting the correct value for encumbrance but actual and budget looks fine for "period
to date" amount type.
SELECT Sum(Decode(actual_flag, 'B', period_net_dr - period_net_cr, 0)) Budget
, Sum(Decode(actual_flag, 'E', period_net_dr - period_net_cr, 0)) Encumbrance
, Sum(Decode(actual_flag, 'A', period_net_dr - period_net_cr, 0)) Actual
FROM gl_balances
WHERE code_combination_id = 2258
AND PERIOD_NAME = 'JAN-10'
Kindly help..
[Updated on: Mon, 28 June 2010 04:38] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
