See attached recording which demonstrates the issues
PART A:
In the "Period Wizard", when you select the option "4 Weekly (13 periods)", the "ending date of the fiscal year" displayed on the screen is not correct.
PART B:
The description for Week 1 is not correct. While the description generated says "4 Week 1 of 2019", it should be 4 Week 1 of 2020" (if the 13 periods for 2020 were to start with a Dec 2019 date, for example). The remaining descriptions for the year are correct. See table AccountingFiscalPeriod column PeriodDescription.
PART C:
In table AccountingFiscalPeriod, the value for column FiscalYear is not correct for the first period in the fiscal year (if the 13 periods for 2020 were to start with a Dec 2019 date, for example). The fiscal year in the table shows 2019 for the first period of fiscal year 2020, and 2020 for the rest of the year.
PART D:
The creation of many 13 period fiscal years does not consider a leap year.
You can read about the need for a leap year here:
https://www.nakisa.com/blog/accounting-compliance/benefits-and-challenges-4-4-5-calendar
Our current workaround is to manually add 7 days to the last period date using SQL update before creating more years.
Waiting to hear back from CB if this workaround is acceptable.
PART E:
In table AccountingFiscalYear, the descriptions are not correct.
Example of the problem:
Fiscal Year Starting Monday, January 1, 2018 Ending Monday, December 31, 2018
Fiscal Year Starting Monday, December 31, 2018 Ending Monday, December 30, 2019
Fiscal Year Starting Monday, December 30, 2019 Ending Tuesday, December 29, 2020
Fiscal Year Starting Monday, December 28, 2020 Ending Monday, December 27, 2021
All of the above should be ending on a Sunday
Tables AccountFiscalYear, AccountingFiscalPeriod
See attached recording which demonstrates the issues
PART A: In the "Period Wizard", when you select the option "4 Weekly (13 periods)", the "ending date of the fiscal year" displayed on the screen is not correct.
PART B: The description for Week 1 is not correct. While the description generated says "4 Week 1 of 2019", it should be 4 Week 1 of 2020" (if the 13 periods for 2020 were to start with a Dec 2019 date, for example). The remaining descriptions for the year are correct. See table AccountingFiscalPeriod column PeriodDescription.
PART C: In table AccountingFiscalPeriod, the value for column FiscalYear is not correct for the first period in the fiscal year (if the 13 periods for 2020 were to start with a Dec 2019 date, for example). The fiscal year in the table shows 2019 for the first period of fiscal year 2020, and 2020 for the rest of the year.
PART D: The creation of many 13 period fiscal years does not consider a leap year. You can read about the need for a leap year here: https://www.nakisa.com/blog/accounting-compliance/benefits-and-challenges-4-4-5-calendar Our current workaround is to manually add 7 days to the last period date using SQL update before creating more years. Waiting to hear back from CB if this workaround is acceptable.
PART E: In table AccountingFiscalYear, the descriptions are not correct. Example of the problem: Fiscal Year Starting Monday, January 1, 2018 Ending Monday, December 31, 2018 Fiscal Year Starting Monday, December 31, 2018 Ending Monday, December 30, 2019 Fiscal Year Starting Monday, December 30, 2019 Ending Tuesday, December 29, 2020 Fiscal Year Starting Monday, December 28, 2020 Ending Monday, December 27, 2021 All of the above should be ending on a Sunday
8120126879281961474.zip