Skip to Content

Allocate Minimum Unit price from a pricelist

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 02, 2016 at 11:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Ravi Sheth

      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

  • avatar image
    Former Member
    Apr 04, 2016 at 04:15 PM

    Hi,

    have you checked the authorizations for your Users:

    Administration -

    Best regards

    Markus


    Add comment
    10|10000 characters needed characters exceeded

  • Apr 16, 2016 at 05:03 AM

    Hello,

    This Transaction notification is not helping me...

    Plz help me..

    This is not giving any output..

    regards,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded