Follow

ID217 - Custom Report for Customer/Equipment Record Sales and Service Messages Overview & Sample:

This is a custom report that you can run directly from e-automate to show you all the customer and equipment records that have active sales and/or service messages/pop-ups on them. 

Jump to a specific section by clicking a link

Overview | Samples | Variables | Alert Functionality | OnDemand Report Filters | Best Practices & Tips | Related Alerts |

 

Click to Subscribe

 

Overview

Overview

The sales and service messages are not included in any e-view, which is why we created this custom report that can be used to view all sales and service messages on equipment and customer records. The report will be installed in the custom reports folder and is titled CEOJuice Customer and Equipment Sales/Service Messages. This can be used for periodic review to make sure that messages are being deleted once they no longer apply (if marked to run indefinitely) or the date to repeat until box is checked and set for the date that the message content no longer applies to that account. 
 
This report will display only active messages and show Customer Name, Customer Number, Equipment #, Frequency of Message, and the setting of the frequency. It will also give you a brief summary of the message, showing the subject line and as many characters of the message as can be displayed in the field.

 

Run Schedule:  On-Demand

Type of Output: On-Demand Report

 

*  *  *

Sample

Sample

Customer Message:

217_customermessage.png

Equipment Message:

217_equipmentmessage.png

*  *  *

Variables

Variables

This alert has no variables.

*  *  *

Alert Functionality

Alert Functionality

1. Customer messages are stored on the Messages tab of the customer record:

217_custexample.png

*Note that the date and time after Entered: in the message is the last time the note was updated. (If the message has never been updated, the date will be the time the message was added to the record.) This is the date that is used in the Date Updated Before and Date Updated After filters in the report.

2. Equipment messages are stored on the Sales/Service tab of the equipment record:

217_equipexample.png

*Note that the date and time after Entered: in the message is the last time the note was updated. (If the message has never been updated, the date will be the time the message was added to the record.) This is the date that is used in the Date Updated Before and Date Updated After filters in the report.

*  *  *

OnDemand Report Filters

On-Demand Report Filters

1. You can filter the reports for only specific equipment or customer records, message type, and the dates that the message was last updated.

217_reportfilters.png

2. The default date settings will return nothing because you are looking for notes updated after today AND notes created before today. To see all active messages, set both date filters to <All Dates>.

217_datefilter.png

*  *  *

Best Practices & Tips

Best Practices & Tips

1. We recommend a periodic review of this report to check for messages that can be removed from the equipment or customer records.

 

*  *  *

Related Alerts

Related Alerts

None at this time.

 

*  *  * 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk