select m.mfr_id, m.mfr_name from tblManufacturers m with (nolock) where exists ( select * from tbl_CRM_FiscalCalendar fc with (nolock) where fc.ownerId = m.mfr_id and fc.ownerType = 'MFR' ) and exists ( select * from tbl_MFR_TPF_Detail#_tpfSuffix# tpf with (nolock) where tpf.mfr_id = m.mfr_id ) order by m.mfr_Name
Manufacturer:
Fiscal Year begins on #lsdateformat( _c2.rules.fiscalYearStartMonth & "/01/2018", "Mmmm")# #_c2.rules.fiscalYearStartDay# every year.
12 Accounting periods are calendar months. Fiscal Year begins on a #DayOfWeekAsString( _c2.rules.startOfWeek)# near the beginning of #lsdateformat( _c2.rules.fiscalYearStartMonth & "/01/2018", "Mmmm")# every year.
12 Accounting periods are defined by weeks.
#_calendarHTML#

Week #_w# start #lsdateformat( _c2.TY.weeks[_w].startDate, "MM/DD/YYYY")# end #lsdateformat( _c2.TY.weeks[_w].endDate, "MM/DD/YYYY")# - Error #_c2.TY.weeks[_w].startDate# NOT #_nextStart#