GL Account Balance:<\/p>\n
The below SQL gets the beginning balance and ending balance of the specified GL Account for a giver ledger and period.<\/p>\n
GL Account Balance: The below SQL gets the beginning balance and ending balance of the specified GL Account for a giver ledger and period. SELECT gcc.concatenated_segments Code_combination, SUM(NVL(gb.begin_balance_dr,0)-NVL(gb.begin_balance_cr,0)) beginning_bal, SUM(NVL(gb.begin_balance_dr,0)-NVL(gb.begin_balance_cr,0) + (NVL(gb.period_net_Dr,0) – NVL(gb.period_net_cr,0))) end_bal FROM gl_balances gb, gl_code_combinations_kfv gcc WHERE gb.code_combination_id = gcc.code_combination_id AND gcc.CONCATENATED_SEGMENTS = ’01-000-1110-0000-000′ — Enter GL Account AND gb.ledger_id = […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-4862","post","type-post","status-publish","format-standard","hentry","category-scripts"],"yoast_head":"\n
\nSELECT gcc.concatenated_segments Code_combination,
\n SUM(NVL(gb.begin_balance_dr,0)-NVL(gb.begin_balance_cr,0)) beginning_bal,
\n SUM(NVL(gb.begin_balance_dr,0)-NVL(gb.begin_balance_cr,0) +
\n (NVL(gb.period_net_Dr,0) - NVL(gb.period_net_cr,0))) end_bal
\nFROM gl_balances gb,
\n gl_code_combinations_kfv gcc
\nWHERE gb.code_combination_id = gcc.code_combination_id
\nAND gcc.CONCATENATED_SEGMENTS = '01-000-1110-0000-000' -- Enter GL Account
\nAND gb.ledger_id = 1 -- Enter the Ledger
\nAND gb.Actual_flag = 'A'
\nAND gb.period_name = 'Dec-13' --Enter the Period
\nAND gb.currency_code = (SELECT currency_code FROM gl_ledgers WHERE ledger_id = gb.ledger_id)
\nGROUP BY gcc.concatenated_segments;
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"