News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Hi, i need help whit t...

Microsoft Dynamics GP (Archived)

Hi, i need help whit this error

(0) Share

Report

Report

Posted on by Community Member

2476.2017_2D00_02_2D00_10_5F00_1249.png

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

L Vail 65,271 on at

Like (0)

Report

RE: Hi, i need help whit this error

Hi alberto,

I think we need to find out when it is trying to insert the duplicate record. For Dynamics GP, I would turn on the DEXSQL.log and create a SQL trace and then run the process again.

Leslie
Community Member on at

Like (0)

Report

RE: Hi, i need help whit this error

Hi Angel, thanks for the response.. indeed i'm an IT guy.. after this message, i restored the back up and i saw this tables and it is empty, can you suggest any thing else. thanks again.
Suggested answer

Angel Nuñez on at

Like (0)

Report

RE: Hi, i need help whit this error

It seems like you already have a record in table GL50500 for USERID = sa. This is temporary table only populated during the closing process. Restore your backup (if you did one before closing the year) and have your IT guys remove this record from table GL50500 and re-run the year closing.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans