Compares item yields to a validated CEO Juice table of yield information and reports on items where the yield differs from the CEO Juice table.
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview
Overview
This alert checks your active item records against a CEO Juice table and advises of items with incorrect or missing yields, with an option to have CEO Juice update the item records in e-automate. The alert assumes you are using the OEM part number as either the primary item number or listed as the manufacturer item number on the Vendor tab of the item record.
At your request, we can update your yields from our master table, which is compiled from the data of other clients subscribed to this alert. If you have not yet implemented ID90/Warranty Parts or ID315/Excessive Toner because of the work involved in acquiring or updating yield info, this process could save you a lot of effort.
Please note, by subscribing to this alert, you are permitting us to push your yield information into our master table, if needed.
Run Schedule: Quarterly, 1st of Jan, April, July, and October
Type of Output: Email
* * *
Sample
Sample
Item: The item number from e-automate.
Description: The description of the item from e-automate.
Your Yield: The yield shown on the item in e-automate.
CEO Juice Yield: The yield for the item from the CEO Juice table.
Annual Usage: The annual usage of the item on sales orders and service calls.
Validation: The validation number from the CEO Juice table. A zero indicates that this is the yield from the manufacturer. Anything higher is the number of CEO Juice clients that have validated the yield as correct.
* * *
Variables
Variables
This alert has no variables
* * *
Alert Functionality
Alert Functionality
This alert checks for a match between the item numbers in your e-automate database and the CEO Juice yield table. The process first checks for a match based on the item number in e-automate:
The process will then check for any manufacturer item numbers that match the items in the CEO Juice table:
The process assumes that the OEM part number is in one of these places in e-automate and is an exact match to the OEM part number.
The emailed output of the alert lists any items where the yield in e-automate does not match the yield in the CEO Juice table and the item is active. The items on the email are sorted by the annual usage of the item, the validation number, and then in alphabetical order by item number.
The validation number is based on the data in the CEO Juice table. A zero indicates that this is the yield from the manufacturer. Anything higher is the number of CEO Juice clients that have validated the yield as correct.
We will not automatically push the yields into your database, you must reach out to help@ceojuice.com to request that. When requesting, send us the report you received via ID571 and ask us to update within your e-automate. The idea is that we can mass import the large list from the first run, and from there, you can manually update when smaller lists are sent to you as upkeep. Should the list ever be long, and you'd like us to push in yields again, we're happy to do so; just reach out to us.
We do not have a master list from our table that we can provide, but your output will show what we would be pushing in under the CEO Juice Yield column.
* * *
Best Practices & Tips
Best Practices & Tips
If you have not yet implemented ID90/Warranty Parts or ID315/Excessive Toner because of the work involved in acquiring or updating yield info, this process will save you a lot of effort.
* * *
Related Alerts
Related Alerts
ID189 - Parts Item records Missing Yield
ID316 - Toner Items Missing Copy Yields or Usage Limit Meter Types
* * *
0 Comments