Back

Cannot insert the value null into column Print_Phone_NumberGB

Published: Dec 17, 2014
Post Author Written by David Youngquist

I am running an integration to create a Sales Order document and am getting the message Cannot insert the value null into column Print_Phone_NumberGB table TWO.dbo.SOP10200. It is not occurring for every sales document but just this particular one.


The issue is caused when the Primary Ship To Address specified on the import does not exist in the Customer’s Address list. You would need to add this address to the customer using Customer Maintenance.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.