Restriction in Receipt from Production quantity

[dlar0005]

Hello Guys,

How I can develop a transaction notification in SAP b1 HANA whenever the qty in Receipt from Production is not equal to Production Order?

[dlar0005]

looking forward for some help. thanks

[dlar0005]

So I was able to make it and working perfectly but the error that supposed to prompt to user is just highlight with text saying (1)OK. Can someone modify it to where the message will prompt to user?

here is my code.

IF ((:transaction_type = 'A' ) AND :object_type = '59' and error = 0) THEN

	SELECT COUNT (p."Type") From OIGN b inner join IGN1 bs On b."DocEntry"=bs."DocEntry" and bs."LineNum"=0
	inner join OWOR p On p."DocEntry"=bs."BaseEntry"
	where b."DocEntry" = list_of_cols_val_tab_del
	and p."Type"='S'
	and bs."BaseType"='202'
	and p."PlannedQty" <> bs."Quantity";
	
	            IF COUNT1 > 0 THEN
                error := -29043;
                error_message := 'You can not Complete more than planned!';
            END IF;
    
    END IF; 

[narayanis]

Hi,

Try This Out Please

IF ((:transaction_type = 'A' ) AND :object_type = '59' and error = 0) THEN

Declare Count1 int;

SELECT IfNull(COUNT (p."Type"),0) Into Count1 From OIGN b inner join IGN1 bs On b."DocEntry"=bs."DocEntry" and bs."LineNum"=0

inner join OWOR p On p."DocEntry"=bs."BaseEntry"

where b."DocEntry" = list_of_cols_val_tab_del

and p."Type"='S'

and bs."BaseType"='202'

and p."PlannedQty" <> bs."Quantity";

IF IfNull(COUNT1,0) > 0 THEN

error := -29043;

error_message := 'You can not Complete more than planned!';

END IF;

END IF;

Regards

[SonTran]

Hi,

You can refer this Transaction Notification for the same.

Hope this helps,

Son Tran

[dlar0005]

Thanks..

Also it seems you made forum to help us SAP user. I probably join you there..

[SonTran]

Glad to hear that.

If my answer is helpful, you can mark it as correct/helpful.