DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In
sgray128 8/3/2012 5:06:31 PM

DD_PMVendorDocument_SEL

* This article, and all our great SQL (Dynamics) documentation, Is available on the SQL (Dynamics) menu

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

Version: All
Section: SQL Scripts