BAQ Calculated Get Fiscal Year


I know I’ve seen it before but I can’t find it. There is a way to get the Fiscal Year in a BAQ calculated field without setting up case statements. It was like Ice.GetFiscalYear(Date) or something to that effect. Can anyone help me out?

It is a constant under Financial in BAQ


There is Erp.FiscalYear(company, date) and Erp.FiscalPeriod(company, date)

1 Like

How about that? I never knew that was there… I’ve been calculating Fiscal Years and periods like a sucker!! Thanks!

This only works if you define your fiscal year and calendar.

1 Like