How to Set Combined Pricing Rules in ERPNext?

[evolkavi]

In the Pricing Rule Doctype, the applied_on field has options: Item Group, Brand, Item Code and Transactions. These options appear to be mutually exclusive.

For example, I want to set a pricing rule that applies to:

Item Group ABC
Brand XYZ
This would mean the rule applies only to items that belong to Item Group ABC and are of Brand XYZ.

Currently, I am unable to set this combination because the applied_on field restricts me to select only one option at a time.

Is there a way to achieve this combination?
If not, what would be the best approach to handle such a scenario?

Looking forward to your suggestions!

[mihir-kandoi]

@nabinhait @rohitwaghchaure please advise if this feature should be worked upon

[singhranbir]

Write a custom condition in the Dynamic Condition field, such as:
item_group == 'ABC' and brand == 'XYZ'

you can apply the rule for an Item or Item Group and then Apply the Dynamic Condition.

It is Working Fine for me.

[evolkavi]

The field item_group you mentioned seems to be from the quotation_item child table, correct? If so, this dynamic condition will not work because it evaluates the condition against the parent document, not the child table.

When using fields from a child table like item_group in quotation_item, the system doesn't have the context to evaluate those fields directly unless the condition explicitly references the child table and its structure.

However, when you use a field from the parent document (e.g., quotation), the condition works because it directly evaluates the parent field values. This limitation exists because the condition logic doesn't iterate over child table rows to match specific values.