web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Mohammad R. Daoud / Msg 515, Level 16, State 2,...

Msg 515, Level 16, State 2, Procedure aagCreateGLWorkSLRealTimePostForApply, Line 82 Cannot insert the value NULL into column 'GLPOSTDT', table 'AFDCO.dbo.AAG10000'; column does not allow nulls. INSERT fails.

Community Member Profile Picture Community Member

This morning I an issue reported from one of my customers, they are getting the below message when they try to apply multi-currency transactions:

image

I went through a long investigation process, after few hours it turned to be orphaned records in GL100001 with JRNENTRY = 0!

image

Deleting these record fixed the problem! Hope that this helps.

Regards,

--
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85
me@mohdaoud.com
http://www.di.jo


This was originally posted here.

Comments

*This post is locked for comments