iVend 6.6 with SAP B1 9.2
While updating the price from SAPB1 Product Master Screen ,it displayed the error message
(-4) UoM Group Can not be Changed
Altered the stored procedure CXS_Ivend_SP_TransactionNotification90
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
Such Queries should be used with the Support Team.