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
3