Today I had an eConnect integration return this ugly error...
Sql procedure error codes returned:
Error Number = 4794 Stored Procedure taPopEnterMatchInvHdr Error Description = Vendor Document numbers for Invoices must be unique
Node Identifier Parameters: taPopEnterMatchInvHdr
POPRCTNM = VCH00104170
Related Error Code Parameters for Node : taPopEnterMatchInvHdr
VENDORID = GILCON01
VNDDOCNM = 12-421
So I wrote the stored procedure below to check for a duplicate Vendor/Vendor Doc combination before I send the document to eConnect.
If the VendorID/Vendor Doc combination exists a row(s) will be returned, otherwise no rows