BAQ Help - Adding Fields from GlJrnDtl Results in Execution Timeout Error

@jnbadger Epicor has a few database functions that you can call from inside of the BAQ. In this case if you want to get the Fiscal Period of a date you can just use the Erp.FiscalPeriod() function. To call this you just need to create a calculated field with an int data type and enter any parameters required. So Erp.FiscalPeriod(LaborDtl.Company,LaborDtl.ClockInDate).

@hkeric.wci wrote a post a while ago about building your own custom ones.

3 Likes