Stock Transfer Request stuck in Integration with error Value too long in property 'Comments'
Problem Statement:
Stock Transfer Request stuck in Integration with error Value too long in property 'Comments' of 'StockTransfer'.
Resolution/Work Around:
Kindly check the length of the comment it should not be greater than 256 characters because in SAP comment cannot be greater than 256 character while creating Stock Transfer Request. One can use the below query to check the comments length: -
select len (Comments) ,* from InvStockTransferRequest where LEN (comments)>256
Recommendations /Suggestion:
Customers can put the validation on iVend MC--> Stock Transfer-->Comments field by right clicking and define the maximum length as 200 characters .
It is suggested to configure it on Test system before doing on Production system and check if users are allowed to make comments upto 200 characters only or not.
Related Articles
iVend to SAP Intgartion Error : Credit Card - CUSTOM not set neither for the warehouse nor on the Retail Tender in SBO
Environment : Ivend 6.6 Problem statement : iVend to SAP SAP B1 Integration Error : Credit Card - CUSTOM not set neither for the warehouse nor on the Retail Tender in SBO Symptoms: Sale Transactions is not integrating from ivend to SAP B1. Below ...Integration Error "System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB"
Environment: iVend 6.6 integrated with SAPB1 HANA Problem Statement: Integration was not working and its showing below message on Event Viewer Log “System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General ...Duplicate Stock Transfer Shipment
Environment: iVend 6.5 Update 6 Problem Statement: While making a Stock Transfer receipt on receiving store MC, the user noticed that Stock Transfer Shipment is duplicated. Proposed Solution: CheckPoints: Check If stock Transfer Shipment Series is ...Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer"
*****************For Internal purpose********************* Product Version: iVend 6.6 Issue: Error in Integration Monitor (SAP to iVend) in version 6.6 for event type "Customer": Integration Error: System.Data.SqlClient.SqlException (0x80131904): ...Integration: Stock Transfer Cancelation
Environment iVend 6.5 Update 6 and 6.6 with SAP B1 9.2 Problem Statement Created Stock Transfer from SAPB1 General warehouse to iVend Retail Store ( which is not initialized or inactive) and user want to cancel it so that inventory can be revert back ...