on 07-06-2016 5:36 AM
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!
Hi,
You have to create transaction notification to block if price list value is not same in PO unit price.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
104 | |
12 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.