Pricing rule to work in sales order based on its new field

asinghdxc · February 27, 2020, 12:32pm

In pricing rule(customize) i have added “address” as an option in “applicable_for” docfield.
i have also opened a new field “address”, whose display depends on applicable_for==address.
so now when i’m making 2 different pricing rules choosing different address(for two different customers) but same items, i am getting an error in sales order that “Multiple Price Rules exists with same criteria”.

Help me out with the code , so that it can differentiate the pricing rules based on the address. if i choose customer A in sales order than it has to match the address field in pricing rule and accordingly apply the rule.
Thanks!
Akshat

asinghdxc · February 29, 2020, 5:31am

any solution for this ?

clarkej · March 1, 2020, 5:26pm

Yes for that you will need to develop the code, here’s a good place to start

github.com

frappe/erpnext/blob/develop/erpnext/accounts/doctype/pricing_rule/utils.py#L240


      
          
          
			frappe.flags.tree_conditions[key] = condition
          	return condition
          
          

          
def get_other_conditions(conditions, values, args):
          	for field in ["company", "customer", "supplier", "campaign", "sales_partner"]:
          		if args.get(field):
          			conditions += " and ifnull(`tabPricing Rule`.{0}, '') in (%({1})s, '')".format(field, field)
          			values[field] = args.get(field)
          		else:
          			conditions += " and ifnull(`tabPricing Rule`.{0}, '') = ''".format(field)
          
          
	for parenttype in ["Customer Group", "Territory", "Supplier Group"]:
          		group_condition = _get_tree_conditions(args, parenttype, "`tabPricing Rule`")
          		if group_condition:
          			conditions += " and " + group_condition
          
          
	if args.get("transaction_date"):
          		conditions += """ and %(transaction_date)s between ifnull(`tabPricing Rule`.valid_from, '2000-01-01')
          			and ifnull(`tabPricing Rule`.valid_upto, '2500-12-31')"""