iVend API not allowing to create Product Id with length greater than 20 characters

Problem Statement

iVend API not allowing to create Product Id with length greater than 20 characters(Method -SaveProduct & SaveProductList)

Details

While calling iVend API method SaveProduct and SaveProductList, and passing ProductId with length greater than 20 characters, API was returning below error even though with 6.6, we can now create ProductId upto 50 characters

*Error Message: “Error Id cannot be more than 20 characters”*

Proposed Solution/ Workaround

As per investigation, we found that issue was due to a rule created in CfgValidationRule  table for the Product Id.

There was a rule created by default in CfgValidationRule in API database(HO). 

Data can be found with the below query.

Steps:

Step 1. Run below query on API database(HO)

select * from CfgValidationRule where id = 'Product-Id' and RuleType=3 and 

ERPType=<ERPTypeUsed>

Step 2. As per the data fetched by the query, check MaxLength column. Update and Set it to the value you want max value for Product Id.

Step 3. Do IIS Reset and check the results. Now it should allow you to create Product Id with more than 20 characters.

Constraints/ Scenarios:

It is only applicable for iVend 6.6 as of now. It will not work for lower versions.

• Related Articles

• Error while creating a new product group with Business Central

  Environment: iVend 6.6 Patch 7989 Problem Statement: Loyalty plans were created correctly but adding the products involved in the discount does NOT allow us to create a new group of products. Scenario: Client created loyalty plans in iVend system but ...

• Need to modify the length of the ID field in product, to be more than 20

  Environment: iVend 6.5 Update 5 with SAP B1 9.2 Problem Statement: Need to modify the length of the ID field in product, to be more than 20 Symptoms: Need to modify the length of the ID field in product, to be more than 20 Resolution/WorkAround: It ...

• Integration Error "Manufacturer length cannot be more than 20 characters(Code/Name > 20 chars in

  Environment : iVend 6.6 With SAPB1 Problem Statement : The error is "API Product Add/Update Manufacturer American Tactical Imports not found". When I attempt to edit this Manufacturer in SAP, I receive an error in SAP that "Manufacturer length cannot ...

• Steps to create New Store in iVend

  Environment iVend 6.6 7989 Query Steps to create New Store in iVend HO MC Answer One can follow our e-Learning Video on Store Creation from below link/ portal: It is also suggested to create Store backup file from iVend Enterprise MC in downtime when ...

• Integration Error : API Product Add/Update UPC code length should be less that 16 character

  Environment iVend 6.6.8929 Problem Statement SAP to iVend integration error "API Product Add/Update UPC code length should be less that 16 character" Resolution/Work Around: As error is self explanatory, UPC code length cannot be more than 16 ...