Follow

ID90 Parts Warranty - Overview & Sample

ID90 is our Parts Warranty process that identifies when a part is replaced before the manufacturer's warranty.

Jump to a specific section by clicking a link

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

 

Click to Subscribe

Overview

Overview

Getting dollars back for parts that don't meet warranty is the most obvious ROI for our services, and we have many clients where we flag over $100K per month, and our average is $35K. We have determined the best practice is to notify your parts person AND the technician (optional to include the tech's manager). We encourage your company to have a policy that technicians return ALL old parts to the warehouse, an idea is to have a box with each tech's name that they return their parts to, and the parts person would review to ensure everything has been returned.

This alert assumes that if the manufacturer covers the machine as a unit, the item would be covered as long as it is within the warranty date (set on the equipment record). If the machine is no longer covered as a unit, the process looks at the parts level, where the manufacturer covers certain parts based on the yield or number of days the part was installed.

The alert considers service calls in the status of OK to Invoice, Completed, or Cleared.

Run Schedule:  Every 15 minutes.

Type of Output: Email/On Demand Report

*  *  *

Sample

Sample

ID90 sample.png

1. Call number with the suspect part.

2. The customer name on the service call.

3. The technician on the current service call.

4. The item that triggered the alert.

5. The model of the equipment on the call.

6. The equipment number of the equipment on the call.

7. The install date of the equipment on the call.

8. The calculated actual yield of the part. 

9. The expected yield of the item.

10. The specific trigger that caused the alert to report on the item. See notes here on the different trigger actions.

 

*  *  *

Variables

Variables

ID90 Variables 1.png

Variable W: Text or Email Notifications - The Default value is Email to send the alert as an email. Enter Text to send the alert as a text message.

Variable X: % Target - Only notify if the yield is less than this percentage of the yield set on the item.

Variable Y: Make/Item Custom Property: Custom property set on the item or make for warranty days. More details on the custom property are here.

ID90 variables 2.png

Variable Z: Make Custom Property for Min Cost - Custom property on the Make for the minimum cost of items to be eligible for warranty. More details on the custom property are here.

Variable 1: Include Returnable Items - Yes/No to notify on items with 'Returnable' set on the item record. More details on returnable items here.

ID90 variables 3.png

Variable 2: Service Code Categories - List the service code categories of items to trigger on. Valid options are P, S, H, or O. Separate multiple items with a comma or leave blank for all Service Code Categories. More details on service code categories can be found here.

Variable 3: Branch Filter - Specify the branch numbers to trigger on or leave blank for all. Separate multiple branch numbers with a comma. More details on the branch number are here.

 

*  *  *

Alert Functionality

Alert Functionality

ID90 identifies parts that may be covered under the Manufacturer's warranty. Calls are considered by the alert when they are in the status of OK to Invoice, Completed, or Cleared. The alert checks the actual yield for the item against the expected yield, the number of days the part has been in the machine, if the machine is under warranty, and if the part is marked as returnable. The column 'Trigger Action' on the emailed output indicates which condition triggered the alert.

Jump to: Item Yield | Core Returnable | Warranty Date | Branch Number | Service Code Categories | Make/Item Custom Property | Min Cost Custom Property | Trigger Actions

Item Yield

Item Yield

The yield on the item used by ID90 is set here:

item yield.png

When determining if a part qualifies for ID90, the process takes this yield times the percentage set in variable X to get the 'Target Yield' for the item. (Copy yield is 10,000, Variable X is .9, the Target Yield = 9,000) This number is compared to the actual yield based on the number of clicks between when the part was installed and when it was replaced.

You should review your part record items in e-automate to ensure all parts with a yield are set up correctly. You can use alert ID189 for a weekly list of parts missing a yield or ID571 that reports on items with incorrect or missing yields. For items that do not have a yield, or you do not want ID90 to trigger on, enter 2 in the Copy yield field.

Item is Returnable

Item is Returnable

The alert considers a part to be returnable when the Returnable box is checked on the item record:

item returnable.png

ID90 will always report on parts that have this option checked. If you do not want ID90 to report on returnable items, set Variable 1 to No.

Warranty Date

Warranty Date

The equipment warranty date is set on the Billing/Contact tab of the equipment record:

warranty expiration date.png

This date is used to determine if the device is still under the manufacturer's warranty. This functionality is hard-coded into our logic as it's intended to provide you with insight into the equipment-level warranty. Calls for equipment where the closed date of the service call is before the warranty expiration will always trigger ID90.

Branch Number

Branch Number

The alert considers the branch set on the Billing \ Accounting tab of the service call that triggered the alert:

branch on service call.png

Service Code Categories

Service Code Categories

There are only four service code categories in e-automate; you are not able to add or edit these:

H: Hardware

O: Other

P: Part

S: Supply

One service code category is assigned to each service code in e-automate:

service code category.png

