Follow

ID157 - Mark EquipmentRecords Inactive Overview

This task process will mark your eAuto Equipment Records inactive based on activity recorded against each record. Note: This alert is NOT for anyone who has been on eAuto less than 18-months.

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

Click to Subscribe 

Overview

Overview

Reviews transaction history recorded against Equipment Records to determine if device considered inactive per thresholds you set on your variables.

We install first in Test Mode so you can review before any changes made to eAuto and it's up to you when you're ready to switch it run live.

Run Schedule: Monthly on 1st

Type of Output: Email with excel spreadsheet attached

*  *  *

Sample

Sample

ID157SampleA.PNG

Attached excel document:

ID157Sample.PNG

 

 

*  *  *

Variables

Variables

ID157Variables.PNG

Variable W: Enter number of Years since Install / Create Date

Variable X: Enter Quantity of Months since services (considers only CM and PM call activity)

Variable Y: Enter Quantity of Months since Supplies shipped

Variable Z: Enter Quantity of Months since last meter reading

Variable 1: Enter Branch Numbers to report on (separated by comma) or leave blank for ALL

 

 

*  *  *

Alert Functionality

Alert Functionality

-Alert will consider accessories for marking inactive. Alert output shows ID# of Equipment Record if accessory linked. Otherwise, no ID# referenced. 

Sample below shows Model/Accessory CB4520U is linked to Host Equip# 12345; whereas, Model ADF-102 is not linked to any equipment. Neither have transaction activity recorded against them, so both accessories (linked and not linked) would be marked inActve.

ID157AccySample.PNG

-This task process uses the following criteria to determine if Equipment Record can be marked inactive. Qualifying Equipment Records are those that do not meet ALL of the following criteria:

1) Either Install Date on Equipment Record OR Create Date of Equipment Record is more than VariableW years ago. IF there is no Install Date, then alert will look to the Create Date of the Equipment Record (you can use Service Equipments eView to see Create/Entered Date-see Best Practices link below on creating this eView). 

Please note this is by calendar year, NOT not since X months. For example, if your VariableW is set to 2-years, then alert excludes any equipment with date of this or last calendar year, but if 2 or more calendar years ago then equipment is considered eligible for deactivation,

AND

2) Equipment not on an Active Contract, 

AND

3) Equipment not on an Active Lease, 

AND

4) No Service in last VariableX months (only considers CM and PM Category Call Types), 

AND

5) No Supplies shipped in last VariableY months, 

AND

6) No Meter Readings received in last VariableZ months, 

AND

7) Equipment Not In-Stock/Inventory

 

*  *  *

 

Best Practices & Tips

Best Practices & Tips

-Our Install Team will run this in test mode first. Once you are comfortable with the results, just email us at hlep@ceojuice.com to switch the alert to run live and mark inactive in eAuto.

-eView Service Equipments to see Create/Entered Date of Equipment Record. You will need to add the column named Entered Date to eView:

1. Open eView Service Equipments

ID157a.PNG

2. Select New once eView is open

 

ID157b.PNG

3. Click on Entered Date in Unselected Columns and use arrow to move to Selected Columns (be sure to name your eView and select OK):

ID157c.PNG

4. Then your custom eView will open and once you use Quick Search, you can see the Entered date - this is the date the Equipment Record was created.

ID157d.PNG

 

 

*  *  *

Related Alerts

Related Alerts

ID156 - Mark Customer Records Inactive

ID178 - Mark Model Records Inactive

ID337 - Mark Item Records Inactive

ID479 - Mark Contact Records Inactive

 

 

*  *  * 

Versions 20190201 required Model Record of Equipment Record to be set as Host to be considered for de-activation:

NOTE: The alert logic only considers equipment where the associated Model Equipment Record indicates the Model is a HOST and is not an ACCESSORY.

 

 

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