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

Errors for the taUpdateCreateItemRcd 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 taUpdateCreateItemRcd
CodeDescriptionHelp!
29Pre Custom Business Logic returned an error value  Edit
30Post Custom Business Logic returned an error value  Edit
74Unable to insert record into Item Category Setup table  Edit
89Default Purchasing U of M does not exist  Edit
92The Default Site ID parameter does not exist in the Site Setup table  Edit
100The Revalue Inventory for Cost Variance parameter is invalid: 0=Do Not Revalue; 1=Revalue  Edit
126At least one input variable contains a null value  Edit
127The Item Number is empty and is a required field  Edit
128The Warranty Days parameter is invalid: 0 to 9999 are valid values  Edit
449Could not insert functional currency record into Item Currency Master table  Edit
471Unable to insert Default Site ID into Item Quantity Master table  Edit
494The Category 3 parameter can not be used, the User Category 3 is not set up in Inventory Control Setup  Edit
499The Item Type parameter is invalid: 1=Sales Inventory; 2=Discontinued; 3=Kit; 4=Misc Charges; 5=Services; 6=Flat Fee  Edit
500The Substitute Item 1 does not exist in the Item Master table  Edit
501The Substitute Item 2 does not exist in the Item Master table  Edit
502The Cost of Goods Sold for Kit parameter is invalid: 0=From Component Item or Not a Kit Item; 1=From Kit Item  Edit
503The ABC Code parameter is invalid: 1=None; 2=A; 3=B; 4=C  Edit
504The Valuation Method parameter is invalid: 0=Any ITEMTYPE other then 1 or 2; 1=FIFO Perpetual; 2=LIFO Perpetual; 3=Avg Perpetual; 4=FIFO Periodic; 5=LIFO Periodic  Edit
505The Quantity Decimals parameter is invalid: 0 to 5 are valid values  Edit
506The Tax Option parameter is invalid: 1=Taxable; 2=Nontaxable; 3=Base on Customers  Edit
507The Quantity Decimal Places for the Unit of Measure Schedule and the Item must match  Edit
523The Pricing Method is invalid: 1 to 6 are valid values  Edit
524Unable to insert record into Item Category Setup table  Edit
525Unable to insert record into Item Category Setup table  Edit
526Unable to update record in the Item Master table  Edit
528The Tolerance Percentage parameter is invalid, the value can not exceed 9999.999%  Edit
530The Tax Schedule ID does not exist in the Tax Schedule Master table  Edit
531The Tax Schedule ID is not allowed for Tax Options of Nontaxable or Based On Customers  Edit
780Unable to insert record into the Item Master table  Edit
781Unable to insert record into Item Quantity Master table  Edit
782Could not insert records into the Item Currency Master table from Item Class Currency Setup  Edit
783Unable to insert into the Item Purchasing table  Edit
784The Item Tracking option of Serial Numbers or Lot Numbers can not be used unless the Item Type is Sales Inventory or Discontinued  Edit
1279eConnectOutVerify proc returned an error value  Edit
1280eConnectOutVerify proc returned an error value  Edit
1302The Purchase Tax Option parameter is invalid: 1=Taxable; 2=Nontaxable; 3=Base on Vendor  Edit
1303The Purchasing Tax Schedule ID is not allowed for Tax Options of Nontaxable or Based On Vendor  Edit
1304The Tax Schedule ID does not exist in the Tax Schedule Master table  Edit
1307The U of M Schedule is empty and is a required field, either passed in or from the Item Class roll down  Edit
2234The Item Class does not exist in the Item Class Master table  Edit
2321Unable to insert record into Item Category Setup table  Edit
3711The UpdateIfExists parameter is invalid: 0=Do Not Update 1=Update if exists  Edit
3712The RequesterTrx parameter is invalid: 0=Do not update shadow table; 1=update shadow table  Edit
4603Unable to update the item list price record in the Item Currency table  Edit
4620Input variable contains a negative value  Edit
4621The Quantity Decimal Places and the quantity decimal places for the Unit of Measure Schedule must match  Edit
4622The Item Description is empty and is a required field for an item  Edit
5315The Minimun Shelf Life 2 parameter can not be used unless the Track parameter is set to 2, for Lot Numbers  Edit
5368Unable to obtain the next note index Answers exist! Join NowEdit
5456Substitute Item 1 and Substitute Item 2 can not be the same Item Number  Edit
5477Unable to delete records in the Item Purchasing table  Edit
6304The Minimun Shelf Life 1 parameter can not be used unless the Track parameter is set to 2, for Lot Numbers  Edit
7034Unable to insert record into Item Category Setup table  Edit
7045The items standard cost can not change, it is on an unposted shipment or shipment/invoice in Purchase Order Processing  Edit
7461Substitute Item 2 can not have a value if Substitute Item 1 is empty  Edit
7908Item Number already exists and the UpdateIfExists flag is set to not allow updates  Edit
7909There is not a functional currency set up in Great Plains, a functional currency is required  Edit
7910The Item Class ID is empty, when using Item Class Rolldown, an Item Class is required  Edit
7911The Item Class ID is empty, when using Item Class Rolldown, an Item Class is required  Edit
7912The Currency Decimals parameter is invalid: 0 to 5 are valid values  Edit
7913The Track parameter is invalid: 1=None; 2=Serial Numbers; 3=Lot Numbers  Edit
7914The Lot Type does not exist in the Item Lot Category Setup table  Edit
7915The input number of decimals exceeds setup for currency decimal places Answers exist! Join NowEdit
7916The Item Number can not be used, it is assigned as a Customer Item Number in Customer Item Maintenance  Edit
7918The Valuation Method can not be changed on an item that is already set up  Edit
7919The U of M Schedule does not exist in the Unit of Measure Schedule Setup table  Edit
7920The Item Type can not be changed unless going from Sales Inventory to Discontinued or Discontinued to Sales Inventory  Edit
7923The Item Type of Kit must have the Quantity Decimal Places set to 0  Edit
7963The Inventory Account is Inactive  Edit
7964The Inventory Account is not a Posting Account or Posting Allocation Account  Edit
7965The Inventory Offset Account is Inactive  Edit
7966The Inventory Offset Account is not a Posting Account or Posting Allocation Account  Edit
7967The Cost of Goods Sold Account is Inactive  Edit
7968The Cost of Goods Sold Account is not a Posting Account or Posting Allocation Account  Edit
7969The Sales Account is Inactive  Edit
7970The Sales Account is not a Posting Account or Posting Allocation Account  Edit
7971The Markdowns Account is Inactive  Edit
7972The Markdowns Account is not a Posting Account or Posting Allocation Account  Edit
7973The Sales Returns Account is Inactive  Edit
7974The Sales Returns Account is not a Posting Account or Posting Allocation Account  Edit
7975The In Use Account is Inactive  Edit
7976The In Use Account is not a Posting Account or Posting Allocation Account  Edit
7977The In Service Account is Inactive  Edit
7978The In Service Account is not a Posting Account or Posting Allocation Account  Edit
7979The Damaged Account is Inactive  Edit
7980The Damaged Account is not a Posting Account or Posting Allocation Account  Edit
7981The Variance Account is Inactive  Edit
7982The Variance Account is not a Posting Account or Posting Allocation Account  Edit
7983The Drop Ship Items Account is Inactive  Edit
7984The Drop Ship Items Account is not a Posting Account or Posting Allocation Account  Edit
7985The Purchase Price Variance Account is Inactive  Edit
7986The Purchase Price Variance Account is not a Posting Account or Posting Allocation Account  Edit
7987The Unrealized Purchase Price Variance Account is Inactive  Edit
7988The Unrealized Purchase Price Variance Account is not a Posting Account or Posting Allocation Account  Edit
7989The Inventory Returns Account is Inactive  Edit
7990The Inventory Returns Account is not a Posting Account or Posting Allocation Account  Edit
7991The Assembly Variance Account is Inactive  Edit
7992The Assembly Variance Account is not a Posting Account or Posting Allocation Account  Edit
7994Unable to insert record into Item Category Setup table  Edit
7995The Price Group does not exist in the Price Group Master table  Edit
7996The Tax Commodity Code does not exist in the Vat Tax Commodity Code Setup table  Edit
7997The Country Origin does not exist in the Intrastat Maintenance table  Edit
7998Unable to delete records in the Item Price List Options table  Edit
7999Unable to delete records in the Item Price List table  Edit
8000The Tolerance Percentage parameter can only be used with the following Valuation Methods: 1=LIFO Perpetual; 2=FIFO Perpetual; 3=Average Perpetual  Edit
8001The Tolerance Percentage parameter can not be greater then 0 if the Revalue Inventory for Cost Variance parameter is set to 0  Edit
8002The Quantity Decimal Places can not be changed on an existing item  Edit
8003The Unit of Measure Schedule is empty and is a required field, if you are rolling down from an Item Class, leave the Unit of Measure Schedule null  Edit
8004The Quantity Decimal Places and the quantity decimal places for the Unit of Measure Schedule must match  Edit
8009Unable to create Customer Master Note  Edit
8010Unable to update Customer Master Note  Edit
8011Unable to remove Customer Master Note  Edit
8020The Include in Demand Planning parameter is invalid: 0=Do Not Include; 1=Include  Edit
8021The Minimum Shelf life 1 parameter is invalid: 0 to 9999 are valid values  Edit
8022The Minimum Shelf life 2 parameter is invalid: 0 to 9999 are valid values  Edit
8023The Allow Back Orders parameter is invalid: 0=Do Not Allow Back Orders; 1=Allow Back Orders  Edit
8024The Category 1 parameter can not be used, the User Category 1 is not set up in Inventory Control Setup  Edit
8025The Category 2 parameter can not be used, the User Category 2 is not set up in Inventory Control Setup  Edit
8026The Category 4 parameter can not be used, the User Category 4 is not set up in Inventory Control Setup  Edit
8027The Category 5 parameter can not be used, the User Category 5 is not set up in Inventory Control Setup  Edit
8028The Category 6 parameter can not be used, the User Category 6 is not set up in Inventory Control Setup  Edit
8029The Maintain History - Calendar Year parameter is invalid: 0=Do Not Keep History; 1=Keep History  Edit
8030The Maintain History - Fiscal Year parameter is invalid: 0=Do Not Keep History; 1=Keep History  Edit
8031The Maintain History - Transaction parameter is invalid: 0=Do Not Keep History; 1=Keep History  Edit
8032The Maintain History - Distribution parameter is invalid: 0=Do Not Keep History; 1=Keep History  Edit
8033The Inventory Account does not exist in the Chart of Accounts  Edit
8034The Inventory Offset Account does not exist in the Chart of Accounts  Edit
8035The Cost of Goods Sold Account does not exist in the Chart of Accounts  Edit
8036The Sales Account does not exist in the Chart of Accounts  Edit
8037The Markdowns Account does not exist in the Chart of Accounts  Edit
8038The Sales Returns Account does not exist in the Chart of Accounts  Edit
8039The In Use Account does not exist in the Chart of Accounts  Edit
8040The In Service Account does not exist in the Chart of Accounts  Edit
8041The Damaged Account does not exist in the Chart of Accounts  Edit
8042The Variance Account does not exist in the Chart of Accounts  Edit
8043The Drop Ship Account does not exist in the Chart of Accounts  Edit
8044The Purchase Price Variance Account does not exist in the Chart of Accounts  Edit
8045The Unrealized Purchase Price Variance Account does not exist in the Chart of Accounts  Edit
8046The Inventory Returns Account does not exist in the Chart of Accounts  Edit
8047The Assembly Variance Account does not exist in the Chart of Accounts  Edit
8048The UseItemClass parameter is invalid: 0=Do Not use Item Class for roll down; 1=Use Item Class for roll down  Edit
8049Could not insert functional currency record into Item Currency Master table  Edit
8077The Shipping Weight parameter is invalid: 0 - 9999.99 are valid values  Edit
9597The Lot Expiration Warning flag is out of range (0 = no warnings; 1 = warning enabled)  Edit
9598Days Before Lot Expiration is out of range (0 - 999)  Edit
11774The UseQtyOverageTolerance can not be 1 when ITEMTYPE is not 1 or 2  Edit
11775The UseQtyShortageTolerance can not be 1 when ITEMTYPE is not 1 or 2  Edit
11776The UseQtyOverageTolerance can not be < 0 or > 1  Edit
11777The UseQtyShortageTolerance can not be < 0 or > 1  Edit
11778The QtyOverTolerancePercent can not be < 0 or > 99999  Edit
11779The QtyShortTolerancePercent can not be < 0 or > 99999  Edit
11845Standard Cost can not be changed on existing Item with a Periodic valuation method  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