Very useful SQL Scripts related queries, topics and discussions
User avatar
By admin
#345 Guys,

You might find this interesting. Here you find the SQL select statement to retrieve all modules Open Periods From.
Note: CC = CompanyCode; YY = FiscalYear

Code: Select allSELECT
T2.GL10003 "GL Period",
T3.GL16028 "PL Period",
T3.GL16029 "SL Period",
T3.GL16030 "PA Period",
T3.GL16031 "PR Period",
T3.GL16036 "SC Period",
T3.GL16050 "SM Period",
T3.GL16051 "MP Period"
FROM GL10CCYY T2 INNER JOIN GL16CCYY T3 ON T2.GL10001 = T3.GL16001
WHERE GL10001 = 'CCYY'