[Kyle Malone, CPA]

Hello GPUG!
Anyone know how to update eConnect to start looking for Tax Type = 5 & not throw errors when importing / updating existing vendors that are set to 1099-NEC?

Thanks,

Kyle

Error Number = 3396  Stored Procedure= taUpdateCreateVendorRcd  Error Description = The Tax Type parameter is invalid: 1=Not a 1099 Vendor; 2=Dividend; 3=Interest; 4=Misc.

——————————
Kyle Malone, CPA
?GPUG Allstar | Chapter Leader – Louisiana (New Orleans)
GP Admin – CGB Enterprises, Inc.
Lead Consultant/Blogger – https://alacarteGP.com
Solugence | Find the software that FITS your business + integrates with GP. https://solugence.com
——————————

[Windi Epperson]

Hey
I’m sure you know but eConnect hasn’t gotten an u?pdate in years.  One work around option could be to import your 1099 folks with a type that isn’t used often – like Dividend – and then use the 1099 update utility in GP to swap them to NEC flags once imported.

We can also tag to see if this is maybe in the plans for a future update?
Thanks
Windi

?

——————————
Windi Epperson
Customer Support Manager
Njevity, Inc
Norman OK
720-870-9700 x104
——————————
——————————————-

[Corey Clay]

Hi –
We have addressed this with our clients by adding a bit of code to the post procedure for taUpdateCreateVendorRcd eConnect stored proc.? This has worked for us up to this point. Hope it helps for you and others.

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[taUpdateCreateVendorRcdPost] @I_vVENDORID CHAR(15)
	,@I_vVENDNAME CHAR(64)
	,@I_vVENDSHNM CHAR(15)
	,@I_vVNDCHKNM CHAR(64)
	,@I_vHOLD TINYINT
	,@I_vVENDSTTS SMALLINT
	,@I_vVNDCLSID CHAR(10)
	,@I_vVADDCDPR CHAR(15)
	,@I_vVNDCNTCT CHAR(60)
	,@I_vADDRESS1 CHAR(60)
	,@I_vADDRESS2 CHAR(60)
	,@I_vADDRESS3 CHAR(60)
	,@I_vCITY CHAR(35)
	,@I_vSTATE CHAR(29)
	,@I_vZIPCODE CHAR(10)
	,@I_vCCode CHAR(6)
	,@I_vCOUNTRY CHAR(60)
	,@I_vPHNUMBR1 CHAR(21)
	,@I_vPHNUMBR2 CHAR(21)
	,@I_vPHNUMBR3 CHAR(21)
	,@I_vFAXNUMBR CHAR(21)
	,@I_vTAXSCHID CHAR(15)
	,@I_vSHIPMTHD CHAR(15)
	,@I_vUPSZONE CHAR(3)
	,@I_vVADCDPAD CHAR(15)
	,@I_vVADCDTRO CHAR(15)
	,@I_vVADCDSFR CHAR(15)
	,@I_vACNMVNDR CHAR(20)
	,@I_vCOMMENT1 CHAR(30)
	,@I_vCOMMENT2 CHAR(30)
	,@I_vNOTETEXT VARCHAR(8000)
	,@I_vCURNCYID CHAR(15)
	,@I_vRATETPID CHAR(15)
	,@I_vPYMTRMID CHAR(20)
	,@I_vDISGRPER SMALLINT
	,@I_vDUEGRPER SMALLINT
	,@I_vPYMNTPRI CHAR(3)
	,@I_vMINORDER NUMERIC(19, 5)
	,@I_vTRDDISCT NUMERIC(19, 2)
	,@I_vTXIDNMBR CHAR(11)
	,@I_vTXRGNNUM CHAR(25)
	,@I_vCHEKBKID CHAR(15)
	,@I_vUSERDEF1 CHAR(20)
	,@I_vUSERDEF2 CHAR(20)
	,@I_vTEN99TYPE SMALLINT
	,@I_vTEN99BOXNUMBER SMALLINT
	,@I_vFREEONBOARD SMALLINT
	,@I_vUSERLANG SMALLINT
	,@I_vMINPYTYP SMALLINT
	,@I_vMINPYDLR NUMERIC(19, 5)
	,@I_vMINPYPCT NUMERIC(19, 2)
	,@I_vMXIAFVND SMALLINT
	,@I_vMAXINDLR NUMERIC(19, 5)
	,@I_vCREDTLMT SMALLINT
	,@I_vCRLMTDLR NUMERIC(19, 5)
	,@I_vWRITEOFF SMALLINT
	,@I_vMXWOFAMT NUMERIC(19, 5)
	,@I_vRevalue_Vendor TINYINT
	,@I_vPost_Results_To SMALLINT
	,@I_vKPCALHST TINYINT
	,@I_vKPERHIST TINYINT
	,@I_vKPTRXHST TINYINT
	,@I_vKGLDSTHS TINYINT
	,@I_vPTCSHACF SMALLINT
	,@I_vPMCSHACTNUMST VARCHAR(75)
	,@I_vPMAPACTNUMST VARCHAR(75)
	,@I_vPMDAVACTNUMST VARCHAR(75)
	,@I_vPMDTKACTNUMST VARCHAR(75)
	,@I_vPMFINACTNUMST VARCHAR(75)
	,@I_vPMPRCHACTNUMST VARCHAR(75)
	,@I_vPMTDSCACTNUMST VARCHAR(75)
	,@I_vPMMSCHACTNUMST VARCHAR(75)
	,@I_vPMFRTACTNUMST VARCHAR(75)
	,@I_vPMTAXACTNUMST VARCHAR(75)
	,@I_vPMWRTACTNUMST VARCHAR(75)
	,@I_vACPURACTNUMST VARCHAR(75)
	,@I_vPURPVACTNUMST VARCHAR(75)
	,@I_vUseVendorClass TINYINT
	,@I_vCreateAddress TINYINT
	,@I_vUpdateIfExists TINYINT
	,@I_vRequesterTrx SMALLINT
	,@I_vUSRDEFND1 CHAR(50)
	,@I_vUSRDEFND2 CHAR(50)
	,@I_vUSRDEFND3 CHAR(50)
	,@I_vUSRDEFND4 VARCHAR(8000)
	,@I_vUSRDEFND5 VARCHAR(8000)
	,@O_iErrorState INT OUTPUT
	,@oErrString VARCHAR(255) OUTPUT
AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

IF @I_vTEN99TYPE = 4
	AND @I_vTEN99BOXNUMBER = 7
BEGIN
	SELECT @I_vTEN99TYPE = 5
		,@I_vTEN99BOXNUMBER = 1

	UPDATE PM00200
	SET TEN99TYPE = @I_vTEN99TYPE
		,TEN99BOXNUMBER = @I_vTEN99BOXNUMBER
	WHERE VENDORID = @I_vVENDORID

	IF (@@error <> 0)
	BEGIN
		SELECT @O_iErrorState = 993

		RETURN (@O_iErrorState)
	END
END

SELECT @O_iErrorState = 0

RETURN (@O_iErrorState)
GO?

——————————
Corey Clay
Senior Technical Consultant
NexTec Group
——————————
——————————————-

[Kyle Malone, CPA]

Thanks . Our use case was for updates. The vendor existed w/ 1099 Type = NEC and we were NOT passing the 1099 type so it was throwing errors. I was thinking about setting a pre-script to grab the existing 1099 value, having eConnect set it to ‘1’ & then having a post-script set the value back to what it was…

Thanks . Went ahead and put this in & will report back in the next few days. We have modified post nodes from Binary Stream so tried to piece your code updates into our environment. If it works, I’ll share here as well.??

——————————
Kyle Malone, CPA
?GPUG Allstar | Chapter Leader – Louisiana (New Orleans)
GP Admin – CGB Enterprises, Inc.
Lead Consultant/Blogger – https://alacarteGP.com
Solugence | Find the software that FITS your business + integrates with GP. https://solugence.com
——————————
——————————————-