Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
sendow 2/26/2009 11:38:00 PM

Ship Method Shipping Type of "Pickup" causes NULL field errors on Drop Ship POs

This related to GP10 SP2, eConnect 10 SP2

 I just spent 6 hours troubleshooting an unbelievably obscure eConnect error / bug, so I thought I would share.

A PO integration that has been working fine processing several thousand transactions over the last 5 months suddenly gets this error when trying to import a Drop Ship PO:

Cannot insert the value NULL into column 'CONTACT', table 'PROD.dbo.POP10110'; column does not allow nulls. INSERT fails.
The statement has been terminated.


Version: Unknown or N/A
Section: eConnect

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables