Troubleshooting: Column ‘FiscalYearName’ is constrained to be unique. Value ‘Fiscal Year 2019’ is already present

From AutoCount Resource Center
Jump to navigation Jump to search

Question : When I try to create a new next fiscal year, error message prompted ‘Column ‘FiscalYearName’ is constrained to be unique. Value ‘Fiscal Year 2019’ is already present’.

Version : 1.8 / 1.9 / 2.0

Fiscalyearname constrained1.png


Possible Reason :

The name of fiscal year you wish to create exists, you’re not allowed to use the same Fiscal Year Name.


Solution :

Please check into Fiscal Year list to find that fiscal year name: ‘Fiscal Year 2019’.

Fiscalyearname constrained2.png

Click on Edit Fiscal Year and rename the Fiscal Year Name to Fiscal Year 2016. Then you will be able to create Fiscal Year 2019.


By : Soh Wee 190125, Lay Swan 190621, P190624


Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations