Hi,
I'd like to create SP to check maximum quantity in PO and current on hand compare with maximum stock in warehouse. I have created a query, but unfortunately it's not working well.
Here's the query:
IF @transaction_type IN ('A','U') AND @object_type = '22'
BEGIN
IF EXISTS(SELECT T0.ITEMCODE FROM [DBO].[POR1] T0 INNER JOIN [DBO].[OITW] T1 ON T0.ITEMCODE = T1.ITEMCODE
INNER JOIN [DBO].[OPOR] T2 ON T0.DOCENTRY = T2.DOCENTRY
WHERE T2.DOCSTATUS = 'O' AND T0.LINESTATUS = 'O' AND T0.DOCENTRY = @list_of_cols_val_tab_del AND T0.WhsCode = T1.WhsCode AND T1.OnHand+T0.OpenQty > T1.MaxStock)
BEGIN
SELECT @Error = 1, @error_message = 'Onhand Quantity + PO Quantity exceeds Max Quantity'
END
END
Please help me.
Thanks