EDI created sales order errors

Do the orders open in Demand entry and does the data seem fine there?  If they do it’s possible it’s a customization you have in order entry causing the issue… you can try opening the order with order tracker or  open order entry in developer mode in base only mode to rule out a personalization or customization is causing your error.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, November 5, 2014 2:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] EDI created sales order errors

 

 

Hi everyone,

 

We’re just implementing EDI proper, and have had success with 2 Trading Partners inbounding and creating usable Sales Orders.   The 3rd TP, after much testing created the Sales Order, but it won’t open….all you get is the error below.  It creates demand and the data is available in reports, it’s just not accessible in Sales Order Entry.   Now a 4th TP is having the same issue.  And it’s every order.

 

The same data can be inbound for these 2 into Test and is successful….no issues. 

 

Any ideas? 

 

Application Error

Failed to enable constraints.  One or more rows contain values violating non-null, unique, or foreign-key constraints.

Hi everyone,

 

We’re just implementing EDI proper, and have had success with 2 Trading Partners inbounding and creating usable Sales Orders.   The 3rd TP, after much testing created the Sales Order, but it won’t open….all you get is the error below.  It creates demand and the data is available in reports, it’s just not accessible in Sales Order Entry.   Now a 4th TP is having the same issue.  And it’s every order.

 

The same data can be inbound for these 2 into Test and is successful….no issues. 

 

Any ideas? 

 

Application Error

Failed to enable constraints.  One or more rows contain values violating non-null, unique, or foreign-key constraints.