Is there any way to get the current posting period?
We have used the following query to get it...
SELECT T0.Code AS 'Period Code', T0.Name AS 'Period Name' FROM [dbo].[OFPR]
T0 where getdate() >= F_RefDate and getdate() <= T_Refdate FOR BROWSE
However, this query will not giving the correct output when the user changes the period to previous period. Is there any other way to get the default Posting period?