Notifications
Clear all
Topic starter
Currently all of our Financial reports run on Fiscal year ( April-March), I need them to run on Calender year ( January-December). Is this how GE Canned reports are set up for all? Has anyone changed them to run on calender year. I need some advise on what I need to change on the report? It seems it is looking at Fiscal year table in DB. Please advise. Thanks!
select @FiscalYearMonth = 1
select @FiscalYearMonth = isnull(otherlong,1) from medlists where tablename = 'fiscalyear'
select @RequestedMonth = month(convert(datetime,?DATE.DATE?))
if @FiscalYearMonth <= @RequestedMonth
begin
select @FiscalYearStarts = convert(varchar,@FiscalYearMonth) + '/1/' + convert(varchar,year(convert(datetime, ?DATE.DATE?)))
end
else
begin
select @FiscalYearStarts = convert(datetime,convert(varchar,@FiscalYearMonth) + '/1/' + convert(varchar,year(convert(datetime, ?DATE.DATE?))-1))
end
/*****************************************************************************/
Posted : August 19, 2015 3:40 am
Topic starter
I got my answer..I just need to change set up in Adminstration.
Posted : August 19, 2015 6:20 am
