Thursday, November 17, 2011

GL PERIOD STATUSES

/* GL PERIOD STATUSES 
Two small scripts for reviewing open periods across multipel books.  ( Month end close checking or automated alerts ) 
and period status for a given year and book.
(Tested on Vision 11.5.10.2 Jul-2007 ) */
select sob.short_name
,    ps.period_name
,    ps.show_status
,    ps.start_date||' to '||ps.end_date     
,    ps.period_year
,    ps.period_num
from GL_PERIOD_STATUSES_V ps, GL_SETS_OF_BOOKS sob
where ps.set_of_Books_id = sob.SET_OF_BOOKS_ID
and application_id = 101
--and period_year = 2006
--and substr(sob.short_name,1,2) in ('ES','LU','BE')
and ps.show_status not in ('Never Opened')
order by 1,5,6 desc

select sob.short_name
,    ps.period_name
,    ps.start_date
,    ps.end_date     
,    ps.period_year
,    ps.period_num
,    ps.show_status
from GL_PERIOD_STATUSES_V ps, GL_SETS_OF_BOOKS sob
where ps.set_of_Books_id = sob.SET_OF_BOOKS_ID
and application_id = 101
and period_year = 2006
--and substr(sob.short_name,1,2) in ('GB')
order by 1,5,6 desc

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect