tag:blogger.com,1999:blog-5285970135510371565.post4184339473984802200..comments2024-03-23T07:53:50.523-04:00Comments on The Dynamics GP Blogster: Cannot insert the value NULL into column 'CONTACT' error when clicking on Items List in Navigation PaneMariano Gomezhttp://www.blogger.com/profile/13267738662239812289noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5285970135510371565.post-47454092984343371752014-01-28T13:20:12.775-05:002014-01-28T13:20:12.775-05:00Excellent! works for me, great job! thanks!Excellent! works for me, great job! thanks!locuranet2noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-31606538503423220582013-03-29T14:30:04.557-04:002013-03-29T14:30:04.557-04:00Haitao,
Thanks for the kind words.
The only sugg...Haitao,<br /><br />Thanks for the kind words.<br /><br />The only suggestion I have is to run a SQL Server Profiler trace or a DEXSQL.LOG to see which record is causing the problem.<br /><br />MG.-Mariano Gomezhttps://www.blogger.com/profile/13267738662239812289noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-61585301745989073432013-03-29T13:59:59.469-04:002013-03-29T13:59:59.469-04:00Thank you for your post, it is very helpful as usu...Thank you for your post, it is very helpful as usual. I am using Dynamics GP 2010 and having this same issue. After I ran your query, there are few records show up with BLANK vendor ID, every other columns are either just zero or NULL values. It seems like they are some corrupted records, so I removed them. But now, when I go to Purchasing->Navigation List-> All purchasing transactions, it gave me a different error message "Violation of PRIMARY KEY constraint 'PK##1133951'. Can not insert duplicate key in object 'dbo.##1133951'".<br /><br />It seems some duplicate records are still existing when it is trying to insert into the temp table. <br /><br />Any help would be appreciated!Anonymoushttps://www.blogger.com/profile/08179894077802781107noreply@blogger.comtag:blogger.com,1999:blog-5285970135510371565.post-39426361145525300462011-08-29T17:05:15.804-04:002011-08-29T17:05:15.804-04:00Thank you very much for your post. We've been ...Thank you very much for your post. We've been searching and asking in the Dynamics GP Community for months and here it is. However, we didn't get the error until we upgrade from GP2010 SP1 to GP2010 SP2 aka R2.<br /><br />Based on your post we figured that the problem is the In-Transit Inventory transaction, in the Receiving Transaction entry window, does not allow VendorID to enter.<br /><br />Hope Microsoft will remove that check in SP2 as they did in GP2010 RTM and SP1.ThongDnoreply@blogger.com