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
Please ignore original post...
I can't take credit for this as Rose support found it for me - I have run through these steps and it worked ( I skipped step 1 as the script didn't look like it would have made any changes to the table. It was written for GP10.0 but worked fine for GP2013...
Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
1. Follow the steps in the following Microsoft Knowledge Base article:
849988 Cannot create a new or old fiscal period, primary key constraint SY40100
2. On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to Posting, and then click Audit Trail Codes. In the Audit Trail Codes Setup window, print the information for reference.
3. On the Microsoft Dynamics GP menu, point to Maintenance, and then click Clear Data. In the Series list, clickCompany, click Audit Trail Codes, click Insert, and then click OK.
4. On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to Posting, and then click Audit Trail Codes. Select the Next Number column for each origin and prefix. Then, reenter the next number from the information that you printed in step 2. If two origins have the same prefix, insert the larger next number.
Note In the Audit Trail Codes report that you printed, you may see more origins than you see in the Audit Trail Codes window. The additional origins that you see are not required, and you do not have to add them.
5. On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to Company, and then click Fiscal Periods. Then, set up your new fiscal year.
Interesting Babu. I learn something new every day! Thank you for the added info.
Hi Frank,
Thanks for kind clarification. In the past I had a issue related to Fiscal period and I used the PSTL to create a new period as follows. And after doing this I reconcilednd all worked fine correct me if I am wrong.
Rose will be able to figure it out. I've worked with them in the past and they are excellent.
After running reconcile on fiscal periods I received an unhandled script exception. Illegal address for field (Not found) in script aaAfterBudgetFiscalPeriodCHG. Script terminated. Client does not use AA and I tried disabling AA in the Registration window. Client is running on a hosted server (RoseASP) so I don't have access to try SQL profiler. I've asked them to assist and will update here if they learn more.
Fiscal Period Modifier is used to change fiscal year definitions for existing years and reset open and historical data in those years to conform to the updated definitions. I don't think that would help in this scenario.
Hi Ruth,
Have you tried to fix this issue by using PSTL. Please take a backup before doing this.
Thanks,
Babu
Did you run Reconcile as well Ruth? Administration>>Utilities>>Reconcile>>Period Setup.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (