cancel
Showing results for 
Search instead for 
Did you mean: 

Allocate Minimum Unit price from a pricelist

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello,

This Transaction notification is not helping me...

Plz help me..

This is not giving any output..

regards,

Ravi

Former Member
0 Kudos

Hi Ravi,

Which SP you are talking about ? Have you tried mine with following settings in Property and Special price for BP ?

Thanks,

Harshal

Former Member
0 Kudos

Hi Harshal,

Yes I have tried it also.

Let me try the same one more time. I will update you again in monday morning.

regards

Ravi Sheth,

Former Member
0 Kudos

Hi Harshal,

I have tried again, but it is not helping.

Plz give your inputs.

regards,

Ravi

Former Member
0 Kudos

Hi Ravi,

Can you just elaborate what settings have you done before executing my give SP ? Because it is working very well in my system.

Thanks,

Harshal

Former Member
0 Kudos

Hi,

have you checked the authorizations for your Users:

Administration -

Best regards

Markus

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Harshal,

I already have 3 different pricelist in the inventory. what i want is that a specific pricelist to be the minimum price that any user can use.. they can not decrease the price for any item less than that pricelist price..

let me know if you need more information.

regards,

ravi

Former Member
0 Kudos

Hi Ravi,

can you explain with example so that it would be simpler to give you solution.

Thanks,

Harshal

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Ravi,

you can put your price list at customer master data.

then you have to create transaction notification to block any sales document with price less than the price list.

Regards,

Triadi

Former Member
0 Kudos

Hi Triadi,

I have put price list at customer master data, but how what Transaction notificaiton i can use, can you plz help me with the same?

regards,

Ravi.

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Triadi,

Here, where i need to say which is the pricelist that is to be taken?

as i have mulitple pricelists in my pricelist table. then which is to be taken as the minimum one?

thanks,

ravi.

Former Member
0 Kudos

Hi Ravi,

if you have multiple price list and then customer have own price list, the minimum one should be the price list based on customer master data.

if you have multiple price list and one price list as the minimum price list, you can set it as the minimum one.

thanks,

triadi

Former Member
0 Kudos

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