Article ID: KB0095
ISSUE
When transferring a sales document in the Dynamics GP Sales Order Processing module, the follow error or sequence of errors occur.
ERROR #1
"An error occurred executing SQL statements to update the SOP Number, SOP Type for table [SQL DB Name].dbo.ETI28913 for document [Document Number]"
NOTE: EAI is an example SQL database name and ORD0754298 is an example document number.
ERROR #2
"GPS Error: 54"
ERROR #3
"SQL Error: 2827 [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PKETI28913'. Cannot insert duplicate key in object 'dboETI28913'. The duplicate key value is (Document Number, 2, 16640)."
NOTE: ORD0754298 is an example document number.
ERROR #4
"ODBS Error: 23000"
ERROR #5
"Please review commissions for document [Document Number] and document [Document Number]."
NOTE: BKO0171940 and ORD0754298 are example document numbers.
RESOLUTION
Upgrade your EthoTech software to one of the following EthoSeries builds or higher.
- GP 2018: EthoSeries Build 18.00.250 Release Date December 11, 2020 or higher
- GP 2016: EthoSeries Build 16.00.150 Release Date December 11, 2020 or higher
- GP 2015: EthoSeries Build 14.00.150 Release Date December 11, 2020 or higher
How Do I Determine My Current EthoTech Product Build?
Download a new EthoTech build from the EthoTech Download Center.
Comments