Skip to main content

I would like to setup a minimum Total Price for one product with a condition.

 Condition is :

If Net Total price of that product is < $300 then Net total Price should get updated with $300 price. If it it more than $300 then do nothing.

 

eg. If List price of X product is $50 and quantity is 2. Then Net total price would be 100. which is less than 300. so Net total field should get updated with $300.

If its more than 300, lets say 450. Then it should be 450.

 

I tried to create Price rule for this scenario but it didn't work. In this price rule I was trying to update the 'Net Total' field 

see below screenshot :Set up a minimumAny suggestion here please?

@Yogesh Bhange

2 answers
  1. Jul 5, 2023, 3:27 AM

    @Dhaval Shah Net Total is a formula field, so you CANNOT update it.

    Net Total Formula = SBQQ__NetPrice__c * SBQQ__EffectiveQuantity__c

     

    Instead, update the SBQQ__NetPrice__c in the AFTER CALCULATE price rule.

     

    Price Action Pseudo Formula- (assuming the product in the context has Pricing Method = List)

    IF((SBQQ__NetPrice__c * SBQQ__EffectiveQuantity__c) < 300,

    300/SBQQ__EffectiveQuantity__c,

    SBQQ__NetPrice__c)

     

    Note: Test amendments and renewals thoroughly.

0/9000