Script to fix “Invalid column name” message in SOPicks table

If the message from the host is:

An error occurred while submitting transaction ID 82ea4208-1701-432a-87cb-02501cd90286.

The eConnect Transaction was submitted successfully, but transaction VER000045 encountered a problem while adding a record to the Panatracker_SOPick table for future reference.

1. Invalid column name ‘TrxReference’. (ErrorCode: 207, ErrorState: 1).
2. Invalid column name ‘VerifiedDate’. (ErrorCode: 207, ErrorState: 1).

Run this SQL script in your GP Company database(s):

ALTER TABLE Panatracker_SOPicks
ADD TrxReference char(25) null,
VerifiedDate datetime null