You can use Variable 2 to specify that ID90 only checks items with a service code set to a particular service code category. 

Make/Item Custom Property

Make/Item Custom Property

The ZCJMakeWtyDays custom property is used to set the number of days that a part should last; this can be set at either the Make or Item level. The ID90 logic uses this custom property in two different calculations:

1. Days since equipment received: The difference between the closed date of the service call and the date the equipment was received into e-automate. The alert will trigger if this value is less than or equal to the value set in the custom property.

2. Days since part was last used: The difference between the closed date of the service call and the date the part was last used in the machine. The alert will trigger if this value is less than or equal to the value set in the custom property.

This custom property can be set at either the Make or Item level. If the value is set at the Item level, that value will override the value set at the Make level.

Make Custom Property:

corrected custom prop days on make.png

Item Custom Property:

corrected custom prop days on item.png

Min Cost Custom Property

Min Cost Custom Property

The ZCJMakeWtyMinCost custom property is used to set a minimum cost that needs to be reached before an item is eligible for warranty replacement based on the actual yield being less than the expected yield. If the actual yield is less than the expected yield, but the average cost of the item is below the threshold set on the Make, then the alert will not trigger.

Make Custom Property:

make min cost.png

For the make above, parts will need to have an average cost greater than $50.00 to trigger the alert based on the yield of the part.

Trigger Actions

Trigger Actions

The trigger action column on the alert will show the action that triggered the alert. The logic moves through the checks listed below, if the part qualifies at any step, it will trigger the alert.

Clicks

1. Clicks: Did the item fall below the manufacturer’s guaranteed yield?

Triggered when the expected volume for an item (Manufacturers Target Yield * Variable X) is greater than the actual yield on the item, and the average cost of the part exceeds the amount set in the ZCJMakeMinWtyCost. If the equipment make does not have the minimum cost custom property set, the average cost of the part is not used in the calculation.

The actual yield on the item is calculated from the click difference between the meter read when the part was installed and the service call meter read when the new part was installed. If there is no history of the part being used in the machine, the logic will use the install meter as the previous meter.

Note that if the service meter from the install date is not valid, the logic will report on the next valid meter reading.

Expand to show Trigger Action sample - Copy Yield: (Actual Yield) MfgTarget at: Variable X%: (Percent of MfgTarget Volume)

Part number: AB-12345

Copy yield on part: 5,000

Average Part cost: $100.00

Percentage set in Variable X: 0.95

Previous Call: SC705188 on 2/7/25, meter reading 2,370,500

Current Call: SC705203 on 4/15/25, meter reading 2,372,125

Calculations:

MfgYield * Variable X % > Actual Yield (Current meter reading - Previous meter reading)

5,000 * .95 > 2,372,125 - 2,370,500

4,750 > 1,625

Trigger notification: Copy Yield: 1,625 MfgTarget at: 95%: 4,750

Custom property in use:

ZCJMakeWtyMinCost: $50.00

In the example above, the average cost of the item is $100.00, and the minimum cost for the make is $50.00. In this scenario, the part will trigger ID90. If the custom property was set to a value greater than $100.00, then the alert would not trigger.

Days

2. Days: Was the part installed for less than the minimum number of days?

Some manufacturers won't consider a part for any warranty if it has been installed for longer than a certain period, regardless of whether it was under the click yield guarantee. The alert looks to see how long the part was installed, and compares the number of days installed to the custom property set at either the Make or Item level to see if the part qualifies based on the number of days installed. The logic looks at both the number of days since the equipment was received and how many days since the item was last used in the machine.

If this custom property is not populated, the alert logic will skip any calculation based on days.

Expand to show trigger action sample: Make Wty Days: XX days since Eq recd XX:

ZCJMakeWtyDays: 365 **Set on Make for equipment on service call.

corrected custom prop days on make.png

Equipment Received date: 01/01/2025

Service Call Completion Date: 04/15/2025

Calculation:

The difference between the Service Call Completion Date and the Equipment Received Date is less than or equal to the value in ZCJMakeWtyDays

104 >= 365 

Trigger notification: Make Wty Days: 365 days since Eq Recd: 104

Expand to show trigger action sample: Item Wty Days: XX days since Eq recd XX:

If the value is present at the item level, that value will trump the value set at the make level.

ZCJMakeWtyDays: 520 **Set on item record for part on service call.

corrected custom prop days on item.png

Equipment Received date: 01/01/2025

Service Call Completion Date: 04/15/2025

Calculation:

The difference between the Service Call Completion Date and the Equipment Received Date is less than or equal to the value in ZCJMakeWtyDays

104 >= 520

Trigger action: Item Wty Days: 520 days since Eq Recd: 104

Expand to show trigger action sample: Make Prev Installed Wty Days: XX days since last use: XX

Previous Call with part: 12/26/2024

Current Call closed date: 4/15/2025

ZCJMakeWtyDays: 365 **Set on Make for equipment on service call.

