Sage 100

Crystal 11 - Trying to group on transaction date in AR History Header. This group needs to based upon the 4-4-5 fiscal calendar instead of calendar month. Thanks for any suggestions.

I recently created a rolling 12 month sales report based upon fiscal year instead of calendar (using history header). @JeffSchwenk put me in touch with an Access programmer, who created an Access table that reads the transaction date and equates it with a period number, as defined in GL_FiscalYearDetail. This allows you to group on GL period, rather than transaction date. PM me (or Jeff) if you'd like me to put you in touch.