Hi Experts,
I want to use econnect procedure (taPopEnterMatchInvToShpMultiLine) in my website. But i always get error 4881 (Receipt Line Number Already Exists when i pass ShipRCPTLNNM parameter and 4874 (Input variable contains an empty value) when i pass QTYINVCD parameter value is 0.
can i submit econnect procedure (taPopEnterMatchInvToShpMultiLine) first then taPopEnterMatchInvLine and taPopEnterMatchInvHdr ? because i'm trying to submit taPopEnte
rMatchInvToShpMultiLine first.
this is my parameter i pass:
$PARAMS[] = "@I_vPOPRCTNM = '" . $HEADER['POPRCTNM'] . "'";
$PARAMS[] = "@I_vPOPMtchShpRcpt = '" . $detail['POPMtchShpRcpt'] . "'";
$PARAMS[] = "@I_vPONUMBER = '" . $HEADER['PONUMBER'] . "'";
$PARAMS[] = "@I_vQTYINVCD = '" . (int)$detail['QTYINVCD'] . "'";
$PARAMS[] = "@I_vRevalue_Inventory = '" . $detail['Revalue_Inventory'] . "'";
$PARAMS[] = "@I_vITEMNMBR = '" . $HEADER['ITEMNMBR'] . "'";
$PARAMS[] = "@I_vShipRCPTLNNM = '" . $detail['RCPTLNNM'] . "'";
$PARAMS[] = "@I_vVENDORID = '" . $HEADER['VENDORID'] . "'";
$GET_ACTINDX = $this->pst->select('ACTNUMST')->WHERE('ACTINDX', $detail['ACTINDX'])->GET('GL00105')->ROW_ARRAY();
$PARAMS[] = "@I_vVarianceAccount = '" . $GET_ACTINDX['ACTNUMST'] . "'";
$PARAMS[] = "@O_iErrorState = @_iErrorState OUTPUT";
$PARAMS[] = "@oErrString = @_ErrString OUTPUT";
$QUERY = "DECLARE @_iErrorState int
DECLARE @_ErrString varchar(255)
exec [dbo].[taPopEnterMatchInvToShpMultiLine] " . implode(',', $PARAMS) . ";
SELECT @_iErrorState as ERRSTATE, @_ErrString AS ERRSTRING;";
anyone have a solution ?