Integration Error -4) UoM Group Can not be Changed

Integration Error -4) UoM Group Can not be Changed

Product version: 

iVend 6.6 with SAP B1 9.2

 

Problem statement :- 

While updating the price from SAPB1 Product Master Screen ,it displayed the error message 

(-4) UoM Group Can not be Changed



 

Proposed solution: 

Altered the stored procedure CXS_Ivend_SP_TransactionNotification90

 

Steps if any: 

Below  yellow Highlight Code line require to changed.
-------------------------------------User Code for VALIDATION FOR UOM GROUP ON Item Master --------------------------------------

IF @object_type = '4'AND @transaction_type IN ('U')
BEGIN
DECLARE @UgpEntry1 INT
SELECT TOP 1 @UgpEntry1= UgpEntry FROM AITM WHERE ItemCode=@list_of_cols_val_tab_del ORDER BY createdate DESC
if NOT EXISTS (Select t0.UgpEntry from OITM T0 where T0.ItemCode=@list_of_cols_val_tab_del AND T0.UgpEntry=@UgpEntry1)
BEGIN
SELECT @error = -4, @error_message ='UoM Group Can not be Changed !!'
END
END

Updated SP
-------------------------------------VALIDATION FOR UOM GROUP ON Item Master--------------------------------------

IF @object_type = '4'AND @transaction_type IN ('U')
BEGIN
DECLARE @UgpEntry1 INT
SELECT TOP 1 @UgpEntry1= UgpEntry FROM AITM WHERE ItemCode=@list_of_cols_val_tab_del ORDER BY LogInstanc DESC
if NOT EXISTS (Select t0.UgpEntry from OITM T0 where T0.ItemCode=@list_of_cols_val_tab_del AND T0.UgpEntry=@UgpEntry1)
BEGIN
SELECT @error = -4, @error_message ='UoM Group Can not be Changed !!'
END
END


Constraints / scenarios :

Such Queries should be used with the Support Team.