corrected custom prop days on make.png

Days since last use: 110

Calculation:

The days since last used is less than or equal to the value in ZCJMakeWtyDays set on the make.

110 >= 365

Trigger notification: Make Prev Installed Wty Days: 365 days since last use: 110

Expand to show trigger action sample: Item Prev Installed Wty Days: XX days since last use: XX

If the value is present at the item level, that value will trump the value set at the make level.

Previous Call with part: 12/26/2024

Current Call closed date: 4/15/2025

ZCJMakeWtyDays: 520 **Set on Item level for part under consideration for warranty.

corrected custom prop days on item.png

Days since last use: 110

Calculation:

The days since last used is less than or equal to the value in ZCJMakeWtyDays set on the make.

110 >= 520

Trigger notification: Item Prev Installed Wty Days: 520 days since last use: 110

Equipment Warranty

3. Equipment Warranty: Is the machine still under warranty?

If the date the service call was completed is before the warranty date set on the equipment record, the part used on the call will trigger ID90.

Expand to show trigger action sample: Equip Warranty Date Month Day Year

Equipment warranty date: 08/01/2026

warranty expiration date for example.png

Call closed date: 04/15/2025

Calculation:

Is the call closed date before the equipment warranty date?

04/15/2025 is before 08/01/2026

Trigger notification: Equip Warranty Date Aug 01 2026

Core Returnable

4. Core Returnable: Are you required to return the old part to the manufacturer for credit?

These items are identified by selecting the Returnable box on the item record. If an item has this option checked, ID90 will trigger regardless of other settings/conditions.

If you do not want ID90 to report on returnable items, set Variable 1 to No.

Expand to show trigger action sample: Core Item for Return

Is the returnable box checked on the item record?

item returnable.png

Trigger notification: Core Item for Return

*  *  *

OnDemand Report Filters

OnDemand Report Filters

You can also run ID90 via the SSRS reports console: [Service] Warranty Parts Yield Trends - ID90 (ID405)

SSRS report.png

Set the report mode to Warranty Parts (ID90):

report filter.png

Model/Item - optional, you can enter any 'contains' text

Tech name - optional, you can enter any 'contains' text

Rank - filter does not apply to ID90

Mfg Yield - set to equal or greater than Copy yield to be considered on the report

Is Returnable - yes/no if you want to see returnable items on the report

Branch - filter by branch

Target Percent Yield - the percentage of yield the item should meet before showing on the alert.

From/Thru Date - The service call dates to consider

See this post for details on running this report.

*  *  *

Best Practices & Tips

Best Practices & Tips

1. Some manufacturers (i.e. Xerox and Canon) use the same drum for each of the colors in a color machine. Unfortunately, there is no best practice for this as we haven't found a solution that doesn't cause more work than it prevents. Our suggestion is for your parts staff to consider these drums as possible returns and determine if the potential return is worth the effort. That is, if returning the item is going to result in a return of $10.00, that's most likely not worth the time to return the item. If there's a true issue or possibility of a substantial warranty return, then it is most likely something that you want to investigate further.

2. See this link for information on crediting the contract and technician.

3. Be sure that you have the custom properties set at the model level for all warranty days and minimum costing to ensure that parts are not triggering that you know are not valid warranty returns.

Custom Property Set Up

Custom Property Set Up

If you do not see the two needed custom properties in e-automate, you can follow the notes below to create the custom properties, or you can email help@ceojuice.com to ask our help desk to create the custom properties for you.

ZCJMakeWtyDays

Custom Property for number of days to consider part:

Attribute name: ZCJMakeWtyDays

Description: Days Warranty from Install/Last Use on Parts

Data type: Numeric

ZCJMakeWtyDays.png

This attribute should be added to BOTH the Make custom property configuration AND the Item custom property configuration.

Expand to show screenshots:

Make properties:

assign days to make.png

Item properties:

assign days to item.png

ZCJMakeWtyMinCost

Custom Property for minimum cost to use when part is short of expected yield:

Attribute name: ZCJMakeWtyMinCost

Description: Days Warranty from Install/Last Use on Parts

Data type: Numeric

ZCJMakeWtyMinCost.png

This custom property should only be added to the Make custom property configuration.

Expand to show screenshot:

Make properties:

assign cost to make.png

*  *  *

Related Alerts

Related Alerts

*We understand that this logic may not be true for all manufacturers, which is why we have different versions of this logic for specific manufacturers:

ID919 - Konica Minolta warranty returns

ID921 - Canon/HP warranty returns

If you subscribe to either of these alerts, ID90 will exclude items from reporting that are captured by either of these alerts, so no information is duplicated on ID90.

ID189 - Item records missing Yield information

ID443 - Alert at the end of the day for Closed Calls with Equipment still under warranty

ID561 - New Call Opened for Equipment Still Under Warranty

ID571 - Items with Incorrect or Missing Yields

*  *  * 

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