Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Sage Intelligence using Fiscal Year 4-4-5

Posted By TMMeach 17 days ago

In Sage Intelligence if I run the report Fiscal Year Detail, the start date is not accurate if you are using a 4-4-5 Fiscal Year.

The formula used to calculate the start of the month is not accurate and is off by days, resulting in incorrect period reporting.

DateAdd(month,-1,GL_FiscalYearDetail.PeriodEndingDate+1)

Has anyone else come across this or any suggestions.

Top Replies

TMMeach 11 days ago in reply to TomTarget +1

The 4–4–5 calendar is a method of managing accounting periods, and is a common calendar structure for some industries such as retail and manufacturing. It divides a year into four quarters of…

0 TomTarget 11 days ago

4-4-5 fiscal year?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 TMMeach 11 days ago in reply to TomTarget

The 4–4–5 calendar is a method of managing accounting periods, and is a common calendar structure for some industries such as retail and manufacturing. It divides a year into four quarters of 13 weeks, each grouped into two 4-week "months" and one 5-week "month".
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 TomTarget 11 days ago in reply to TMMeach

Ahh. I've heard of the 52/53 week year for restaurants before but not this. I learned something today.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Doc102208 9 days ago

What does the Fiscal Year Maintenance look like?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Sage Intelligence using Fiscal Year 4-4-5

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING