Errors when transferring sales documents

EthoTech Admin -

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]"

error01.png

NOTE: EAI is an example SQL database name and ORD0754298 is an example document number.

ERROR #2

"GPS Error: 54"

error02.png

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)."

error03.png

NOTE: ORD0754298 is an example document number.

ERROR #4

"ODBS Error: 23000"

error04.png

ERROR #5

"Please review commissions for document [Document Number] and document [Document Number]."

error05.png

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