cancel
Showing results for 
Search instead for 
Did you mean: 

Unit price restriction

former_member320372
Participant
0 Kudos

Hi,

      I have updated some unit price and default vendor list for certain items. When i plan to purchase those item, It should not allow to change the unit price & vendor. The end-users only can place a purchase order against that default vendor & with the price list price.... How to do this???

Cheers!

Accepted Solutions (0)

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

You have to create transaction notification to block if price list value is not same in PO unit price.

Thanks

former_member320372
Participant
0 Kudos

Hi,

     How to do that?.Can you guide me to create the transaction notification?

Cheers!

gaurav_bali
Active Participant
0 Kudos

Hi

Follow the below link for information Transaction Notification.

former_member320372
Participant
0 Kudos

Hi Gaurav,

                 Thanks for the basic information. Can you give the SP for my requirement?

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please try this,

IF @object_type IN ('22') AND @transaction_type IN ('A','U')

      BEGIN

            IF EXISTS (SELECT T0.[DocNum] FROM OPOR T0  INNER JOIN POR1 T1 ON T0.[DocEntry] = T1.[DocEntry]

  INNER JOIN

  OCRD T2 ON T0.[CardCode] = T2.[CardCode] INNER JOIN OPLN T3 ON T2.[ListNum] = T3.[ListNum]

  INNER JOIN ITM1 T4 ON T2.[ListNum] = T4.[PriceList]

where T1.price <> T4.[Price] and

                             

                            T0.docentry  = @list_of_cols_val_tab_del

                        )

            BEGIN

                  SELECT @error = -1

                  SELECT @error_message = 'Not allowed enter/update more than pricelist'

            END

      END

Thanks

former_member320372
Participant
0 Kudos

Hi,

     Thank you sir...I want to change any field in this?

kothandaraman_nagarajan
Active Contributor
0 Kudos

No need. Test above procedure  in test environment first!