This is not just a listing of eConnect errors. We want to help!

Errors for the taSopLineIvcInsert Stored Procedure

If you're a member, please click on the Ask for Help link and let us help you. If we've already helped a user, we provide a link to that article.
If you're not a member, please consider joining... we love to teach
eConnect Schema Reference for taSopLineIvcInsert
CodeDescriptionHelp!
55DOCID does not exist for the SOP Fulfillment Type document or the DOCID does not have Work Flow Enabled set to true in SOP Setup (SOP40200)  Edit
96Unable to update quantity allocated in item quantity master  Edit
97Unable to update quantity allocated in item quantity master  Edit
101At least one input variable contains a null value  Edit
102A required parameter contains an empty value  Edit
104Invalid SOPTYPE parameter was passed in  Edit
105Default location code does not exist in SOP setup  Edit
106Location code does not exist in inventory Answers exist! Join NowEdit
108Inventory item does not exist  Edit
110Item number/location code does not exist in inventory Answers exist! Join NowEdit
112Unable to update/create SOP line record  Edit
113Unable to insert Line Level comment  Edit
114Unable to insert Line Level comment  Edit
115Unable to insert the component record  Edit
179Salesperson does not exist  Edit
183Line quantity does not equal the return types (QUANTITY <> QTYINSVC+QTYINUSE+QTYDMGED+QTYRTRND+QTYONHND)  Edit
215Return Quantity Types are valid only on Returns  Edit
245Territory does not exist  Edit
299Unit Price calculation does not match out to Extended price  Edit
301QTYFULFI can not be used with a Quote, Return, or Backorder type document  Edit
302Quantity to Backorder can not be used with this SOP Type  Edit
303Kit Items can not be Drop Shipped  Edit
450Duplicate LNITMSEQ in SOP10200  Edit
451Markdown amount cannot be greater then unit price  Edit
519Unable to update quantity back ordered in item quantity master  Edit
520Unable to update quantity back ordered in item quantity master  Edit
580A Quote type document can not have back ordered amounts  Edit
588Unable to validate quantity for component record  Edit
592Kits can not have the QtyShrtOpt parameter set to 4(Back Order Balance) or 6(Cancel Balance)  Edit
593Unable to insert Line Level comment  Edit
598Customer Number does not exist  Edit
671Pre Custom Business Logic returned an error value  Edit
672Post Custom Business Logic returned an error value  Edit
722Unit Price calculation does not match out to Extended price Answers exist! Join NowEdit
738Unable to update the comment master table  Edit
771Price Level is blank, it must either be passed in or a default must exist for the transaction  Edit
788Input variable contains a negative value  Edit
870Item Tax Schedule does not exist  Edit
908Invalid Sales Account  Edit
909Invalid Markdown Account  Edit
910Invalid Returns Account  Edit
913Invalid In Use Account  Edit
914Invalid In Service Account  Edit
915Invalid Damaged Account  Edit
927Shipping Method does not exist  Edit
928Invalid Price Level Answers exist! Join NowEdit
929Invalid Inventory Account Answers exist! Join NowEdit
930Invalid Cost of Goods Account  Edit
1008Procedure taSopLot returned an error value  Edit
1151Error calling taCustomerBalance  Edit
1152Customer credit limit has been exceeded  Edit
1472Mixed Mode (AUTOALLOCATESERIAL = 3 or AUTOALLOCATELOT = 3) can not be used with updates. You can use the taSopLineDelete to delete the line and reenter the line and serial/lot numbers  Edit
1523More serials already allocated for line item then QUANTITY to allocate in sop line  Edit
1525Serial Item has no quantity left to fulfill - Quantity Shortage exists  Edit
1527Procedure taSopSerial returned an error value  Edit
1536The QTY specified for this Serial Number is > what is on hand. The QtyShrtOpt must be something other then 2 or Serial Numbers must be created  Edit
1540Serial Quantity in Serial Line table does not match Serial QUANTITY Fulfilled  Edit
1599The UOFM for the item is not specified in the Item Price List as a Default Selling UofM  Edit
1731Unable to update SOP Header values  Edit
1741LNITMSEQ already exists on a different Item Number Answers exist! Join NowEdit
1747QtyShrtOpt field can not be set to anything other then 2 when not registered for the Inventory Module  Edit
2019eConnectOutVerify proc returned an error value  Edit
2020eConnectOutVerify proc returned an error value  Edit
2079Document is currently being edited by another user Answers exist! Join NowEdit
2082The Line Quantity specified for this Lot Number is > than what is on hand. The QtyShrtOpt must be something other then 2 or Lots must be created  Edit
2083More Lots already allocated for line item then QUANTITY to allocate in Sop Line Work Answers exist! Join NowEdit
2084Input parameter LNITMSEQ must be supplied if AUTOALLOCATELOT = 1 or AUTOALLOCATELOT = 2  Edit
2208Unable to remove Dex Lock for the SOP Document  Edit
2221Duplicate document number. If adding or updating lines to an existing document, UpdateIfExists must = 1  Edit
2224Invalid ALLOCATE parameter was passed in  Edit
2225Invalid UpdateIfExists parameter was passed in  Edit
2226Invalid RecreateDist parameter was passed in  Edit
2227RecreateDist can only be set to 1 if adding or modifying an existing document - (UpdateIfExists = 1)  Edit
2229QTYFULFI amount > 0 can not be passed in when using QtyShrtOpt other then 2 and a shortage is encountered  Edit
2230QTYFULFI can not be > 0 if quantities are not being allocated via DOCID or ALLOCATE = 1  Edit
2231Multiple Qty options are not allowed for kit items  Edit
2232Allocations and fulfillment are not allowed with the document id being used  Edit
2233QTYFULFI cannot be greater than the line items remaining quantity  Edit
2235QTYCANCE cannot be > 0 with a Return type document  Edit
2262Modified quantity can not be less then the quantity already transferred  Edit
2273CMMTTEXT cannot be used if COMMENT_1 thru COMMENT_4 are being used  Edit
2274TOTALQTY cannot be < QUANTITY + QTYCANCE + QTYTBAOR + QUOTEQTYTOINV  Edit
2275TOTALQTY must equal QUANTITY for a SOPTYPE = 4  Edit
2276Unable to parse comment text from the Comment Master  Edit
2277Unable to parse CMMTTEXT field  Edit
2297Unable to parse CMMTTEXT field  Edit
2305if AUTOALLOCATELOT = 1 or 2, the taSopLotAuto node must be called with a DOCID that fulfills or QTYFULFI > 0 Answers exist! Join NowEdit
2322if AUTOALLOCATESERIAL = 1 or 2, the taSopSerial node must be called  Edit
2608Document does not exist in the Work File - SOP10100 - the Line can not be modified  Edit
2609LNITMSEQ is required when the item exists multiple times on the document  Edit
2610Unable to execute taSopLineDelete  Edit
2611Invalid NONINVEN parameter was passed in  Edit
2612Invalid DROPSHIP parameter was passed in  Edit
2613Invalid Exceptionaldemand parameter was passed in  Edit
2615Invalid AUTOALLOCATESERIAL parameter was passed in  Edit
2616Invalid RequesterTrx parameter was passed in  Edit
2699IN Parameter QUOTEQTYTOINV can only be used with quotes  Edit
3395if AUTOALLOCATELOT = 0, the taSopLotAuto node should not be called  Edit
3407UNITCOST can not be passed in unless a Return type document or non inventoried item  Edit
3408Item Tax Schedule cannot be populated when item is nontaxable or based on customer Answers exist! Join NowEdit
3409IVITMTXB parameter out of range (1,2, or 3)  Edit
3416Unable to update the comment master table  Edit
3420Tax Schedule does not exist Answers exist! Join NowEdit
3425LNITMSEQ is required when passing in Kit Components manaully (KitCompMan = 1)  Edit
3441DOCID does not exist for document type  Edit
3442Invalid Currency, a Functional currency must be set up Answers exist! Join NowEdit
3443Procedure taSopLineIvcInsert for extended pricing returned an error value  Edit
3444Unable to execute sopExtPricingGetPrice  Edit
3445Unable to execute taPricingGetRoundPrice  Edit
3459Input parameter LNITMSEQ must be supplied if AUTOALLOCATESERIAL = 1 or AUTOALLOCATESERIAL = 2  Edit
3460AUTOALLOCATELOT = 1 and the SOP10102 qty fulfilled does not match the Sop Line fulfilled  Edit
3474Invalid CKCreditLimit parameter was passed in  Edit
3567Mixed mode can not be used with Lot numbers when updating a Sop line  Edit
3771Item exists as a inventoried item, NONINVEN cannot be set to 1 Answers exist! Join NowEdit
3908Invalid AUTOALLOCATELOT parameter was passed in  Edit
4644Extended Price must be 0 when Total Quantity is 0  Edit
4646Decimal Places passed in on UNITPRCE does not match setup Answers exist! Join NowEdit
4647Decimal Places passed in on XTNDPRCE does not match setup Answers exist! Join NowEdit
4655Extended Price must be 0 when Quantity is 0  Edit
4730AUTOALLOCATELOT = 1 and the SOP10101 qty fulfilled does not match the Sop Line fulfilled Answers exist! Join NowEdit
4776Item Options are set to not allow back orders for this item  Edit
4777Quantities can not exceed total quantity plus quantity already transferred  Edit
5313Unit of Measure does not exist for the Unit of Measure Schedule being used  Edit
5447Decimal Places passed in on MRKDNAMT does not match setup  Edit
5527QTYCANCE cannot be > 0 with an Invoice type document (SOPTYPE = 3) and a negative quantity (QUANTITY < 0)  Edit
5528Quantity to Backorder can not be used with a SOP Invoice (SOPTYPE = 3) when the Quantity being passed is a negative (QUANTITY < 0)  Edit
5988This line item already has bin information Default Bins cannot be used  Edit
5996Unable to update SOP Default Bins  Edit
6232QtyShrtOpt parameter out of range (1,2,3,4,5, or 6)  Edit
6538SQL Error inserting into #SopLine temp table  Edit
6645Kits can not be distributed across multiple Return Types  Edit
7470You can not pass a negative qty for any SOPTYPE other then invoice (SOPTYPE = 3)  Edit
7471You can not pass a negative Extended Price for any SOPTYPE other then invoice (SOPTYPE = 3)  Edit
7472You can not pass a negative Tax Amount (TAXAMNT) for any SOPTYPE other then invoice (SOPTYPE = 3)  Edit
7803You can not pass both a Markdown Amount (MRKDNAMT) and a Markdown Percent (MRKDNPCT)  Edit
8168QTYFULFI amount > 0 can not be passed in when using QtyShrtOpt other then 2 and a shortage is encountered  Edit
8240Quantity Type in serial/lot was not passed in to match the Returned quantity types in the line  Edit
8241Currency/UofM combination is not included in extended price sheet for this item  Edit
8242A price can not be found for the item  Edit
8297You can not change quantities because the line item is committed to a purchase order  Edit
8298You can not change the extended quantity of a kit item  Edit
8500You can not have a Qty Shortage Option other then 2 on a Drop Ship  Edit
8503Decimal Places passed in on QUANTITY does not match setup  Edit
9177Currency/Price Level/UofM combination is not included in price list for this item Answers exist! Join NowEdit
9386No price level was found for the originating currency and DEFPRICING was set to 1 for a multi-currency transaction. eConnect does not currently support this configuration.  Edit
9551Primary Ship to address ID (PRSTADCD) does not exist in the RM00102 Table  Edit
11454Decimal Places passed in on QUANTITY does not match what is set up for the Item Number  Edit
11522BUG ID#50489 The Convert Functional price functionality currently does not exist in eConnect  Edit
11755Inactive items can only be used on returns  Edit
11756Item has been inactivated quantity cannot be changed  Edit
11763The Print_Phone_NumberGB is invalid - 0 - 4 are valid  Edit
11807This site is currently marked inactive  Edit
11808This item site is currently marked inactive  Edit
11984CUSTNMBR does not exist on current work SOP document  Edit
11987Unable to update quantity back ordered in item quantity master  Edit
11988Unable to update quantity back ordered in item quantity master  Edit
11998Recreate Taxes parameter out of range (0,1)  Edit
11999Recreate Commission parameter out of range (0,1)  Edit
12000Recreate Taxes can only be set to 1 if adding or modifying an existing document - (UpdateIfExists = 1)  Edit
12001Recreate Commision can only be set to 1 if adding or modifying an existing document - (UpdateIfExists = 1)  Edit
20989Unable to insert the component record  Edit
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