Hello, I was trying to add purchase line into warehouse receipt line and when Insert() triggers I get
"The record in table Warehouse Receipt Line already exists."
However, warehouse receipt line doesn't have that purchase line.
here is my code
Primary Key in Warehouse receipt line is No., Line No., where you inserting the Line No. you need something like this.
if whserecline.find('+') then
LineNo := whserecline."line no." + 10000
LineNo := 10000;
whserecline."line no." := lineno;
xxxyour other fields come below
Without primary key how can you insert a record.