Skip to main content

Common use cases of Bill Run Advanced Filter

Zuora

Common use cases of Bill Run Advanced Filter

This article lists common use cases of Bill Run Advanced Filter. 

Case 1: Create bill run for customers in United States using Apple Store

This case shows you how to create bill runs for customers in the United States using the Apple Store. 

Advanced Filter Example 1.png

The Billing Batch field is a standard field of the Account object, and the Custom Channel field is a custom field of the Account object. Bath2 contains customer accounts in the United States, and Apple Store contains customer accounts who use the Apple Store. Because the AND operator is selected for the composite condition for the Account Filter, between the conditions or condition groups that form the composite condition, the AND logic exists. Therefore, the customer accounts that are in the United States (Batch = Batch 2) and use the Apple Store (Customer Channel = Apple Store) are selected. You can then bill the customers selected by this custom filter. 

Case 2: Create bill run for customers in United States subscribing to professional services 

The subscription type can be Professional Services or License. This case shows you how to create bill runs for customers in the United States subscribing to professional services. Therefore, professional service subscriptions and licensed subscriptions are billed separately.

Advanced Filter Example 2.png

The Billing Batch field is a standard field of the Account object, and the Subscription Type field is a custom field of the Subscription object. Bath2 contains customer accounts in the United States, and Professional Service contains subscriptions that provide professional service. Adding the Subscription Filter in addition to the Account Filter forms the AND logic between the composite condition defined for the Subscription Filter and the composite condition defined for the Account Filter. Therefore, the customer accounts that are in the United States (Batch = Batch 2) and subscribe to professional services (Subscription Type = Professional Service) are selected. You can then bill the customers selected by this custom filter. 

Case 3: Create bill runs for accounts with BCD matching bill run days

The example shows you how to create bill runs for customer accounts whose Bill Cycle Day matches bill run days. This feature allows you to schedule a recurring bill run to execute daily, automatically selecting accounts with a Bill Cycle Day that matches the execution day of the bill run.

Advanced Filter Example 3.png

For this case, you must use the in operator after the BillCycleDay field. The Bill Cycle Day field is a standard field of the Account object. When you click in the search box, the value Matches the bill run day is automatically displayed for your selection.