How to Block Price Change in PO Goods Receipt

[RajuParmar]

Dear All,

I am using SAP version 9.1 PL05.

I need to block Price change in PO Goods Receipt.

That is the Price in Purchase Order should be the same in PO Goods Receipt.

I can inactivate Unit Price in form setting but the user can go and change the form settings.

Can this be setup in SP_Transaction Notification.

Kind Regards

Raju Parmar

[Former Member · Accepted solution]

Hi Rajindra,

Yes, It can be Blocked through Transaction Notification.

Please check below Transaction Notification.

If @object_type='20' and @transaction_type='A'

BEGIN

If Exists (Select T0.DocEntry from [dbo].[OPDN] T0

Inner Join PDN1 T1 On T0.DocEntry=T1.DocEntry

Inner Join POR1 T2 ON T2.DocEntry = T1.BaseEntry and T1.BaseLine = T2.LineNum

Inner Join OPOR T3 ON T3.DocEntry = T2.DocEntry

Where T0.DocEntry = @list_of_cols_val_tab_del and T1.Price <> T2.Price)

BEGIN

Select @error = -1,

@error_message = 'You can not Add GRPO as GRPO Price must be same as PO Price'

End

End

Hope this helps

--

--

Regards::::

Atul Chakraborty

[former_member184146]

Try below TN

IF @transaction_type IN ('A','U') AND @object_type = '20' and @error = 0

BEGIN

IF EXISTS (SELECT a.DocEntry FROM

OPDN a inner join pdn1 b on a.docentry=b.docentry

WHERE a.DocEntry = @list_of_cols_val_tab_del and round(b.Price,4)<>(select round(price,4) from por1 where DocEntry=b.BaseEntry and ItemCode=b.ItemCode)

  )

BEGIN

SELECT @Error = 14, @error_message = 'GRPO Price should be equal to PO Price'

END

END

--Manish

[former_member184146]

yes it can be blocked by using SPTN.