I have created a custom API that will compare the lists of employees between Syteline and our HR system and then add missing employees or set inactive employees to terminated. When I attempt to insert new employees into the SLEmployees IDO, I get the error "The KeyID entered cannot be null in NextKeys_mst. INSERT rolled back.".
The documentation online suggests that you must include itemId or include all key properties. I had originally only included EmpNum, Fname, Lname, WageAcct and Shift, however I did add the key properties (as identified using the sql tables form) and received the same result.
The issue is definitely related to next keys/rowpointers but I'm unsure what the solution is. I have inserted data into a custom table and IDO previously without needing the itemId. I have successfully completed update actions on this IDO but not insert.
