Real-time notification of potential duplicate toner order
Jump To: Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts | Task App
Overview
Overview
We have seen situations where a customer places a toner order online, then calls it in and so does their colleague and you ship three sets of toners in one day. This alert is to just raise a flag whenever a supply order is created where the item ordered for a particular equipment ID had been previously ordered for the same equipment in the past VariableW calendar days you specify.
Run Schedule: Every 15-minutes / End of Day Summary sends at end of day
Type of Output: Email and Task App
* * *
Sample
Sample
Daily Summary (optional via Variable1):
* * *
Variables
Variables
Variable W: Enter quantity of calendar days back to check for same supply item ordered for same equipment ID that was shipped
Variable X: Enter Order Type containing this string OR enter EXACT Order Type(s) to trigger on, separate by comma (i.e. Supply, Supplies, Rental)
Variable Y: Custom Property to exclude Bill To customers from this process
Variable Z: Enter Branch Numbers for alert to trigger on, separated by comma OR leave blank for ALL
Variable 1: Selecting 'Yes' will send a summary of all possible duplicate orders from last 24-hours (Monday's since Friday) every evening. **Please note, Summary will only send to those emails listed in TO/CC/BCC of your subscription.
* * *
Alert Functionality
Alert Functionality
1. Considers any Order Type containing string listed in VariableX, 'Supp' by default. You can specify a different string in VariableX if you only want us to check a specific order type. Alternatively, you can list exact Order Type(s) separated by comma in VariableX rather than have it consider a string.
2. Considers Sales Orders Fulfilled in the last W days and all Sales Orders not yet fulfilled. This at the Sales Order Level, not the line item level. The logic has to assume orders fulfilled and completed in short order because one of the whole points is to catch multiple orders coming in at the same time through different channels or to different personnel. If any previous order is still open the alert will still fire regardless of look back days set on VariableW.
3. Alert summary email shows both Original Qty and Current Qty. The Original quantity is the quantity on the Sales Order when the alert first ran (it’s scheduled to run every 15mins so will pick up orders as they are placed). Current quantity is the quantity on Sales Order when the Summary Report ran at the end of the day.
4. Summary email ONLY sends to those emails listed in TO/CC/BCC.
* * *
Best Practices & Tips
Best Practices & Tips
Custom Property Set Up
This alert automatically installs, so you will need to create Custom Property ZCJDuplicateToner
Step 1:
Create new attribute via Tools / Lists & Codes / Attributes:
Attribute name: ZCJDuplicateToner
Description: Exclude from Duplicate Toner Notice ID215
Data type: User-Defined Lookup
Lookup list: Exclude / Include
Step 2:
Add Attribute to Customer Record Configuration via Tools / Lists & Codes / Configurations (custom properties):
*leave default value blank*
-As of eAuto 8.5, ECi has added similar functionality:
It considers Sales Orders Fulfilled in the last look back days and all orders not yet fulfilled. However, please note this at the Sales Order level, not the line item level like our alert.
* * *
Related Alerts
Related Alerts
ID23 - Supplies Shipped at N/C but also no contract coverage
ID315 - Excessive Toner Alert
ID875 - Possible Duplicate Shipment Notification - Billable Orders
* * *
ask App
Task App
Please see THIS LINK for review.
0 Comments