This alert will tell you whenever a Vendor's cost changes by more than X%.
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview
Overview
This alert creates a nightly snapshot of vendor item cost to find items that have changed cost by more than Variable W percentage. The items meeting this criterion are shown in the email output. This task can run daily or monthly, or daily and monthly. Just let us know at help@ceojuice.com.
Run Schedule: Daily at 7 AM or Monthly on the last day of the month at 6:30 PM
Type of Output: Email
* * *
Sample
Sample
* * *
Variables
Variables
Variable W: % Change to Alert on - Enter the percent change to alert on, enter as a whole number. (5 checks for a 5% variance)
* * *
Alert Functionality
Alert Functionality
1. The alert logic creates a snapshot of the vendor item pricing on each trigger, then compares the current vendor pricing to the snapshot from the previous run. Vendor pricing is set on the vendor tab of the item record:
2. The alert calculates the percent change in price as: (CostDifference/PreviousCost) * 100.
3. When the percent change exceeds the value set in Variable W, the alert will trigger for the item.
4. As an example, the vendor cost for Vendor Elite Paper Goods on item AT-12345 is set as $75.00. If the vendor cost for this vendor was updated to $125.00, the alert would calculate the percent change as (($125- $75) / $75.00) * 100 = 66.66%.
* * *
Best Practices & Tips
Best Practices & Tips
None at this time.
* * *
Related Alerts
Related Alerts
ID613 - Vendor Cost Variance on a PO Received to PO Voucher.
* * *
0 Comments