Skip to Content
avatar image
Former Member

SP_Transaction Notification for Receipt from Production !!!

Hi Experts,

Can anybody help me with Stored Procedure. On batch setup window when we perform report completion from production order to receipt from production and when we add batches we have 2 field called say A and B. What I request is when this 2 field data is not same then system should throw error message when adding.

For ex: On batch setup window field A = 425 and field B = 430 then system should throw error message and do not allow to add document(receipt from Production).

Request to please advise me the stored procedure for this please.

Please find attached image for better understanding.

Appreciate for quick solution.

Regards,

Harshal Makwana

Untitled.png (70.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 07, 2015 at 03:00 PM

    Hi,

    Try:

    IF @transaction_type in ('A') AND (@OBJECT_TYPE='10000044')

    BEGIN

    If exists (SELECT t0.AbsEntry  FROM OBTN T0 WHERE T0.A <> T0.B AND

    t0.AbsEntry = @list_of_cols_val_tab_del)

    Begin

    SET @error = 1

    SET @error_message = 'A & B value should be same'

    End

    End

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 08:07 AM

    Thank you Sir,

    It works and helpful.

    Regards,

    Harshal Makwana

    Add comment
    10|10000 characters needed characters exceeded