Tuesday, June 21, 2016

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.

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

2 comments:

kk said...

Thanks for sharing.

Anonymous said...

Thank you...

Related Posts:

Related Posts with Thumbnails