Skip to content

Latest commit

 

History

History
81 lines (69 loc) · 2.61 KB

ASSEMBLY_ITEM_NOTIFICATIONS.md

File metadata and controls

81 lines (69 loc) · 2.61 KB
Raw

ASSEMBLY ITEM NOTIFICATIONS

Assembly Item Low Stock Notifications are triggered when an assembly build item's inventory falls below the min value set.

The Assembly Notification script(s) (map/reduce) are set to run every 30 min, everyday.

Requirements:

  • MW Assembly Notification Min Qty and Townsend Assembly Notification Min Qty must contain a numeric value. This value will be used as the minimum quantity. When the item's inventory available quantity drops below the min quantity the item will be added to a list and sent out as a notification.
  • A date/time will be added to the MW Assembly Notification Date Added / Townsend Assembly Notification Date Added field. This date/time represents the date/time that the assembly item notification was sent.
  • A Notification Record (custom record) will also be created with type, location, and send date fields being populated.

Setup:

  • The script deployment has settings to add email recipients. Email recipients are added by adding their employee internal id's to the list.

Example Email Notification:

SKU Name Qty Available (MW) Qty Available (TWN) Qty Available (ALL) Min Qty (MW) Buildable TWN Buildable All Date Added Action
P486NN Black Amber Aftershave - 3.3 oz 118 1011 1141 125 7644 7644 2024-06-17 Transfer to Main Warehouse
P487NN Dark Clove - 3.3 oz 85 0 99 95 5000 5000 2024-06-17 Build at least 10 units to satisfy MW min

Reset:

The Assembly Notification Reset Script(s) are set to run every 30 min, everyday. The reset script will look for all assembly build items with a valid value set in the MW Assembly Notification Date Added / Townsend Assembly Notification Date Added field. It will then check if the inventory available quantity is above the min quantity. If it is, it will clear the date added field, if it is not it will skip the item.

Example Reset Email Notification:

SKU Name Qty Available Min Qty Buildable Date Removed
K-P004 Grooming Spray (Non-Aerosol Hairspray) - 6 Pack 480 365 133 2024-06-28