Unable to open new fiscal year

(0) Share

Report

Posted on by Community Member

Hello I want to open another fiscal year on GP but its giving me the following errors.

[Microsoft][SQL Server Native Client 10.0][SQL Server] Violation of PRIMARY KEY constraint "PKSY40100'. Cannot insert duplicate key in object 'dbo.SY40100'. The duplicate key value is (0,2014, 0,2 Budget Transaction Entry)

Please how can I resolve this issue I need urgent help.

Thank you and God bless

*This post is locked for comments

I have the same question (0)

All responses (20)

Answers (1)

Richard Whaley 25,195 on at

Like (0)

Report

What exactly were you doing when this occurred. It sounds like you were loading a budget. Opening a fiscal year involves going to the Fiscal Periods window, changing the date to 2014, making sure the dates are correct for each period. and saving this record.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I wasn't doing anything.

Just the fiscal year window that was opened.

Thank you

Was this reply helpful? Yes No
Ruth Ali 730 on at

Like (0)

Report

I add my voice to this request. I also tried creating a new fiscal period and got the same error. Am using GP 2013 and would appreciate if anyone has a fix.

Thanks

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

So the next fiscal year exists and you are sitting on Tools->Setup->Company->Fiscal Years, Do you then click the Calculate button or just try to exit the window?

Was this reply helpful? Yes No
Bob Callanan 789 on at

Like (0)

Report

Same issue for me. I don't see any thing unusual in SY40100 or SY40101 and we've never used Budget transaction entry (tables GL32000 and GL12000 are empty). Also running GP2013

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I clicked on calculate. and it gave the error.

Please help

Was this reply helpful? Yes No
Bob Callanan 789 on at

Like (0)

Report

Correct - the fiscal year is getting created properly in SY40100 but no records in SY40101. The fiscal year window is open and the error occurs when you press Calculate. Also, you can not exit the window as it continue to prompt you to recalculate. I tried change the start date and the number of periods to get around it but always come back to the same error. I've run Checklinks against Fiscal Periods with no errors reported.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (1)

Report

Try running Check Links and Reconcile on the Period Setup tables. Sounds like possible data corruption in SY40100.

I opened a new Fiscal Year in my 2013 install and didn't have an issue.

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

I agree with Frank. Do you have the ability to run SQL Profiler to catch what is happening behind the scenes?

Was this reply helpful? Yes No
Ruth Ali 730 on at

Like (0)

Report

I have run check links with no errors but problem still persists.

Was this reply helpful? Yes No