Which Year is active?

[SBarnes]

Is there an easy way from Manager.GeneralLedgerConfiguration to tell which year current or next we are running in based upon the current date?

[DannyC]

You could try the SQL user defined function ufn_JIWA_GL_YearNo. Use the GetDate() for the @TranDate

It's code is

Code: Select all

ALTER FUNCTION [dbo].[ufn_JIWA_GL_YearNo] (@TranDate DATETIME)
RETURNS SMALLINT
AS
BEGIN
   --Used by:
   --
   --ufn_JIWA_GL_PeriodNo

   RETURN (
         SELECT
         TOP 1 YearNo
         FROM
         GL_Config WITH (NOLOCK)
         WHERE
         @TranDate >= YearStartingDate AND @TranDate <= dbo.ufn_JIWA_GL_YearEndingDate(YearNo)
         ORDER BY YearStartingDate ASC)
END
GO

[SBarnes]

Na I think I've sussed it the manager has a General Ledger configuration which has properties called NextFinancialYear and CurrentFinancialYear that are of type JiwaFinancials.Jiwa.JiwaApplication.GeneralLedger.FinancialYear and that class has a start and end date for the year on it so it's just a matter of comparing the current date to which one's start and end date it's between.

As near as I can tell Jiwa has already read this data at start up so there is no need to go back to the database for it.