| Period_Name column reference in GL_Balances and GL_Je_Lines tables [message #503423] |
Fri, 15 April 2011 07:42  |
sammydude
Messages: 34
Registered: November 2007
|
Member |
|
|
Hello all,
GL_Balances and GL_Je_Lines tables have period_name column.
Are they the same?
Should the following queries return the same value for a given period and code combination?
(I've left out other where clauses. Included only the important ones relavent for this question)
select sum(l.accounted_dr),sum(l.accounted_cr)
from gl_je_lines l
where 1=1
and set_of_books_id = 1
and l.period_name like 'Jan-06'
and l.code_combination_id = 17347
and l.actual_flag = 'A'
select period_net_dr,period_net_cr from Gl_Balances j
where 1=1
and set_of_books_id = 1
and j.code_combination_id = 17347
and j.period_name like 'Jan-06'
and l.actual_flag = 'A'
So, if we sum up the values for a code combination at lines level, should it match the period_net value in GL_Balances table for the same period?
Please help.
Regards,
Sam
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
