CoShip Electronic Signature - Record Not Found

Legacy Contributor

I am trying to place an electronic signature for a shipping transaction that is called from a custom form.  I have a sub-collection of all Order-Line-Releases ready to be shipped through Order Shipping code in SQL.  My code loops through the sub-collection, generates the esignature GUID, username, launches the electronic signature form which prompts the user to enter the password like normal.  Upon successful password entry and the user clicks ok, the SLEsigAuthorizations.CreateCheckSum (Handcoded - Standard Method) is ran and I get a failure message back that states "Record Not Found".  I have never done with anything with electronic signatures in Syteline/CSI before so I am not sure what the requirements are.  Since this is a hardcoded method I cannot access the code to troubleshoot the issue.  Any tips from fellow mongoose/Syteline/CSI developers out there?

Legacy Contributor

Figured it out in case anyone runs across this hoping for direction.



Search stored procedures for mentions of the electronic signature tables below in SQL and you see plenty of examples on how to create the data to validate.



Step 1: Create a new Esig_type or use an existing type if you would like

Step 2: Run the SP GetDataForEsigTypeSp to check to see if a the esig_type you are using is enabled

Step 3: Launch the ElectronicSignatureRequired form, entering username, pw, and hit OK

Step 4: Upon success of the stdformcalledreturn event, use an SP or any other method to Insert records into the hdr table electronic_signature and detail table electonic_signature_detail, note the reference field ElectronicSignatureRowPointer

Step 5: Using the esig_type, rowpointer, and encrypted password fields, use the IDO method CreateCheckSum to validate the entry

Step 6: Upon success of the method above, go ahead and perform whatever transaction you need