The record already exists when posting Sales Order Picking List

Error message :

Cannot create a record in Picking routes – order relation table (WMSPickingRouteLink).
Picking route: 51R1200142, 51-SOE-12-015398.
The record already exists.

When :

Posting Sales Order Picking List

Solution :

Open table SalesParmTable, and SalesParmLine, also SalesParmUpdate. Find Sales Order number at SalesParmTable. Copy field ParmId. Search ParmId on SalesParmLine, and SalesParmUpdate. Delete record which is same ParmId at table SalesParmLine and SalesParmUpdate. Last, delete record at table SalesParmTable, which is same Sales Order number with error message.


About this entry