Victoria Yudin has a new query available for fiscal years and periods in Dynamics GP
SQL queries for fiscal years and periods in Dynamics GP
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.