Update the standard cost on an item with the average cost.
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview
Overview
In e-automate, the Standard Cost field is only used when creating a purchase order for an item that does not have any vendors set up; in such cases, e-automate defaults to the standard cost. This process will update the standard cost field with the current average cost of the item. The alert will only update items with an inventory code specified in Variable W or X. This alert does install in test mode so that you can see what items would be updated prior to making any changes in production.
Run Schedule: Daily at 5:30 pm
Type of Output: Email
* * *
Sample
Sample
* * *
Variables
Variables
Variable W: Inventory Code - Enter a word or string of characters contained in the inventory code description to identify the items to update.
Variable X: Additional Inventory code - Optional to add a second word or string contained in the inventory description for the alert to trigger on.
* * *
Alert Functionality
Alert Functionality
1. This alert will install in TEST mode; in this mode, no items will be updated in e-automate. You'll receive a daily list showing the items that would have been updated.
2. For an item to trigger the alert, it has to be active and have its average cost above $0.01. The average price of an item can be found by going to Items - Item Prices:
3. The average cost must also not be equal to the standard cost on the item. Standard cost is found on the item record:
4. The item must have an inventory code that contains the string set in Variable W. Inventory codes are set on the item record:
You can find the whole list of inventory codes under Tools - Lists and Codes - Inventory Codes:
If 'Parts' was entered into Variable W, the alert would trigger for items with the inventory code Inventory Parts and MNS Parts.
* * *
Best Practices & Tips
Best Practices & Tips
None at this time.
* * *
Related Alerts
Related Alerts
ID62 - Update Parts and/or Supplies Retail Price
* * *
0 Comments