BAQ Calculated Get Fiscal Year

[dr_dan (Dan Ramirez)]

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?

[Vinaykamboj]

It is a constant under Financial in BAQ

[Doug.C (Doug Crabtree)]

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

[dr_dan (Dan Ramirez)]

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

[Devin.Draeger]

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