Expense Estimate Creation Rules
- iPad
- Browser
Event organizers frequently incur expenses associated with an event and log estimates for those expenses when planning for the event. Event admins can configure Expense Estimate Creation rules to automate this process whenever the organizer executes an action. This reduces the time required to plan an event and also minimizes user error when creating estimates for these expenses.
Several types of Expense Estimate Creation rules exist, each of which can be controlled by country and event type:
- Meal Estimates
- Speaker Travel Estimates
- Speaker Lodging Estimates
- AV Equipment Estimates
- Flat Fee Estimates
For example, Sarah Jones is scheduling a multi-day event featuring multiple speakers. After Sarah inputs all speaker travel information, equipment used, and meals for her attendees, she selects the custom button Calculate Estimates. Selecting this button triggers event rules configured for each of the expense types Sarah has logged. Expense estimates, each appropriately calculated and associated with the appropriate budget, are automatically created.
See Examples of Expense Estimate Creation Rules for more detailed examples of these rules.
If an event is modified Online and the rule is executed offline, the rule still runs and creates expense estimate records.
Enabling Expense Estimate Creation Rules
To enable Expense Estimation Creation rules:
- Ensure the Event Business Rules are configured.
-
Grant admins the following permissions:
Object OLS Record Types Fields FLS EM_Business_Rule_vod
CRUD
- Expense_Estimate_Meal_Rule_vod
- Expense_Estimate_Speaker_Travel_Rule_vod
- Expense_Estimate_Speaker_Lodging_Rule_vod
- Expense_Estimate_AV_Equipment_Rule_vod
- Expense_Estimate_Flat_Fee_Rule_vod
- Expense_Type_vod
- Minimum_Travel_Distance_vod
- Maximum_Travel_Distance_vod
- Distance_Unit_Type_vod
- Rate_Type_vod
- AV_Equipment_vod
- Flat_Fee_Expense_vod
- Meal_Type_vod
- Speaker_Transportation_Method_vod
- Speaker_Lodging_Type_vod
Edit
EM_Business_Rule_Configuration_vod
CRUD
n/a
- Cost_vod
Edit
EM_Event_vod
CRUD
n/a
- AV_Equipment_vod
- Flat_Fee_Expense_vod
- Meal_Type_vod
Edit
EM_Event_Speaker_vod
CRUD
n/a
- Speaker_Transportation_Method_vod
- Speaker_Travel_Distance_vod
- Speaker_Lodging_Type_vod
- Speaker_Lodging_Nights_vod
- Distance_Unit_Type_vod
Edit
EM_Expense_Estimate_vod
CRUD
n/a
- Event_Business_Rule_vod
- Event_Business_Rule_Parameter_vod
Edit
-
Grant end users the following permissions:
Object OLS Record Types Fields FLS EM_Business_Rule_vod
R
- Expense_Estimate_Meal_Rule_vod
- Expense_Estimate_Speaker_Travel_Rule_vod
- Expense_Estimate_Speaker_Lodging_Rule_vod
- Expense_Estimate_AV_Equipment_Rule_vod
- Expense_Estimate_Flat_Fee_Rule_vod
- Expense_Type_vod
- Minimum_Travel_Distance_vod
- Maximum_Travel_Distance_vod
- Distance_Unit_Type_vod
- Rate_Type_vod
- AV_Equipment_vod
- Flat_Fee_Expense_vod
- Meal_Type_vod
- Speaker_Transportation_Method_vod
- Speaker_Lodging_Type_vod
Read
EM_Business_Rule_Configuration_vod
R
n/a
- Cost_vod
Read
EM_Event_vod
RU
n/a
- AV_Equipment_vod
- Flat_Fee_Expense_vod
- Meal_Type_vod
Edit
EM_Event_Speaker_vod
RU
n/a
- Speaker_Transportation_Method_vod
- Speaker_Travel_Distance_vod
- Speaker_Lodging_Type_vod
- Speaker_Lodging_Nights_vod
- Distance_Unit_Type_vod
Edit
EM_Expense_Estimate_vod
RU
n/a
- Event_Business_Rule_vod
- Event_Business_Rule_Parameter_vod
Edit
-
Place all configured EM_Event_vod and EM_Event_Speaker_vod fields on the appropriate page layouts.
Since organizers must populate the Speaker Travel Distance field first, Veeva recommends adding the Speaker_Travel_Distance_vod field above the Speaker_Transportation_Method_vod field on EM_Event_Speaker_vod page layouts. When using multi-currency orgs, the CurrencyIsoCode field must also be placed on the appropriate page layout.
Creating Expense Estimate Creation Rules
All Event Rules are created from the Event Business Rules tab. The selected record type of the new EM_Event_Business_Rule_vod object determines which fields admins must populate:
- Navigate to the Event Business Rules tab.
-
Create a new Event Rule with the appropriate record type:
- Expense_Estimate_Meal_Rule_vod
- Expense_Estimate_Speaker_Travel_Rule_vod
- Expense_Estimate_Speaker_Lodging_Rule_vod
- Expense_Estimate_AV_Equipment_Rule_vod
- Expense_Estimate_Flat_Fee_Rule_vod
- Select Next.
-
Populate the following fields:
- Name
-
Expense_Type_vod – Use the lookup field to select the appropriate EM_Expense_Type_vod record.
Expense Estimates are not created if the selected Expense Type is not active or is a child of another EM_Expense_Type_vod record.
- Run_Rule_Event_Action_vod – Enter the appropriate button name to run the rule whenever the event organizer selects the button. Enter only one button name and do not use any of the following buttons:
- Attendee_Reconciliation_vod
- Cancel_Event_vod
- Generate_Invitations_vod
- Generate_Sign_In_vod
- Manage_Attendees_vod
- Manage_Attendees_Hub_vod
- Preview_Event_QR_Code_vod
- Record_a_Call_vod
- Reschedule_vod
- Schedule_Engage_vod
- Send_Email_vod
- Start_Webinar_vod
- Submit_to_Cvent_vod
- View_Signatures_vod
-
Populate the following additional fields based on the selected record type:
Rule Record Type
Additional Fields
Description
Expense_Estimate_Meal_Rule_vod
Meal_Type_vod
The picklist value added to an applicable event’s Meal_Type_vod multi-select picklist.
Expense_Estimate_Speaker_Travel_Rule_vod
Speaker_Transportation_Method_vod
The picklist value added to an applicable Event Speaker’s Speaker_Transportation_Method_vod picklist.
Minimum_Travel_Distance_vod
The minimum speaker travel distance required to qualify for this rule.
Maximum_Travel_Distance_vod
The maximum speaker travel distance required to qualify for this rule.
Distance_Unit_Type_vod
Select either Kilometers or Miles.
Expense_Estimate_Speaker_Lodging_Rule_vod
Rate_Type_vod
Determines how the estimated cost is calculated. Select one of the following values:
- Day
- Event
See Using Expense Estimate Creation Rules for more information.
Speaker_Lodging_Type_vod
The picklist value added to an applicable Event Speaker’s Speaker_Lodging_Type_vod picklist.
Expense_Estimate_AV_Equipment_Rule_vod
AV_Equipment_vod
The picklist value added to an applicable event’s AV_Equipment_vod multi-select picklist.
Rate_Type_vod
Determines how the estimated cost is calculated. Select one of the following values:
- Hour
- Day
- Event
See Using Expense Estimate Creation Rules for more information.
Expense_Estimate_Flat_Fee_Rule_vod
Flat_Fee_Expense_vod
The picklist value added to an applicable event’s Flat_Fee_Expense_vod multi-select picklist.
Rate_Type_vod
Determines how the estimated cost is calculated. Select one of the following values:
- Hour
- Day
- Event
See Using Expense Estimate Creation Rules for more information.
Fields in bold are rule-specific parameters used when validating the event rule. These fields cannot be edited after the record is created.
- Select Save.
Creating Event Rules Configurations
After the event rule is created, admins must associate the event rule with a new EM_Business_Rule_Configuration_vod record to determine which event type, country, and timespan the rule should apply to.
To associate event rules to EM_Business_Rule_Configuration_vod records, create a new EM_Business_Rule_Configuration_vod record from the Business Rule Configurations related list of the appropriate business rule with the following field values:
- Event_Business_Rule_vod – Automatically populates with the appropriate event rule
- Event_Type_vod – Enter the appropriate EM_Event_vod record type the event rule applies to
- Country_vod – Use the lookup to select the appropriate Country_vod record
- Rule_Start_Date_vod
- Rule_End_Date_vod
-
Cost_vod – The cost of each instance of the associated Expense Estimate rule. Used when calculating estimate costs.
For example, in an AV Equipment Estimate rule with a Rate Type of Hour, Cost_vod represents the estimated cost of one hour of equipment use.
- Currency_vod – Use the picklist to select the appropriate currency. Only necessary in multi-currency enabled orgs.
Only one business rule configuration can be active for each combination of Event_Type_vod, Event_Business_Rule_vod, and Country_vod.
Using Expense Estimate Creation Rules
- iPad
- Browser
Event organizers can use fields on the EM_Event_vod and EM_Event_Speaker_vod page layouts in conjunction with event rules to automatically generate expense estimates. These fields display to event organizers as picklists. The displayed values of these picklists depend on the event matching the Country and Event Type of active event rules of the appropriate record type:
- Meal_Type_vod – Used for Expense_Estimate_Meal_Rule_vod type event rules
- AV_Equipment_vod – Used for Expense_Estimate_AV_Equipment_Rule_vod type event rules
- Flat_Fee_Expense_vod – Used for Expense_Estimate_Flat_Fee_Rule_vod type event rules
For expenses relating to speakers, event organizers can populate the following fields on the appropriate EM_Event_Speaker_vod record:
- Speaker_Travel_Distance_vod – Used to record a speaker’s traveling distance from an event
- Speaker_Transportation_Method_vod – A picklist used in Expense_Estimate_Speaker_Travel_Rule_vod type event rules. The values of this picklist are determined by active event rules where the Speaker_Travel_Distance_vod field is within the range of the event rule
- Speaker_Lodging_Type_vod – A picklist used in Expense_Estimate_Speaker_Lodging_Rule_vod type event rules. The values of this picklist depend on the event type and country matching active event rules.
- Speaker_Lodging_Nights_vod – Automatically populates based on the number of days of the event
After populating all the appropriate fields, event rules run whenever the event organizer selects the button corresponding to the event rule’s Run_Rule_Event_Action_vod field.
Expense Estimates Created from Rules
Whenever an expense estimate creation rule runs, an EM_Expense_Estimate_vod record is created with the following values:
- Event – References the corresponding EM_Event_vod record
-
Estimate – Uses the Cost_vod field from the corresponding EM_Business_Rule_Configuration_vod record to calculate a total estimate based on each record type:
Rule Record Type
Calculation Logic
Expense_Estimate_Meal_Rule_vod
Also uses the Estimated_Attendance_vod field from the corresponding event:
Estimated_Attendance_vod * Cost_vod
If the event organizer selects multiple meal types, each meal type is independently calculated.
Expense_Estimate_Speaker_Travel_Rule_vod
Cost_vod
Expense_Estimate_Speaker_Lodging_Rule_vod
Also uses the Speaker_Lodging_Nights_vod field from the appropriate Event Speaker.
When the Rate_Type_vod of the Event Rule = Day:
Cost_vod * Speaker_Lodging_Nights_vod
When the Rate_Type_vod of the Event Rule = Event:
Cost_vod
Expense_Estimate_AV_Equipment_Rule_vod
When the Rate_Type_vod of the Event Rule = Hour:
Cost_vod * Number of Hours at the Event
When the Rate_Type_vod of the Event Rule = Day:
Cost_vod * Number of Nights at the Event
When the Rate_Type_vod of the Event Rule = Event
Cost_vod
If the event organizer selects multiple AV equipment types, each type is independently calculated.
Expense_Estimate_Flat_Fee_Rule_vod
When the Rate_Type_vod of the Event Rule = Hour:
Cost_vod * Number of Hours at the Event
When the Rate_Type_vod of the Event Rule = Day:
Cost_vod * Number of Nights at the Event
When the Rate_Type_vod of the Event Rule = Event
Cost_vod
If the event organizer selects multiple flat fee types, each type is independently calculated.
-
Expense Type – The value of the Expense_Type_vod field from the Event Rule used to create the record
If multiple expense estimates were created with the same expense type, roll ups calculate based on the first created expense estimate record. This record is linked to the expense line record.
- EM Business Rule – References the Event Rule used to create the record
- EM Business Rule Parameter – Displays the rule-specific parameter from the Event Business Rule used to create the record
-
Event Budget –References the corresponding EM_Event_Budget_vod record associated with the record’s EM_Event_vod field
If there is more than one budget associated with the event, this field defaults to the oldest associated budget based on the CreatedDate field. This field remains blank if there are no associated budgets.
If an Expense Estimate Creation rule is deleted, the corresponding picklist option no longer displays to end users, but any EM_Expense_Estimate_vod records created by the rule are not deleted.
Examples of Expense Estimate Creation Rules
Example: Speaker Travel Estimates
The Events Admin wants to create an event rule to automatically calculate an estimated cost to transport a speaker by car:
- Navigate to the Event Business Rules tab.
-
Create an EM_Business_Rule_vod record with the following properties:
Property
Entered Value
Record Type
Expense_Estimate_Speaker_Travel_Rule_vod
Rule_Name_vod
Estimate by Car
Expense_Type_vod
The corresponding EM_Expense_Type_vod record
Run_Rule_Event_Action_vod
A custom button created specifically for this rule: Estimate_Expenses__c
Speaker_Transportation_Method_vod
Car
Minimum_Travel_Distance_vod
20
Maximum_Travel_Distance_vod
120
Distance_Unit_Type_vod
Miles
- Select the New button from the event rule’s Event Business Rule Configuration related list.
-
Enter the following field values:
Field
Entered Value
Event_Business_Rule_vod
Estimate by Car
Event_Type_vod
Speaker_Program_vod
Country_vod
US
Rule_Start_Date_vod
January 1, 2020
Rule_End_Date_vod
December 31, 2025
Cost_vod
350.00
The event admin is working in a single currency org (USD), so they do not populate the Currency_vod field.
Sarah Jones organizes a Speaker Program with Dr. Ackerman as the speaker, who lives 60 miles away from the event’s location and will travel to the event via car. Sarah records this distance in the Speaker_Travel_Distance_vod field in Dr. Ackerman’s EM_Event_Speaker_vod record.
She also selects the Speaker_Transportation_Method_vod picklist on the EM_Event_Speaker_vod record. Since the event is a Speaker Program and the travel distance is within the range of the Estimate by Car event rule, the picklist renders with one possible value: Car. Sarah selects Car and saves the speaker record.
After Sarah is finished planning the event, she selects the Estimate Expenses button from the event. An EM_Expense_Estimate_vod record is automatically created with the following properties:
Field |
Value |
---|---|
EM_Event_vod |
References Sarah’s event |
Estimate_vod |
Uses the following formula to calculate the cost: Estimate_vod = Cost_vod = 350.00 |
Expense_Type_vod |
The same expense type referenced from the Estimate Travel rule |
Event_Business_Rule_vod |
References the Estimate Travel event rule |
Event_Business_Rule_Parameter_vod |
Car |
Event Budget_vod |
References the budget associated with Sarah’s event |
Example AV Estimates
For example, the Events Admin wants to create an event rule to automatically calculate the estimated cost for renting the following types of AV equipment:
- Microphones
- Projectors
- Video Cameras
- Navigate to the Event Business Rules tab.
-
Create three EM_Business_Rule_vod records with the following properties:
Property
Microphone Record
Projector Record
Video Camera Record
Record Type
Expense_Estimate_AV_Equipment_Rule_vod
Rule_Name_vod
Estimate Microphone Expense
Estimate Projector Expense
Estimate Video Camera Expense
Expense_Type_vod
The corresponding EM_Expense_Type_vod record
Run_Rule_Event_Action_vod
A custom button: Estimate_Expenses__c
AV_Equipment_vod
Microphones
Projectors
Video Cameras
Rate_Type_vod
Day
Hour
Event
- Select the New button from the event rule’s Event Business Rule Configuration related list.
-
Create three new Event Business Rule Configurations with the following field values:
Field
Microphone Record
Projector Record
Video Camera Record
Event_Business_Rule_vod
Estimate Microphone Expense
Estimate Projector Expense
Estimate Video Camera Expense
Event_Type_vod
Congress_vod
Country_vod
France
Rule_Start_Date_vod
January 1, 2020
Rule_End_Date_vod
December 31, 2025
Cost_vod
100.00
20.50
300.00
Currency_vod
Euro
Sarah Jones organizes a Congress event in France that occurs over the course of two days. She navigates to the AV_Equipment_vod multi-select picklist. Since her event is a Congress in France and is within the timespan of the event rules, three options are available:
- Microphones
- Projectors
- Video Cameras
She selects all three options and selects the Estimate Expenses button. This creates three EM_Expense_Estimate_vod records:
Field |
Record One |
Record Two |
Record Three |
---|---|---|---|
EM_Event_vod |
References Sarah’s event |
||
Estimate_vod |
Uses the following formula to calculate the cost: Estimate_vod = Cost_vod * Days of Event Estimate_vod = 100.00 * 2 = 200.00 |
Uses the following formula to calculate the cost: Estimate_vod = Cost_vod * (Event End Time - Event Start Time for the two days) Estimate_vod = 20.50 * 16 = 328.00 |
Uses the following formula to calculate the cost: Estimate_vod = Cost_vod Estimate_vod = 300.00 |
Expense_Type_vod |
The same expense type referenced from the event rule |
||
Event_Business_Rule_vod |
Estimate Microphone Expense |
Estimate Projector Expense |
Estimate Video Camera Expense |
Event_Business_Rule_Parameter_vod |
Microphones | Projectors | Video Cameras |
Event Budget_vod |
References the budget associated with Sarah’s event |
Example: Speaker Lodging Estimates
For example, the Events Admin wants to create an event rule that automatically calculates the expense for lodging an event speaker for two nights.
- Navigate to the Event Business Rules tab.
-
Create an EM_Business_Rule_vod record with the following properties:
Property
Entered Value
Record Type
Expense_Estimate_Speaker_Lodging_Rule_vod
Rule_Name_vod
Speaker Lodging Estimate
Expense_Type_vod
The corresponding EM_Expense_Type_vod record
Run_Rule_Event_Action_vod
A custom button: Estimate_Expenses__c
Rate_Type_vod
Day
Speaker_Lodging_Type_vod
Hotel
- Select the New button from the event rule’s Event Business Rule Configuration related list.
-
Enter the following field values:
Field
Entered Value
Event_Business_Rule_vod
Speaker Lodging Estimate
Event_Type_vod
Speaker_Program_vod
Country_vod
US
Rule_Start_Date_vod
January 1, 2020
Rule_End_Date_vod
December 31, 2025
Cost_vod
150.00
The event admin is working in a single currency org (USD), so they do not populate the Currency_vod field.
Sarah Jones organizes a Speaker Program with Dr. Ackerman as the speaker. The event takes place over two days, so the Speaker_Lodging_Nights_vod field on the EM_Event_Speaker_vod record associated with Dr. Ackerman automatically populates with a value of two.
Sarah selects the Speaker_Lodging_Type_vod picklist on Dr. Ackerman’s EM_Event_Speaker_vod record. Since the event is a Speaker Program in the US within the timespan of the Speaker Lodging Estimate event rule, the picklist renders with one value: Hotel. Sarah selects Hotel
After Sarah is finished planning the event, she selects the Estimate Expenses button from the event. An EM_Expense_Estimate_vod record is automatically created with the following properties:
Field |
Value |
---|---|
EM_Event_vod |
References Sarah’s event |
Estimate_vod |
Uses the following formula to calculate the cost: Estimate_vod = Cost_vod * Nights of Event Estimate_vod = 150.00 * 2 = 300.00 |
Expense_Type_vod |
The same expense type referenced from the event rule |
Event_Business_Rule_vod |
Speaker Lodging Estimate |
Event_Business_Rule_Parameter_vod |
Hotel |
Event Budget_vod |
References the budget associated with Sarah’s event |
Utilizing Event Format and Location Type in Expense Estimate Creation Rules
Admins can configure the following types of Expense Estimate Creation Rules to only apply to certain event formats or location types, improving both efficiency and compliance when planning events:
- Meal Estimates
By making business rules more specific, admins can avoid creating redundant business rules.
See Utilizing Event Format and Location Type in Event Business Rules for more information.