Control the qty in Receipts From Production

[Former Member]

Hi,

My scenario:

I need to control the qty field in Receipts From Production screen.

Qty should not exceeds the planned qty.

Make sure Qty(Receipts) + Completed Qty(Production Order) = Planned qty.(Production Order)

Please provide me a solution.

Thanks in Advance

SAGAR

[Former Member]

Hi,

please explain with this statements:

Make sure Qty(Receipts) + Completed Qty(Production Order) = Planned qty.(Production Order)

I think completed qty in prod. order = receipts qty.

btw, you can create SAP SP Notifications to block the transactions.

regards

[Former Member]

Hi, thanks for reply.

Yes i tried using SBO SP transcation.

-

---

IF @transaction_type IN (N'A', N'U') AND (@Object_type = N'59')

BEGIN

declare @line1 int

set @line1 =

(SELECT (OWOR.PlannedQty - OWOR.CmpltQty - IGN1.Quantity)

FROM OWOR, ign1 WHERE OWOR.DocNum = ign1.BaseRef and ign1.docentry = @list_of_cols_val_tab_del)

IF @line1 < 0

BEGIN

SET @error = 10

SET @error_message = N'Quantity is invalid !'

end

END

---

This will works for single production order. If i selects multiple Production Order, this query is not working.

Please provide me a solution.

SAGAR

[former_member186095]

Hi,

What about query FMS ? try to use a new UDF that using a FMS.

Rgds,

[Former Member]

Hi Jimmy,

Sorry i can't understand ur question?

I tried using SBO_SP_TransactionNotification.

SAGAR