I must be missing something here. This is all that is in taPOLinePost. I already have the correct IVIVINDX value that I send down to taPOLine. Upon initial insert taPOLine changes it and if I do a second insert it updates it to the correct value. I do not see how this routine is going to correct that. Please explain.
CREATE PROCEDURE [dbo].[Tapolinepost] @I_vPOTYPE SMALLINT,
@I_vPONUMBER CHAR(17),
@I_vDOCDATE DATETIME,
@I_vVENDORID CHAR(15),
@I_vLOCNCODE CHAR(10),
@I_vVNDITNUM CHAR(30),
@I_vITEMNMBR CHAR(30),
@I_vQUANTITY NUMERIC (19,
5),
@I_vQTYCANCE NUMERIC (19,
5),
@I_vFREEONBOARD SMALLINT,
@I_vREQSTDBY CHAR(20),
@I_vCOMMNTID CHAR(15),
@I_vCOMMENT_1 CHAR(50),
@I_vCOMMENT_2 CHAR(50),
@I_vCOMMENT_3 CHAR(50),
@I_vCOMMENT_4 CHAR(50),
@I_vREQDATE DATETIME,
@I_vRELEASEBYDATE DATETIME,
@I_vPRMDATE DATETIME,
@I_vPRMSHPDTE DATETIME,
@I_vNONINVEN SMALLINT,
@I_vIVIVINDX INT,
@I_vInventoryAccount VARCHAR(75),
@I_vITEMDESC CHAR(100),
@I_vUNITCOST NUMERIC (19,
5),
@I_vVNDITDSC CHAR(100),
@I_vUOFM CHAR(8),
@I_vPurchase_IV_Item_Taxable SMALLINT,
@I_vPurchase_Item_Tax_Schedu CHAR(15),
@I_vPurchase_Site_Tax_Schedu CHAR(15),
@I_vBSIVCTTL SMALLINT,
@I_vTAXAMNT NUMERIC (19,
5),
@I_vBCKTXAMT NUMERIC (19,
5),
@I_vLanded_Cost_Group_ID CHAR(15),
@I_vPLNNDSPPLID SMALLINT,
@I_vSHIPMTHD CHAR(15),
@I_vBackoutTradeDiscTax NUMERIC (19,
5),
@I_vPOLNESTA SMALLINT,
@I_vCMMTTEXT VARCHAR(500),
@I_vORD INT,
@I_vCUSTNMBR CHAR(15),
@I_vADRSCODE CHAR(15),
@I_vCMPNYNAM CHAR(64),
@I_vCONTACT 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_vPHONE1 CHAR(21),
@I_vPHONE2 CHAR(21),
@I_vPHONE3 CHAR(21),
@I_vFAX CHAR(21),
@I_vPrint_Phone_NumberGB SMALLINT,
@I_vCURNCYID CHAR(15),
@I_vProjNum CHAR(15),
@I_vCostCatID CHAR(15),
@I_vLineNumber INT,
@I_vUpdateIfExists SMALLINT,
@I_vNOTETEXT VARCHAR(8000)
,
@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
SELECT @O_iErrorState = 0
RETURN ( @O_iErrorState )
