stevegray
4Penny.net
Points: 53175

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

4Penny.net
Version: All
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3