Skip to Content
0
Former Member
Apr 30, 2008 at 03:11 AM

SP to check PO max qty

97 Views

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