on 04-02-2016 11:27 AM
Hello Experts,
I am stuck at a requirement like:
we need to set a specific Price-list as a minimum price that any user can keep or take in invoice for any product while creating an Invoice or SO.
Let me know how this can be achieved? or is there any work around or Transaction notification or any other way?
let me know if you need more information.
regards,
Ravi.
Hello,
This Transaction notification is not helping me...
Plz help me..
This is not giving any output..
regards,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ravi,
You can setup a Price List from Inventory-->Price List.
It will take into effect for all user for all documents.
Thanks,
Harshal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
for E.g.
item 1 has below prices
Dealer price is: 10 Rs
distributer price is : 8 Rs.
Now while creating SO, if i chose a customer who is a dealer/Distributer ten i can give him only 8 Rs as the lowest price. i as a user can not reduce the price less than that.
Let ,me know if you need more information.
I hope you understood.
regards,
Ravi.
Hi,
Kindly try this
IF EXISTS (
select t1.ItemCode, t1.Price, t2.ListNum from ORDR T0
JOIN RDR1 T1 ON t0.DocEntry=t1.DocEntry
JOIN OCRD T2 ON t0.CardCode=t2.CardCode
where T0.DocEntry =@list_of_cols_val_tab_del
and t1.Price < (select price from ITM1 t3 where t3.ItemCode=t1.ItemCode and t2.ListNum=t3.PriceList)
)
BEGIN
SET @error=-1;
SET @error_message='Price is under minimum price list'
END
Thanks,
Triadi
Hi Ravi,
Lets have a work around for this,
First go to Item Master data of that product and tick mark the first property.
Second go to Special price for business partner and assign price in price list 1 for that BP and Item.
then try to run this SP.
----------Price Change in SO--------------------
IF(@object_type = '17') and (@transaction_type in ('A', 'U'))
begin
IF Exists (select T0.Docentry from ORDR T0,RDR1 T1,OITM I1,ITM1 I2, OSPP I3 where T0.Docentry= @list_of_cols_val_tab_del and
T0.Docentry=T1.Docentry and T1.ItemCode=I1.ItemCode and I1.QryGroup1='Y' and I1.ItemCode=I2.ItemCode and I3.ItemCode = T1.ItemCode
and I3.CardCode = T0.CardCode and I3.ListNum = '1'
--and T0.UserSign <> 12
and I3.Price != T1.Price )
Begin
SET @error = 2
SET @error_message = 'Price should not be changed'
End
End
----------Price Change in SO--------------------
Hope the method is clear to you.
Thanks,
Harshal
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
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.