Dynamics Community Forum Thread Details

econnect popline insert

Hi all

Am trying to use this stored procedure and even after directly feeding the parameters with variables the exucution doesn't insert any record neither does it give an error. Does this stored procedure works? Anybody with a working stored procedure works please?

Exec taPoLine

   @I_vPOTYPE = default,
   @I_vPONUMBER = @PONUMBER,
   @I_vDOCDATE = default,
   @I_vVENDORID='Test',
   @I_vLOCNCODE=default,
   @I_vVNDITNUM=@ITEMNMBR,
   @I_vITEMNMBR=@ITEMNMBR,
   @I_vQUANTITY=@QTYORDER,
   @I_vQTYCANCE=default,
   @I_vFREEONBOARD=default,
   @I_vREQSTDBY=default,
   @I_vCOMMNTID=default,
   @I_vCOMMENT_1=default,
   @I_vCOMMENT_2=default,
   @I_vCOMMENT_3=default,
   @I_vCOMMENT_4=default,
   @I_vREQDATE=default,
   @I_vRELEASEBYDATE=default,
   @I_vPRMDATE=default,
   @I_vPRMSHPDTE=default,
   @I_vNONINVEN=default,
   @I_vIVIVINDX=default,
   @I_vInventoryAccount=default,
   @I_vITEMDESC=default,
   @I_vUNITCOST=@UNITCOST,
   @I_vVNDITDSC=default,
   @I_vUOFM=default,
   @I_vPurchase_IV_Item_Taxable=default,
   @I_vPurchase_Item_Tax_Schedu=default,
   @I_vPurchase_Site_Tax_Schedu=default,
   @I_vBSIVCTTL=default,
   @I_vTAXAMNT=default,
   @I_vBCKTXAMT=default,
   @I_vLanded_Cost_Group_ID=default,
   @I_vPLNNDSPPLID=default,
   @I_vSHIPMTHD=default,
   @I_vBackoutTradeDiscTax=default,
   @I_vPOLNESTA=default,
   @I_vCMMTTEXT=default,
   @I_vORD=default,
   @I_vCUSTNMBR=default,
   @I_vADRSCODE=default,
   @I_vCMPNYNAM=default,
   @I_vCONTACT=default,
   @I_vADDRESS1=default,
   @I_vADDRESS2=default,
   @I_vADDRESS3=default,
   @I_vCITY=default,
   @I_vSTATE=default,
   @I_vZIPCODE=default,
   @I_vCCode=default,
   @I_vCOUNTRY=default,
   @I_vPHONE1=default,
   @I_vPHONE2=default,
   @I_vPHONE3=default,
   @I_vFAX=default,
   @I_vPrint_Phone_NumberGB=default,
   @I_vCURNCYID=default,
   @I_vProjNum=default,
   @I_vCostCatID=default,
   @I_vLineNumber=default,
   @I_vUpdateIfExists=default,
   @I_vNOTETEXT=default,
   @I_vRequesterTrx=default,
   @I_vUSRDEFND1=default,
   @I_vUSRDEFND2=default,
   @I_vUSRDEFND3=default,
   @I_vUSRDEFND4=default,
   @I_vUSRDEFND5=default,
   @O_iErrorState=@Ecode,
   @oErrString=@oEString