IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW THE AUTHOR WILL BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE ANY SCRIPTS (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE SCRIPTS TO OPERATE WITH ANY OTHER PROGRAMS), EVEN IF THE AUTHOR HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SHOULD ANY SCRIPT PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF SUCH SCRIPTS IS WITH YOU. THEY ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. I am not responsible for the content at any third-party web sites and do not guarantee the accuracy of such third-party information.ĪLL SCRIPTS ON THIS SITE ARE DISTRIBUTED IN THE HOPE THAT THEY WILL BE USEFUL, BUT WITHOUT ANY WARRANTY. Information at these sites may change without notice. These third-party resources are provided to help you find other services and/or technical support resources. The links in this blog may lead to third-party Web sites. The author shall not be liable for any direct, indirect, incidental or consequential damages arising out of the use of, orinability to use, information or opinions expressed in this site and confers no rights.ĪLL SCRIPTS ON THIS SITE ARE DISTRIBUTED IN THE HOPE THAT THEY WILL BE USEFUL, BUT WITHOUT ANY WARRANTY. This blog and its content is provided "AS IS" with no warranty of any kind, either expressed or implied, made in relation to the accuracy, reliability or content of the information herein. Cannot insert the value NULL into column 'BASEUOFM.SQL: Assigning Microsoft Dynamics GP Users to SSRS.Integration Manager for Microsoft Dynamics GP 2010.Cannot insert the value NULL into column 'CONTACT'.Default Printer not 'sticking' when running Micros.New Article on MSDynamicsWorld: When It’s Time to."Object Reference Not Set" error when running Inte.The following query should help in identifying the offending record(s): In summary, if you have a purchasing receipt with a blank vendor ID or a vendor ID that does not exist in the Vendor Master table (PM00200), it will cause the Items list to fail with the error above. Upon further review, the issue is due to bad data in the Vendor ID (VENDORID) column in the Purchasing Receipt History table (POP30300). The name of the global temp table - in this case, tempdb.dbo.#2093338- varies in almost all cases, but the end result of the error is the same. The issue has been identified running Microsoft Dynamics GP 2010 RTM, SP1 or SP2.
Moving on from my previous article on a similar subject - see Cannot insert the value NULL into column 'BASEUOFM' error when clicking on Items List in Navigation Pane, I recently came across this error, Cannot insert the value NULL into column 'CONTACT' when clicking on the All Purchasing Transactions list under the Purchasing Navigation Pane option, after performing an upgrade from Microsoft Dynamics GP 9.0 to Microsoft Dynamics GP 2010 R2.Īll Purchasing Transactions list error - Purchasing Navigation List