1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to get item price on sales order based on customer-Warehouse-item combination

Discussion in 'Oracle CRM' started by harinagoju, Nov 28, 2013.

  1. harinagoju

    harinagoju Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    We have a requirement, where price on sales order line should be picked based on the customer-warehouse-item combination.

    E.g. Each shipping warehouse has specific price list. Suppose item A has a price $100 on price list applicable for all customers

    Considering below table

    On a sales order for customer TATA with shipping warehouse 1BA, when Item A is selected, then $150 should populate as price
    Similarly, on a sales order for customer ACRONI with shipping warehouse 1BA, when Item A is selected, then $120 should populate as price
    Similarly, on a sales order for customer ARCELORMITTAL with shipping warehouse 1BA, when Item A is selected, then $100 should populate as price

    Item Customer Warehouse Price
    Item A ALL 1BA 100
    Item A TATA 1BA 150
    Item A ACRONI 1BA 120

    Users do not want to have each price list for customer-warehouse combination due to maintenance issue. Also, no modifier creation is allowed.
    User not willing to use qualifier page to enter qualifier rules.

    Please suggest best possible approach for this requirement. Even custom solution is fine.

    Best Regards,
    Hari
     
  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi Hari,

    I think It will be possible through Personalization or Custom.pll.

    Regards
    Sambasiva Reddy.K