This content has been marked as final. Show 8 replies
On the query bellow, change the period name, the SOB id and the currency to your needs, run it, and let me know what other info you will need.
SELECT cc.segment1, cc.segment2, nvl(sum(b.period_net_dr - b.period_net_cr),0) "Period Balance"
FROM gl_balances b, gl_code_combinations cc
WHERE cc.code_combination_id = b.code_combination_id
AND b.set_of_books_id = 52
AND b.period_name = 'Abril-2011'
AND b.actual_flag = 'A'
AND b.currency_code = 'EUR'
GROUP BY cc.segment1, cc.segment2
ORDER BY cc.segment2
Thanks for your effort.
I thought , there is some way to extract query from FSG report Definition.. It's ok .. i will do the query by myself.. Thanks octavio..
Between , do you have any idea on the thread below..
AR Receipt Accounting Issue